

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** Section8 ********************
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


******************** 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:/u01/app/oracle/product/10.2.0/db_1/jdk/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 ORACLE_SID=PROD
export GLOGAL_DBNAME=PROD
export LANG=en_US

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:31 2015

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

SQL> Connected.
SQL> SQL> 
NAME				     TYPE			      VALUE
------------------------------------ -------------------------------- ------------------------------
db_unique_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=0.1


A: db_unique_name			     string			      PROD

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:31 2015

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

SQL> Connected.
SQL> SQL> 
DB_UNIQUE_NAME
--------------------
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=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:32 2015

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

SQL> Connected.
SQL> SQL> 
NAME	  DATABASE_ROLE
--------- ----------------
PROD	  PRIMARY

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


R100003=0.7


A: PROD	  PRIMARY

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:32 2015

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

SQL> Connected.
SQL> SQL> 
OPEN_MODE
----------
READ WRITE

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


R100004=1


A: READ WRITE

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:32 2015

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

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
	 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


R999999=0


A=0
R100005=.25

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:33 2015

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

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
	 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


R999999=0


A=0
R100006=.25

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:33 2015

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

SQL> Connected.
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> 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


R100007=0.3



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:33 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


R100008=0.1


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:34 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


R100009=0.1


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:34 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


R100010=0.1


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:34 2015

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

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

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


R100011=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:35 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


R100012=0


A: 0


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:35 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:35 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200002=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:36 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200003=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:36 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200004=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:36 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R999999=0


VALUE_A: 


R999999=0


A=0
R200005=.25

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:37 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SQL> SP2-0734: unknown command beginning "sub_db_soc..." - rest of line ignored.
SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R999999=0


VALUE_A: 


R999999=0


A=0
R200006=.25

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:37 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200007=0


VALUE_A: 0


R200007=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:37 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SQL> SQL> SQL> SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> SQL> SQL> SQL> SP2-0640: Not connected
SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200008=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:37 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SQL> SQL> SQL> SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> SQL> SQL> SQL> SP2-0640: Not connected
SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200009=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:38 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SQL> SQL> SQL> SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> SQL> SQL> SQL> SP2-0640: Not connected
SQL> SP2-0640: Not connected
SQL> SP2-0640: Not connected
SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> 

R200010=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:38 2015

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

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

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


R200011=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:38 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200012=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:39 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200013=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:39 2015

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

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

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


R888888=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:39 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R777777=0


VALUE_A: 


R777777=0


R200014=0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:39 2015

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

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
	 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


R888888=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:05:40 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R777777=0


VALUE_A: 


R777777=0


R200015=0
****************************************************************************************************


R100001: 0.1 full is 0.1 0.1
R100002: 0 full is 1.5 1.6
R100003: 0.7 full is 0.7 2.3
R100004: 1 full is 1 3.3
R100005: .25 full is 0.25 3.55
R100006: .25 full is 0.25 3.8
R100007: 0.3 full is 0.3 4.1
R100008: 0.1 full is 0.1 4.2
R100009: 0.1 full is 0.1 4.3
R100010: 0.1 full is 0.1 4.4
R100011: 0 full is 0.15 4.55
R100012: 0 full is 0.35 4.9
R200001: 0 full is 0.5 5.4
R200002: 0 full is 1 6.4
R200003: 0 full is 0.7 7.1
R200004: 0 full is 0.3 7.4
R200005: .25 full is 0.25 7.65
R200006: .25 full is 0.25 7.9
R200007: 0 full is 0.3 8.2
R200008: 0 full is 0.2 8.4
R200009: 0 full is 0.2 8.6
R200010: 0 full is 0.2 8.8
R200011: 0 full is 0.5 9.3
R200012: 0 full is 0.1 9.4
R200013: 0 full is 0.1 9.5
R200014: 0 full is 0.4 9.9
R200015: 0 full is 0.1 10
full of this section:
RESULT:
3.40


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