

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** 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_SID=PROD
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
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:44 2015

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

SQL> Connected.
SQL> SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
undo_retention			     integer	 900
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


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:44 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
------------------------------ --------------- -----------
UNDOTBS1		       ONLINE	       GUARANTEE

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.4


A: UNDOTBS1		       ONLINE	       GUARANTEE


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

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

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

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

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: 40


R101021=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:45 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:46

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:58:20
Uptime                    0 days 0 hr. 5 min. 26 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/lsnr2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
The command completed successfully


R201010=0


A: TNS-12541: TNS:no listener


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

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

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:58:20
Uptime                    0 days 0 hr. 5 min. 26 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/lsnr2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
The command completed successfully


R201020=0


A: TNS-12541: TNS:no listener


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

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

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:58:20
Uptime                    0 days 0 hr. 5 min. 26 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/lsnr2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
The command completed successfully


R201030=0


A: TNS-12541: TNS:no listener


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

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

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:58:20
Uptime                    0 days 0 hr. 5 min. 26 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/lsnr2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
The command completed successfully


R201040=0


A: TNS-12541: TNS:no listener


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

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

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:58:20
Uptime                    0 days 0 hr. 5 min. 27 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/lsnr2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
The command completed successfully


R201051=0


A: TNS-12541: TNS:no listener
tail: cannot open `/u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc' for reading: No such file or directory


R201052=0




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

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

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:58:20
Uptime                    0 days 0 hr. 5 min. 27 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/lsnr2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
The command completed successfully


R202001=0.05


A: 0

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

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:58:20
Uptime                    0 days 0 hr. 5 min. 27 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/lsnr2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
The command completed successfully


R202001=.10


B: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))

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

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:58:20
Uptime                    0 days 0 hr. 5 min. 27 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/lsnr2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
The command completed successfully


R202002=0.05


A: 0

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

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:58:20
Uptime                    0 days 0 hr. 5 min. 27 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/lsnr2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
The command completed successfully


R202002=.30


B: 0


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

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

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:58:20
Uptime                    0 days 0 hr. 5 min. 28 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/lsnr2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
The command completed successfully


R203000=0.05


A: 0

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

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:58:20
Uptime                    0 days 0 hr. 5 min. 28 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/lsnr2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
The command completed successfully


R203000=.15


B: LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:48
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
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/lsnr2.log
Service "PROD" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...


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

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

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:58:20
Uptime                    0 days 0 hr. 5 min. 28 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/lsnr2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
The command completed successfully


R204001=0


A: 0

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

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:58:20
Uptime                    0 days 0 hr. 5 min. 28 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/lsnr2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.9)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 4 handler(s) for this service...
The command completed successfully


R204002=0.1


A: tcp        0      0 192.168.0.9:1526            0.0.0.0:*                   LISTEN      4458/tnslsnr        


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


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

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

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

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

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: 40


R301001=0



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

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

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

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:50 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(PROTOCOL=TCP)(DISPATCHERS=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:50 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:51 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


R303010=0.15




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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:51 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:51 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:52

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

Used parameter files:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=PROD))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.9)(PORT=1521)))
TNS-12541: TNS:no listener


R401000=0




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

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:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.9)(PORT = 1526))) (CONNECT_DATA = (SERVER = DEDICATED)))
OK (10 msec)

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:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.9)(PORT = 1526))) (CONNECT_DATA = (SERVER = DEDICATED)))
OK (10 msec)


R402000=0


A: 0


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

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:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.9)(PORT = 1526))) (CONNECT_DATA = (SERVER = SHARED)))
OK (0 msec)

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:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.9)(PORT = 1526))) (CONNECT_DATA = (SERVER = SHARED)))
OK (0 msec)


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:53

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

Used parameter files:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

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

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

Used parameter files:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

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:13

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

Used parameter files:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name
192.168.0.10
station10.example.com

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:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name


R405000=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:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name


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:34

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

Used parameter files:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

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

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

Used parameter files:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

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:34

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

Used parameter files:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

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:54 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:54 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:55 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:55 2015

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

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES   MAXBYTES
------------------------------ ---------- ----------
EXAMPLE 			419430400 4.3980E+12

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:55 2015

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

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES   MAXBYTES
------------------------------ ---------- ----------
EXAMPLE 			419430400 4.3980E+12

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.3


A: EXAMPLE 			419430400 4.3980E+12

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

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

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES   MAXBYTES
------------------------------ ---------- ----------
EXAMPLE 			419430400 4.3980E+12

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 4.3980E+12


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

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

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

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

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	YES


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

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

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

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

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   YES


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


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


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:57 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:57 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:57 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:57 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:58 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:58 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:58 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:58 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:59 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:59 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:05:00 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:05:00 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:05:00 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:05:00 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:05:00 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:05:01 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:05:01 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:05:02 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:05:02 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:05:02 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	       7  104857600	     2 NO  CURRENT		   179652 10-JAN-15
	 2	    1	       5  104857600	     2 YES INACTIVE		   170250 10-JAN-15
	 3	    1	       6  104857600	     1 YES INACTIVE		   179626 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 ********************
2
2
2
2
1
R1103000=.80


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


******************** TOPIC 11.5 ********************
      1 Disk3
      2 Disk1
      2 Disk2
      2 Disk4
      2 Disk5

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:05:05 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: 2


R1105000=0.5




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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:05:05 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/Disk3/control01.ctl
/u01/app/oracle/oradata/PROD/Disk4/control02.ctl
/u01/app/oracle/oradata/PROD/Disk5/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:05:06 2015

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

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

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


R1300000=0.1




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


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:05:06 2015

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

SQL> Connected.
SQL> SQL> SQL> 
 ANALYZEDT
----------
16445.7952

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: 16445


R1400010=0




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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:05:07 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:05:07 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:05:07 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:05:07 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:05:08 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 full is 0.15 0.75
R101012: 0.4 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: .80 full is 1.00 3.1
R1104000: .50 full is .50 3.6
R1105000: 0.5 full is 0.5 4.1
R1200000: 0.5 full is 0.5 4.6
R1300000: 0.1 full is 0.1 4.7
R1400010: 0 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: 0 full is 0.1 6.35
R201020: 0 full is 0.1 6.45
R201030: 0 full is 0.33 6.78
R201040: 0 full is 0.24 7.02
R201051: 0 full is 0.23 7.25
R201052: 0 full is 0.1 7.35
R202001: .10 full is 0.1 7.45
R202002: .30 full is 0.3 7.75
R203000: .15 full is 0.15 7.9
R204001: 0 full is 0.1 8.0
R204002: 0.1 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.15 full is 0.15 8.8
R303020: 0.1 full is 0.1 8.9
R401000: 0 full is 0.1 9.0
R402000: 0 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.3 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.90


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