

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


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



# .bash_profile

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

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

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


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


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

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 2 08:20:35 2003

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 Thu Jan 2 08:20:35 2003

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	       NOGUARANTEE

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


A: 0


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

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 2 08:20:36 2003

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

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

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


R101021=0.3



SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 2 08:20:36 2003

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 02-JAN-2003 08:20:37

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:44
Uptime                    0 days 1 hr. 35 min. 52 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
The listener supports no services
The command completed successfully


R201010=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:20:37

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:44
Uptime                    0 days 1 hr. 35 min. 52 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
The listener supports no services
The command completed successfully


R201010=.10


B:   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))


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

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:20:37

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:44
Uptime                    0 days 1 hr. 35 min. 52 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
The listener supports no services
The command completed successfully


R201020=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:20:37

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:44
Uptime                    0 days 1 hr. 35 min. 52 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
The listener supports no services
The command completed successfully


R201020=.10


B:   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))


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

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:20:37

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:44
Uptime                    0 days 1 hr. 35 min. 53 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
The listener supports no services
The command completed successfully


R201030=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:20:37

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:44
Uptime                    0 days 1 hr. 35 min. 53 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
The listener supports no services
The command completed successfully


R201030=.05


B: 0


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

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:20:38

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:44
Uptime                    0 days 1 hr. 35 min. 53 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
The listener supports no services
The command completed successfully


R201040=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:20:38

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:44
Uptime                    0 days 1 hr. 35 min. 53 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
The listener supports no services
The command completed successfully


R201040=.24


B: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))


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

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:20:38

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:44
Uptime                    0 days 1 hr. 35 min. 53 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
The listener supports no services
The command completed successfully


R201051=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:20:38

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:44
Uptime                    0 days 1 hr. 35 min. 53 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))
The listener supports no services
The command completed successfully


R201051=.05


B: 0
nsclose: global context check-out (from slot 5) complete
nsglhfre: Deallocating cxd 0x890b1b8.
nstimarmed: no timer allocated
nstoClearTimeout: ATO disabled for ctx=0x0x88ed740
nstoClearTimeout: STO disabled for ctx=0x0x88ed740
nstoClearTimeout: RTO disabled for ctx=0x0x88ed740
nstoClearTimeout: PITO disabled for ctx=0x0x88ed740
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 02-JAN-2003 08:20:39

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:56
Uptime                    0 days 1 hr. 35 min. 43 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=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
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 02-JAN-2003 08:20:39

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:56
Uptime                    0 days 1 hr. 35 min. 43 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=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
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=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:20:39

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:56
Uptime                    0 days 1 hr. 35 min. 43 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=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
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 02-JAN-2003 08:20:39

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:56
Uptime                    0 days 1 hr. 35 min. 43 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=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
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 02-JAN-2003 08:20:39

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:56
Uptime                    0 days 1 hr. 35 min. 43 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=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
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 02-JAN-2003 08:20:39

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:56
Uptime                    0 days 1 hr. 35 min. 43 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=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
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 02-JAN-2003 08:20:39
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
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
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
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 02-JAN-2003 08:20:39

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:56
Uptime                    0 days 1 hr. 35 min. 43 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=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
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.1


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

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:20:39

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
STATUS of the LISTENER
------------------------
Alias                     LSNR2
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                02-JAN-2003 06:44:56
Uptime                    0 days 1 hr. 35 min. 43 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=station21.example.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared)))
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 0.0.0.0:1526                0.0.0.0:*                   LISTEN      11093/tnslsnr       


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


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

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 2 08:20:40 2003

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

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

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


R301001=0.1



SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 2 08:20:41 2003

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


R301002=0




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


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

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 2 08:20:41 2003

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 Thu Jan 2 08:20:41 2003

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 Thu Jan 2 08:20:42 2003

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 Thu Jan 2 08:20:42 2003

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 Thu Jan 2 08:20:42 2003

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 02-JAN-2003 08:20:43

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


R401000=0.1




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

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:20:43

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=station21.example.com)(PORT=1526)) (CONNECT_DATA= (SERVICE_NAME=PROD)))
OK (0 msec)

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:20:43

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=station21.example.com)(PORT=1526)) (CONNECT_DATA= (SERVICE_NAME=PROD)))
OK (0 msec)


R402000=0


A: 0


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

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:20:43

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 02-JAN-2003 08:20:43

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

Used parameter files:

TNS-03505: Failed to resolve name


