

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** Section1 ********************
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


******************** TOPIC 1 ********************
export ORACLE_SID=PROD
.bash_profile OK



# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=PROD
export PATH=$ORACLE_HOME/bin:$PATH
export LANG=en_US


******************** TOPIC 1.1 ********************


******************** TOPIC 1.1.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:23 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
undo_retention			     integer	 5400
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R101011=0.15


A: undo_retention			     integer	 5400

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:24 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
PL/SQL procedure successfully completed.

SQL> 
PL/SQL procedure successfully completed.

SQL> 
PL/SQL procedure successfully completed.

SQL> 
PL/SQL procedure successfully completed.

SQL> 
PL/SQL procedure successfully completed.

SQL> SQL> SQL> SQL> 
no rows selected

SQL>   2  
no rows selected

SQL> 
TABLESPACE_NAME 	       STATUS	       RETENTION
------------------------------ --------------- -----------
UNDOTBS 		       ONLINE	       NOGUARANTEE

SQL> 
FILE_NAME							  STATUS
----------------------------------------------------------------- ---------------
/u01/app/oracle/oradata/PROD/Disk3/undotbs01.dbf		  AVAILABLE

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R101012=0


A: 0


******************** TOPIC 1.1.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:24 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
50

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 50


R101021=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:25 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 0


R101022=0




******************** TOPIC 2 ********************


******************** TOPIC 2.1 ********************


******************** TOPIC 2.1.1 ********************

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:25

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:51:39
Uptime                    0 days 1 hr. 11 min. 45 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully


R201010=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:25

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:51:39
Uptime                    0 days 1 hr. 11 min. 45 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully


R201010=.05


B: 0


******************** TOPIC 2.1.2 ********************

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:26

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:51:39
Uptime                    0 days 1 hr. 11 min. 46 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully


R201020=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:26

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:51:39
Uptime                    0 days 1 hr. 11 min. 46 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully


R201020=.10


B: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))


******************** TOPIC 2.1.3 ********************

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:26

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:51:39
Uptime                    0 days 1 hr. 11 min. 46 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully


R201030=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:26

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:51:39
Uptime                    0 days 1 hr. 11 min. 46 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully


R201030=.33


B:   Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...


******************** TOPIC 2.1.4 ********************

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:26

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:51:39
Uptime                    0 days 1 hr. 11 min. 46 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully


R201040=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:26

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:51:39
Uptime                    0 days 1 hr. 11 min. 46 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully


R201040=.24


B:   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))


******************** TOPIC 2.1.5 ********************

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:27

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:51:39
Uptime                    0 days 1 hr. 11 min. 47 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully


R201051=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:27

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:51:39
Uptime                    0 days 1 hr. 11 min. 47 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully


R201051=.05


B: 0
nsclose: global context check-out (from slot 5) complete
nsglhfre: Deallocating cxd 0x902ae20.
nstimarmed: no timer allocated
nstoClearTimeout: ATO disabled for ctx=0x0x90167c0
nstoClearTimeout: STO disabled for ctx=0x0x90167c0
nstoClearTimeout: RTO disabled for ctx=0x0x90167c0
nstoClearTimeout: PITO disabled for ctx=0x0x90167c0
nstoUpdateActive: Active timeout is -1 (see nstotyp)
nsclose: closing transport
nsclose: global context check-out (from slot 0) complete


R201052=0.1




******************** TOPIC 2.2 ********************

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:27

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=192.168.0.13)(KEY=extproc))(CONNECT_DATA=(SID=PROD)))
TNS-12538: TNS:no such protocol adapter
 TNS-12560: TNS:protocol adapter error
  TNS-00508: No such protocol adapter



R202001=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:27

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=192.168.0.13)(KEY=extproc))(CONNECT_DATA=(SID=PROD)))
TNS-12538: TNS:no such protocol adapter
 TNS-12560: TNS:protocol adapter error
  TNS-00508: No such protocol adapter



R202001=.05


B: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:28

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=192.168.0.13)(KEY=extproc))(CONNECT_DATA=(SID=PROD)))
TNS-12538: TNS:no such protocol adapter
 TNS-12560: TNS:protocol adapter error
  TNS-00508: No such protocol adapter



R202002=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:28

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=192.168.0.13)(KEY=extproc))(CONNECT_DATA=(SID=PROD)))
TNS-12538: TNS:no such protocol adapter
 TNS-12560: TNS:protocol adapter error
  TNS-00508: No such protocol adapter



R202002=.30


B: 0


******************** TOPIC 2.3 ********************

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:28

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=192.168.0.13)(KEY=extproc))(CONNECT_DATA=(SID=PROD)))
TNS-12538: TNS:no such protocol adapter
 TNS-12560: TNS:protocol adapter error
  TNS-00508: No such protocol adapter



