

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** 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_SID=PROD
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:16 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:17 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/undotbs1.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:17 2015

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

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

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


R101021=0



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

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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
VALUE_A: 12


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

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:05:25
Uptime                    0 days 0 hr. 57 min. 53 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station25.example.com)(PORT=1521)))
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.05


A: 0

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

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:05:25
Uptime                    0 days 0 hr. 57 min. 53 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station25.example.com)(PORT=1521)))
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=.10


B:   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station25.example.com)(PORT=1521)))


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

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

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:05:25
Uptime                    0 days 0 hr. 57 min. 54 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station25.example.com)(PORT=1521)))
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.05


A: 0

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

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:05:25
Uptime                    0 days 0 hr. 57 min. 54 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station25.example.com)(PORT=1521)))
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=.10


B: Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station25.example.com)(PORT=1521)))


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

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

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:05:25
Uptime                    0 days 0 hr. 57 min. 54 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station25.example.com)(PORT=1521)))
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.05


A: 0

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

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:05:25
Uptime                    0 days 0 hr. 57 min. 54 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station25.example.com)(PORT=1521)))
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=.05


B: 0


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

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

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:05:25
Uptime                    0 days 0 hr. 57 min. 55 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station25.example.com)(PORT=1521)))
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.05


A: 0

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

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:05:25
Uptime                    0 days 0 hr. 57 min. 55 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station25.example.com)(PORT=1521)))
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=.05


B: 0


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

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

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:05:25
Uptime                    0 days 0 hr. 57 min. 55 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station25.example.com)(PORT=1521)))
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.05


A: 0

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

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 18:05:25
Uptime                    0 days 0 hr. 57 min. 55 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station25.example.com)(PORT=1521)))
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=.05


B: 0
nsclose: global context check-out (from slot 4) complete
nsglhfre: Deallocating cxd 0x9392370.
nstimarmed: no timer allocated
nstoClearTimeout: ATO disabled for ctx=0x0x9382590
nstoClearTimeout: STO disabled for ctx=0x0x9382590
nstoClearTimeout: RTO disabled for ctx=0x0x9382590
nstoClearTimeout: PITO disabled for ctx=0x0x9382590
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:20

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

TNS-01101: Could not find service name 


R202001=0.05


A: 0

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

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

TNS-01101: Could not find service name 


R202001=.05


B: 0

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

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

TNS-01101: Could not find service name 


R202002=0.05


A: 0

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

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

TNS-01101: Could not find service name 


R202002=.30


B: 0


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

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:01

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

TNS-01101: Could not find service name 


R203000=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:01

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

TNS-01101: Could not find service name 


R203000=.15


B: LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:01


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

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:01

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

TNS-01101: Could not find service name 


R204001=0.1


A: tcp        0      0 0.0.0.0:1521                0.0.0.0:*                   LISTEN      13223/tnslsnr       

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:01

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

TNS-01101: Could not find service name 


R204002=0


A: 0


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


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

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

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

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

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


R301001=0



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

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

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

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:04:23 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:04:23 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:04:24 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


R303010=0.15




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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:24 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
VALUE_A: 0


R303020=0




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


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

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

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.25)(PORT=1521)))
OK (10 msec)


R401000=0.1




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

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

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.25)(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:04:25

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.25)(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.25)(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:04:25

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.25)(PORT=1526)) (CONNECT_DATA= (SERVICE_NAME=PROD) (server=shared)))
TNS-12541: TNS:no listener

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

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.25)(PORT=1526)) (CONNECT_DATA= (SERVICE_NAME=PROD) (server=shared)))
TNS-12541: TNS:no listener


R403000=0.1


A: Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.25)(PORT=1526)) (CONNECT_DATA= (SERVICE_NAME=PROD) (server=shared)))


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

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

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=rac1.example.com)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=rac2.example.com)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=RACDB)))
OK (10 msec)

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

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=rac1.example.com)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=rac2.example.com)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=RACDB)))
OK (10 msec)


R404000=0.1