R403000=0


A: 0


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

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:21:04

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 02-JAN-2003 08:21:04

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

Used parameter files:

TNS-03505: Failed to resolve name


R404000=0


A: 0


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

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:21:24

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

Used parameter files:

TNS-03505: Failed to resolve name
192.168.0.22
station22.example.com

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:21:24

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

Used parameter files:

TNS-03505: Failed to resolve name


R405000=0


A: 0

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 02-JAN-2003 08:21:24

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

Used parameter files:

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 02-JAN-2003 08:21:45

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 02-JAN-2003 08:21:45

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 02-JAN-2003 08:21:45

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 Thu Jan 2 08:22:05 2003

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 Thu Jan 2 08:22:05 2003

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 Thu Jan 2 08:22:06 2003

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 Thu Jan 2 08:22:06 2003

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 Thu Jan 2 08:22:06 2003

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 Thu Jan 2 08:22:06 2003

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 Thu Jan 2 08:22:06 2003

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 Thu Jan 2 08:22:07 2003

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 Thu Jan 2 08:22:07 2003

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 Thu Jan 2 08:22:07 2003

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 Thu Jan 2 08:22:08 2003

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 Thu Jan 2 08:22:08 2003

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 Thu Jan 2 08:22:08 2003

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

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

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 Thu Jan 2 08:22:08 2003

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

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

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=.05


B: 0


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

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 2 08:22:09 2003

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

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

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 Thu Jan 2 08:22:09 2003

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

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

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 Thu Jan 2 08:22:09 2003

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 Thu Jan 2 08:22:10 2003

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 Thu Jan 2 08:22:10 2003

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


R1001000=0


A: no rows selected


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

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 2 08:22:10 2003

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


R1002000=0


A: no rows selected


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

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 2 08:22:10 2003

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


R1003000=0


A: no rows selected


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

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 2 08:22:11 2003

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


R1004001=0


A: no rows selected

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 2 08:22:11 2003

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


R1004002=0


A: no rows selected


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


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


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

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 2 08:22:11 2003

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	      17  104857600	     2 YES INACTIVE		   195641 02-JAN-03
	 2	    1	      18  104857600	     2 NO  CURRENT		   195668 02-JAN-03
	 3	    1	       0  104857600	     2 YES UNUSED			0
	 4	    1	      16  104857600	     2 YES INACTIVE		   194686 02-JAN-03
	 5	    1	      12  104857600	     2 YES INACTIVE		   194658 02-JAN-03

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

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


R1102000=0.5




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


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


******************** TOPIC 11.5 ********************
      2 Disk3
      4 Disk1
      4 Disk2

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 2 08:22:14 2003

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


R1105000=0




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

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 2 08:22:14 2003

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/Disk1/control02.ctl
/u01/app/oracle/oradata/PROD/Disk1/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: 1


R1200000=0




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

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 2 08:22:15 2003

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 Thu Jan 2 08:22:15 2003

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

SQL> Connected.
SQL> SQL> SQL> 
 ANALYZEDT
----------
12054.3488

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


R1400010=0




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

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 2 08:22:16 2003

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 Thu Jan 2 08:22:16 2003

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 Thu Jan 2 08:22:16 2003

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 Thu Jan 2 08:22:16 2003

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 Thu Jan 2 08:22:17 2003

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 full is 0.1 0.1
R1002000: 0 full is 0.1 0.2
R1003000: 0 full is 0.15 0.35
R1004001: 0 full is 0.15 0.5
R1004002: 0 full is 0.1 0.6
R101011: 0 full is 0.15 0.75
R101012: 0 full is 0.4 1.15
R101021: 0.3 full is 0.3 1.45
R101022: 0 full is 0.15 1.6
R1102000: 0.5 full is 0.5 2.1
R1103000: .40 full is 1.00 3.1
R1104000: .50 full is .50 3.6
R1105000: 0 full is 0.5 4.1
R1200000: 0 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: .24 full is 0.24 7.02
R201051: .05 full is 0.23 7.25
R201052: 0.1 full is 0.1 7.35
R202001: .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.1 full is 0.1 8.0
R204002: 0.1 full is 0.1 8.1
R301001: 0.1 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.1 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 full is 0.2 11.6
R604000: 0 full is 0.2 11.8
R700000: .10 full is 0.1 11.9
R800000: .20 full is 0.2 12.1
R900000: .05 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:
6.59


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