R203000=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:28

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=192.168.0.13)(KEY=extproc))(CONNECT_DATA=(SID=PROD)))
TNS-12538: TNS:no such protocol adapter
 TNS-12560: TNS:protocol adapter error
  TNS-00508: No such protocol adapter



R203000=.15


B: LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:28
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=192.168.0.13)(KEY=extproc))(CONNECT_DATA=(SID=PROD)))


******************** TOPIC 2.4 ********************

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:28

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=192.168.0.13)(KEY=extproc))(CONNECT_DATA=(SID=PROD)))
TNS-12538: TNS:no such protocol adapter
 TNS-12560: TNS:protocol adapter error
  TNS-00508: No such protocol adapter



R204001=0.1


A: tcp        0      0 192.168.0.13:1521           0.0.0.0:*                   LISTEN      3374/tnslsnr        

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:28

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=192.168.0.13)(KEY=extproc))(CONNECT_DATA=(SID=PROD)))
TNS-12538: TNS:no such protocol adapter
 TNS-12560: TNS:protocol adapter error
  TNS-00508: No such protocol adapter



R204002=0


A: 0


******************** TOPIC 3 ********************


******************** TOPIC 3.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:29 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
50

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 50


R301001=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:29 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
10

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301002=0




******************** TOPIC 3.2 ********************


******************** TOPIC 3.2.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:29 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(PROT=tcp)(DISP=3)

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 3


R302010=0.15




******************** TOPIC 3.2.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:30 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
10

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 10


R302020=0.1




******************** TOPIC 3.3 ********************


******************** TOPIC 3.3.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:30 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 0


R303010=0




******************** TOPIC 3.3.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:30 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
30

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 30


R303020=0.05



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:30 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
30

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 30


R303020=0.1




******************** TOPIC 4 ********************


******************** TOPIC 4.1 ********************

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:31

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=PROD))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.13)(PORT=1521)))
OK (0 msec)


R401000=0.1




******************** TOPIC 4.2 ********************

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:31

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=PROD)))
OK (0 msec)

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:31

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=PROD)))
OK (0 msec)


R402000=0.1


A: Attempting to contact (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=PROD)))


******************** TOPIC 4.3 ********************

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:32

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

TNS-03505: Failed to resolve name

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:32

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

TNS-03505: Failed to resolve name


R403000=0


A: 0


******************** TOPIC 4.4 ********************

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:52

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

TNS-03505: Failed to resolve name

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:52

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

TNS-03505: Failed to resolve name


R404000=0


A: 0


******************** TOPIC 4.5 ********************

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:12

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp)(HOST=192.168.0.14)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=EMREP)))
TNS-12541: TNS:no listener
192.168.0.14
station14.example.com

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:12

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp)(HOST=192.168.0.14)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=EMREP)))
TNS-12541: TNS:no listener


R405000=0.1


A: Attempting to contact (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp)(HOST=192.168.0.14)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=EMREP)))

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:12

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp)(HOST=192.168.0.14)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=EMREP)))
TNS-12541: TNS:no listener


R405000=0


A: 0


******************** TOPIC 4.6 ********************

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:13

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

TNS-03505: Failed to resolve name

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:13

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

TNS-03505: Failed to resolve name


R406000=0


A: 0

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:13

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

TNS-03505: Failed to resolve name


R406000=0


A: 0


******************** TOPIC 5 ********************


******************** TOPIC 5.1 ********************


******************** TOPIC 5.1.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:33 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
GROUP_NAME		       TABLESPACE_NAME
------------------------------ ------------------------------
TEMP_GRP		       TEMP1
TEMP_GRP		       TEMP2

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501010=0.25


A: TEMP_GRP		       TEMP1

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:33 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
GROUP_NAME		       TABLESPACE_NAME
------------------------------ ------------------------------
TEMP_GRP		       TEMP1
TEMP_GRP		       TEMP2

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501010=.50


B: TEMP_GRP		       TEMP2


******************** TOPIC 5.1.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:34 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> 
PROPERTY_NAME		       PROPERTY_VALUE
------------------------------ ------------------------------------------------------------
DEFAULT_TEMP_TABLESPACE        TEMP_GRP

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501020=0.4


A: DEFAULT_TEMP_TABLESPACE        TEMP_GRP


******************** TOPIC 6 ********************


******************** TOPIC 6.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:34 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES   MAXBYTES
------------------------------ ---------- ----------
EXAMPLE 			419430400	   0

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R601000=0.3


A: 0