A: Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=rac1.example.com)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=rac2.example.com)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=RACDB)))


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

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

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.26)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=EMREP)))
TNS-12541: TNS:no listener
192.168.0.26
station26.example.com

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

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.26)(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.26)(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:26

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.26)(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:26

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

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

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

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

SQL> Connected.
SQL> SQL> 
GROUP_NAME		       TABLESPACE_NAME
------------------------------ ------------------------------
TEMP_GRP		       TEMP01
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:47 2015

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

SQL> Connected.
SQL> SQL> 
GROUP_NAME		       TABLESPACE_NAME
------------------------------ ------------------------------
TEMP_GRP		       TEMP01
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:47 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:47 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:47 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:47 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:48 2015

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

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 	       INITIAL_EXTENT ALLOCATIO BIG
------------------------------ -------------- --------- ---
EXAMPLE 				65536 SYSTEM	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


A: 0


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

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

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

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 	       NEXT_EXTENT ALLOCATIO BIG
------------------------------ ----------- --------- ---
EXAMPLE 				   SYSTEM    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


A: 0


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


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


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

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

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

SQL> Connected.
SQL> SQL> 
no rows selected

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


A: no rows selected


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


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


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

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

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

SQL> Connected.
SQL> SQL> 
no rows selected

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


A: no rows selected


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:49 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:49 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:50 2015

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

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES
------------------------------ ----------
USERS				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


R901000=0.1


A: 0


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

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

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

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 		    BYTES
------------------------------ ----------
USERS				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


R902000=0


A: 0


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

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

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

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 	       INITIAL_EXTENT ALLOCATIO BIG
------------------------------ -------------- --------- ---
USERS					65536 SYSTEM	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


A: 0


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

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

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

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME 	       NEXT_EXTENT ALLOCATIO BIG
------------------------------ ----------- --------- ---
USERS					   SYSTEM    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


A: 0


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


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:51 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:51 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:51 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:52 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:52 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:52 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:52 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:53 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:53 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:53 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	     2 YES INACTIVE		   132069 10-JAN-15
	 2	    1	       5  104857600	     2 NO  CURRENT		   171251 10-JAN-15
	 3	    1	       3  104857600	     2 YES INACTIVE		   102270 10-JAN-15
	 4	    1	       0  104857600	     2 YES UNUSED			0
	 5	    1	       0  104857600	     2 YES UNUSED			0
	 6	    1	       0  104857600	     1 YES UNUSED			0
	 7	    1	       0  104857600	     1 YES UNUSED			0
	 8	    1	       0  104857600	     1 YES UNUSED			0
	 9	    1	       0  104857600	     1 YES UNUSED			0
	10	    1	       0  104857600	     1 YES UNUSED			0

10 rows selected.

SQL> 
  COUNT(*)
----------
	10

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


R1102000=0.5




******************** TOPIC 11.3 ********************
1
1
1
1
1
1
1
1
1
1
R1103000=0


******************** TOPIC 11.4 ********************
10
0
R1104000=1.00


******************** TOPIC 11.5 ********************
      3 Disk1
      3 Disk2
      3 Disk3
      3 Disk4
      3 Disk5

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> 
     BYTES
----------
 104857600
 104857600
 104857600
 104857600
 104857600
 104857600
 104857600
 104857600
 104857600
 104857600

10 rows selected.

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:58 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:58 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:04:58 2015

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

SQL> Connected.
SQL> SQL> SQL> 
 ANALYZEDT
----------
16445.7951

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:04:59 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:59 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:59 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:59 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:00 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.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: 0 full is 1.00 3.1
R1104000: 1.00 full is .50 3.6
R1105000: 0 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: .10 full is 0.1 6.35
R201020: .10 full is 0.1 6.45
R201030: .05 full is 0.33 6.78
R201040: .05 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.15 full is 0.15 8.8
R303020: 0 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.1 full is 0.1 9.2
R404000: 0.1 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 full is 0.2 11.6
R604000: 0 full is 0.2 11.8
R700000: 0 full is 0.1 11.9
R800000: 0 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 full is 0.1 12.6
R903000: 0 full is 0.2 12.8
R904000: 0 full is 0.2 13.0
full of this section:
RESULT:
7.75


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