

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** Section0 ********************
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


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



# .bash_profile

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

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:22 2015

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

SQL> Connected.
SQL> SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_name 			     string	 PROD
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


R100001=1


A: db_name 			     string	 PROD

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:22 2015

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

SQL> Connected.
SQL> SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
instance_name			     string	 PROD
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


R100002=19


A: instance_name			     string	 PROD


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


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:23 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ****************************
SQL> The database open mode here:
SQL> ****************************
SQL> SQL> 
D
-
X
SQL> 
OPEN_MODE
----------
READ WRITE
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


R200101=10


A: READ WRITE

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:23 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ****************************
SQL> The database archivelog mode here:
SQL> **********************************
SQL> SQL> Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     2
Next log sequence to archive   4
Current log sequence	       4
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


R200102=0


A: SQL> SQL> Database log mode	       Archive Mode

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:23 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ****************************
SQL> The database controlfile here:
SQL> ******************************
SQL> 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> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200103=5


A: /u01/app/oracle/oradata/PROD/Disk1/control01.ctl

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:23 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ****************************
SQL> The database controlfile here:
SQL> ******************************
SQL> 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> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200104=5


A: /u01/app/oracle/oradata/PROD/Disk2/control02.ctl

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:23 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ****************************
SQL> The database controlfile here:
SQL> ******************************
SQL> 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> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200105=5


A: /u01/app/oracle/oradata/PROD/Disk3/control03.ctl


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:24 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> 
TABLESPACE_NAME 	       STATUS
------------------------------ ---------------
SYSTEM			       ONLINE
SQL> 
FILE_NAME							  STATUS
----------------------------------------------------------------- ---------------
/u01/app/oracle/oradata/PROD/Disk1/system01.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


R200201=4


A: /u01/app/oracle/oradata/PROD/Disk1/system01.dbf 		  AVAILABLE

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:24 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> 
TABLESPACE_NAME 	       STATUS
------------------------------ ---------------
SYSTEM			       ONLINE
SQL> 
FILE_NAME							  STATUS
----------------------------------------------------------------- ---------------
/u01/app/oracle/oradata/PROD/Disk1/system01.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


R200202=1


A: SYSTEM			       ONLINE


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:24 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> 
TABLESPACE_NAME 	       STATUS
------------------------------ ---------------
SYSAUX			       ONLINE
SQL> 
FILE_NAME							  STATUS
----------------------------------------------------------------- ---------------
/u01/app/oracle/oradata/PROD/Disk2/sysaux01.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


R200301=4


A: /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf 		  AVAILABLE

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:24 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> 
TABLESPACE_NAME 	       STATUS
------------------------------ ---------------
SYSAUX			       ONLINE
SQL> 
FILE_NAME							  STATUS
----------------------------------------------------------------- ---------------
/u01/app/oracle/oradata/PROD/Disk2/sysaux01.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


R200302=1


A: SYSAUX			       ONLINE


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:25 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> SQL> SQL> 
TABLESPACE_NAME 	       STATUS
------------------------------ ---------------
UNDOTBS1		       ONLINE
SQL> 
FILE_NAME							  STATUS
----------------------------------------------------------------- ---------------
/u01/app/oracle/oradata/PROD/Disk3/undotbs01.dbf		  AVAILABLE
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


R200401=4


A: /u01/app/oracle/oradata/PROD/Disk3/undotbs01.dbf		  AVAILABLE

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:25 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> SQL> SQL> 
TABLESPACE_NAME 	       STATUS
------------------------------ ---------------
UNDOTBS1		       ONLINE
SQL> 
FILE_NAME							  STATUS
----------------------------------------------------------------- ---------------
/u01/app/oracle/oradata/PROD/Disk3/undotbs01.dbf		  AVAILABLE
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


R200402=1


A: UNDOTBS1		       ONLINE


******************** TOPIC 2.5 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:25 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> **************************
SQL> The database tempfile here:
SQL> **************************
SQL> SQL> SQL> 
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/PROD/Disk5/temp01.dbf
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


R200500=3


A: /u01/app/oracle/oradata/PROD/Disk5/temp01.dbf


******************** TOPIC 2.6 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:26 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> **************************
SQL> The database logfile here:
SQL> **************************
SQL> SQL> SQL> 
MEMBER
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/PROD/Disk1/redo01.log
/u01/app/oracle/oradata/PROD/Disk2/redo02.log
/u01/app/oracle/oradata/PROD/Disk3/redo03.log
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


R200601=3


A: /u01/app/oracle/oradata/PROD/Disk1/redo01.log

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:26 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> **************************
SQL> The database logfile here:
SQL> **************************
SQL> SQL> SQL> 
MEMBER
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/PROD/Disk1/redo01.log
/u01/app/oracle/oradata/PROD/Disk2/redo02.log
/u01/app/oracle/oradata/PROD/Disk3/redo03.log
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


R200602=3


A: /u01/app/oracle/oradata/PROD/Disk2/redo02.log

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:26 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> **************************
SQL> The database logfile here:
SQL> **************************
SQL> SQL> SQL> 
MEMBER
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/PROD/Disk1/redo01.log
/u01/app/oracle/oradata/PROD/Disk2/redo02.log
/u01/app/oracle/oradata/PROD/Disk3/redo03.log
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


R200603=3


A: /u01/app/oracle/oradata/PROD/Disk3/redo03.log


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:26 2015

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

SQL> Connected.
SQL> SQL> 
USERNAME
------------------------------
DBSNMP

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


R300000=15


A: DBSNMP


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:26 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> 
FILE_NAME	     TABLESPACE_NAME	  AUT
-------------------- -------------------- ---
/u01/app/oracle/orad SYSTEM		  YES
/u01/app/oracle/orad UNDOTBS1		  YES
/u01/app/oracle/orad SYSAUX		  NO
/u01/app/oracle/orad USERS		  YES

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


R400000=13


A: 1
****************************************************************************************************


R100001: 1 full is 1 1
R100002: 19 full is 19 20
R200101: 10 full is 10 30
R200102: 0 full is 0 30
R200103: 5 full is 5 35
R200104: 5 full is 5 40
R200105: 5 full is 5 45
R200201: 4 full is 4 49
R200202: 1 full is 1 50
R200301: 4 full is 4 54
R200302: 1 full is 1 55
R200401: 4 full is 4 59
R200402: 1 full is 1 60
R200500: 3 full is 3 63
R200601: 3 full is 3 66
R200602: 3 full is 3 69
R200603: 3 full is 3 72
R300000: 15 full is 15 87
R400000: 13 full is 13 100
full of this section:
RESULT:
100


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