******************** TOPIC 6.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:34 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES   MAXBYTES
------------------------------ ---------- ----------
EXAMPLE 			419430400	   0

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R602001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:34 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES   MAXBYTES
------------------------------ ---------- ----------
EXAMPLE 			419430400	   0

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R602002=0.1


A: EXAMPLE 			419430400	   0


******************** TOPIC 6.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:35 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 	       INITIAL_EXTENT ALLOCATIO BIG
------------------------------ -------------- --------- ---
EXAMPLE 			      1048576 UNIFORM	NO

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R603000=0.2


A: EXAMPLE 			      1048576 UNIFORM	NO


******************** TOPIC 6.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:35 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 	       NEXT_EXTENT ALLOCATIO BIG
------------------------------ ----------- --------- ---
EXAMPLE 			   1048576 UNIFORM   NO

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R604000=0.2


A: EXAMPLE 			   1048576 UNIFORM   NO


******************** TOPIC 7 ********************


******************** TOPIC 7.1 ********************


******************** TOPIC 7.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:35 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES
------------------------------ ----------
INDX				 41943040

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R700000=0.05


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:35 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES
------------------------------ ----------
INDX				 41943040

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R700000=.10


B: INDX				 41943040


******************** TOPIC 8 ********************


******************** TOPIC 8.1 ********************


******************** TOPIC 8.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:36 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES
------------------------------ ----------
TOOLS				 10485760

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R800000=0.05


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:36 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES
------------------------------ ----------
TOOLS				 10485760

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R800000=.20


B: TOOLS				 10485760


******************** TOPIC 9 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:36 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> 
PROPERTY_NAME		       PROPERTY_VALUE
------------------------------ ------------------------------------------------------------
DEFAULT_PERMANENT_TABLESPACE   USERS

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R900000=0.05


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:36 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> 
PROPERTY_NAME		       PROPERTY_VALUE
------------------------------ ------------------------------------------------------------
DEFAULT_PERMANENT_TABLESPACE   USERS

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R900000=.30


B: DEFAULT_PERMANENT_TABLESPACE   USERS


******************** TOPIC 9.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:37 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES
------------------------------ ----------
USERS				 50331648

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R901000=0.1


A: 0


******************** TOPIC 9.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:37 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES
------------------------------ ----------
USERS				 50331648

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R902000=0.1


A: USERS				 50331648


******************** TOPIC 9.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:37 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 	       INITIAL_EXTENT ALLOCATIO BIG
------------------------------ -------------- --------- ---
USERS				      4194304 UNIFORM	NO

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R903000=0.2


A: USERS				      4194304 UNIFORM	NO


******************** TOPIC 9.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:38 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 	       NEXT_EXTENT ALLOCATIO BIG
------------------------------ ----------- --------- ---
USERS				   4194304 UNIFORM   NO

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R904000=0.2


A: USERS				   4194304 UNIFORM   NO


******************** TOPIC 10 ********************


******************** TOPIC 10.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:38 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES
------------------------------ ----------
OLTP				 50331648

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R1001000=0.1


A: 0


******************** TOPIC 10.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:38 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES
------------------------------ ----------
OLTP				 50331648

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R1002000=0.05


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:38 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES
------------------------------ ----------
OLTP				 50331648

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R1002000=.10


B: OLTP				 50331648


******************** TOPIC 10.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:39 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 	       INITIAL_EXTENT ALLOCATIO BIG
------------------------------ -------------- --------- ---
OLTP				      2097152 UNIFORM	NO

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R1003000=0.05


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:39 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 	       INITIAL_EXTENT ALLOCATIO BIG
------------------------------ -------------- --------- ---
OLTP				      2097152 UNIFORM	NO

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R1003000=.15


B: OLTP				      2097152 UNIFORM	NO


******************** TOPIC 10.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:39 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 	       NEXT_EXTENT ALLOCATIO BIG
------------------------------ ----------- --------- ---
OLTP				   2097152 UNIFORM   NO

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R1004001=0.05


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:39 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 	       NEXT_EXTENT ALLOCATIO BIG
------------------------------ ----------- --------- ---
OLTP				   2097152 UNIFORM   NO

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R1004001=.15


B: OLTP				   2097152 UNIFORM   NO

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:40 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
SEGMEN
------
AUTO

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R1004002=0.05


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:40 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
SEGMEN
------
AUTO

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R1004002=.10


B: AUTO


******************** TOPIC 11 ********************


******************** TOPIC 11.1 ********************


******************** TOPIC 11.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:40 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> 
    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS	    FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
	 1	    1	       4  104857600	     1 NO  CURRENT		   133163 10-JAN-15
	 2	    1	       2  104857600	     1 YES INACTIVE		    67395 10-JAN-15
	 3	    1	       3  104857600	     1 YES INACTIVE		   102972 10-JAN-15
	 4	    1	       0  104857600	     2 YES UNUSED			0
	 5	    1	       0  104857600	     2 YES UNUSED			0

SQL> 
  COUNT(*)
----------
	 5

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 	 5


R1102000=0.5




******************** TOPIC 11.3 ********************
1
1
2
2
1
R1103000=.40


******************** TOPIC 11.4 ********************
5
0
R1104000=.50


******************** TOPIC 11.5 ********************
      1 Disk1
      3 Disk2
      3 Disk3

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:43 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     BYTES
----------
 104857600
 104857600
 104857600
 104857600
 104857600

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 3


R1105000=0




******************** TOPIC 12 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:43 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> 
PL/SQL procedure successfully completed.

SQL> ******************************

PL/SQL procedure successfully completed.

SQL> The database controlfile here:

PL/SQL procedure successfully completed.

SQL> ******************************

PL/SQL procedure successfully completed.

SQL> 
PL/SQL procedure successfully completed.

SQL> SQL> 
NAME
-----------------------------------------------------------------
/u01/app/oracle/oradata/PROD/Disk1/control01.ctl
/u01/app/oracle/oradata/PROD/Disk2/control02.ctl
/u01/app/oracle/oradata/PROD/Disk3/control03.ctl

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 3


R1200000=0.5




******************** TOPIC 13 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:43 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> 
  COUNT(*)
----------
	 2

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 	 2


R1300000=0




******************** TOPIC 14 ********************


******************** TOPIC 14.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:44 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> 
 ANALYZEDT
----------
.060439815

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 0


R1400010=0.5




******************** TOPIC 14.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:44 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R1402001=0.4


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:45 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
VALUE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R1402002=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:45 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
VALUE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R1402002=0


B: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:45 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
VALUE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R1402002=0


C: 0


******************** TOPIC 15 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:45 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
LOG_MODE
------------
ARCHIVELOG

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R1500000=0.25


A: ARCHIVELOG

****************************************************************************************************


R1001000: 0.1 full is 0.1 0.1
R1002000: .10 full is 0.1 0.2
R1003000: .15 full is 0.15 0.35
R1004001: .15 full is 0.15 0.5
R1004002: .10 full is 0.1 0.6
R101011: 0.15 full is 0.15 0.75
R101012: 0 full is 0.4 1.15
R101021: 0 full is 0.3 1.45
R101022: 0 full is 0.15 1.6
R1102000: 0.5 full is 0.5 2.1
R1103000: .40 full is 1.00 3.1
R1104000: .50 full is .50 3.6
R1105000: 0 full is 0.5 4.1
R1200000: 0.5 full is 0.5 4.6
R1300000: 0 full is 0.1 4.7
R1400010: 0.5 full is 0.5 5.2
R1402001: 0.4 full is 0.4 5.6
R1402002: 0 full is 0.4 6.0
R1500000: 0.25 full is 0.25 6.25
R201010: .05 full is 0.1 6.35
R201020: .10 full is 0.1 6.45
R201030: .33 full is 0.33 6.78
R201040: .24 full is 0.24 7.02
R201051: .05 full is 0.23 7.25
R201052: 0.1 full is 0.1 7.35
R202001: .05 full is 0.1 7.45
R202002: .30 full is 0.3 7.75
R203000: .15 full is 0.15 7.9
R204001: 0.1 full is 0.1 8.0
R204002: 0 full is 0.1 8.1
R301001: 0 full is 0.1 8.2
R301002: 0 full is 0.2 8.4
R302010: 0.15 full is 0.15 8.55
R302020: 0.1 full is 0.1 8.65
R303010: 0 full is 0.15 8.8
R303020: 0.1 full is 0.1 8.9
R401000: 0.1 full is 0.1 9.0
R402000: 0.1 full is 0.1 9.1
R403000: 0 full is 0.1 9.2
R404000: 0 full is 0.1 9.3
R405000: 0 full is 0.1 9.4
R406000: 0 full is 0.4 9.8
R501010: .50 full is 0.5 10.3
R501020: 0.4 full is 0.4 10.7
R601000: 0.3 full is 0.3 11.0
R602001: 0 full is 0.3 11.3
R602002: 0.1 full is 0.1 11.4
R603000: 0.2 full is 0.2 11.6
R604000: 0.2 full is 0.2 11.8
R700000: .10 full is 0.1 11.9
R800000: .20 full is 0.2 12.1
R900000: .30 full is 0.3 12.4
R901000: 0.1 full is 0.1 12.5
R902000: 0.1 full is 0.1 12.6
R903000: 0.2 full is 0.2 12.8
R904000: 0.2 full is 0.2 13.0
full of this section:
RESULT:
8.72


****************************************************************************************************
