

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** Section6 ********************
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


******************** 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 ORACLE_SID=PROD
export PATH=$ORACLE_HOME/jdk/bin:$ORACLE_HOME/bin:$PATH
export LANG=en_US


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:20:56 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TRUE

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


R101000=0.1


A: TRUE


******************** TOPIC 1.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:20:56 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/admin/PROD/bdump

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


R102001=0.1


A: /u01/app/oracle/admin/PROD/bdump
drwxr-xr-x 2 oracle oinstall 4096 Jan 17 00:13 /u01/app/oracle/admin/PROD/bdump


R102002=0.2




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


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


******************** TOPIC 2.1.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:20:56 2015

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

SQL> Connected.
SQL> SQL> 
PRIVILEGE
----------------------------------------
CREATE SEQUENCE
ALTER SESSION
CREATE SYNONYM
CREATE TABLE
UNLIMITED TABLESPACE
CREATE SESSION
CREATE DATABASE LINK
ADMINISTER RESOURCE MANAGER
CREATE CLUSTER
CREATE DIMENSION
CREATE VIEW

PRIVILEGE
----------------------------------------
QUERY REWRITE
CREATE MATERIALIZED VIEW

13 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


R201010=0.1


A: ADMINISTER RESOURCE MANAGER


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:20:57 2015

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

SQL> Connected.
SQL> SQL> 
CONSUMER_GROUP
------------------------------
OTHER_GROUPS
DEFAULT_CONSUMER_GROUP
SYS_GROUP
LOW_GROUP
AUTO_TASK_CONSUMER_GROUP
OLTP
DSS

7 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


R201021=0.1


A: OLTP

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:20:57 2015

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

SQL> Connected.
SQL> SQL> 
CONSUMER_GROUP
------------------------------
OTHER_GROUPS
DEFAULT_CONSUMER_GROUP
SYS_GROUP
LOW_GROUP
AUTO_TASK_CONSUMER_GROUP
OLTP
DSS

7 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


R201022=0.1


A: DSS

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:20:57 2015

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

SQL> Connected.
SQL> SQL> 
COMMENTS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OLTP

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


R201023=0.03


A: OLTP

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:20:57 2015

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

SQL> Connected.
SQL> SQL> 
COMMENTS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DSS

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


R201024=0.03


A: DSS


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


******************** TOPIC 2.1.3.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:20:58 2015

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

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

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


R201031=0.2



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:20:58 2015

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

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

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


R201131=0.2




******************** TOPIC 2.1.3.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:20:58 2015

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

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

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


R201032=0.2



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:20:58 2015

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

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

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


R201132=0.2




******************** TOPIC 2.1.3.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:20:59 2015

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

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

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


R201033=0.2


A: DSS

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:20:59 2015

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

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

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


R201133=0.2




******************** TOPIC 2.1.3.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:20:59 2015

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

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

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


R201034=0.2




******************** TOPIC 2.1.3.5 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:00 2015

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

SQL> Connected.
SQL> SQL> 
     VALUE
----------
	50

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


R201035=0.2



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:00 2015

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

SQL> Connected.
SQL> SQL> 
     VALUE
----------
	30

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


R201135=0.2



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:00 2015

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

SQL> Connected.
SQL> SQL> 
     VALUE
----------
	20

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


R201235=0.2




******************** TOPIC 2.1.3.6 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:00 2015

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

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

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


R201036=0.2




******************** TOPIC 2.1.3.7 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:01 2015

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

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

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


R201037=0.2




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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:01 2015

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

SQL> Connected.
SQL> SQL> 
GRANTEE
------------------------------
SH

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


R201041=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:01 2015

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

SQL> Connected.
SQL> SQL> SQL> 
no rows selected

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


R201042=0


A: 0


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:02 2015

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

SQL> Connected.
SQL> SQL> 
GRANTEE
------------------------------
SH

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


R201051=0.2


A: SH

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:02 2015

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

SQL> Connected.
SQL> SQL> SQL> 
VALUE
----------
YES

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


R201052=0.2


A: YES


******************** TOPIC 2.1.6 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:02 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WEEKDAYS

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


R201060=0.44


A: WEEKDAYS


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


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:02 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> 
TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Select "OWNER","NAME","DB_LINK","NAMESPACE","TYPE","SHARABLE_MEM","LOADS","EXECUTIONS","LOCKS","PINS","KEPT","CHILD_LATCH","INVALIDATIONS" from V$DB_OBJECT_CACHE
WHERE
TYPE
IN('PACKAGE','PROCEDURE','TRIGGER','FUNCTION', 'PACKAGE BODY')
AND
SHARABLE_MEM>52100


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


R301001=0.3


A: TEXT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Select "OWNER","NAME","DB_LINK","NAMESPACE","TYPE","SHARABLE_MEM","LOADS","EXECUTIONS","LOCKS","PINS","KEPT","CHILD_LATCH","INVALIDATIONS" from V$DB_OBJECT_CACHE WHERE TYPE IN('PACKAGE','PROCEDURE','TRIGGER','FUNCTION', 'PACKAGE BODY') AND SHARABLE_MEM>52100   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 

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:02 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> 
TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Select "OWNER","NAME","DB_LINK","NAMESPACE","TYPE","SHARABLE_MEM","LOADS","EXECUTIONS","LOCKS","PINS","KEPT","CHILD_LATCH","INVALIDATIONS" from V$DB_OBJECT_CACHE
WHERE
TYPE
IN('PACKAGE','PROCEDURE','TRIGGER','FUNCTION', 'PACKAGE BODY')
AND
SHARABLE_MEM>52100


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


R301001=.4


B: TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Select"OWNER","NAME","DB_LINK","NAMESPACE","TYPE","SHARABLE_MEM","LOADS","EXECUTIONS","LOCKS","PINS","KEPT","CHILD_LATCH","INVALIDATIONS"fromV$DB_OBJECT_CACHEWHERETYPEIN('PACKAGE','PROCEDURE','TRIGGER','FUNCTION','PACKAGEBODY')ANDSHARABLE_MEM>52100SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>DisconnectedfromOracleDatabase10gEnterpriseEditionRelease10.2.0.2.0-ProductionWiththePartitioning,OLAPandDataMiningoptions

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:02 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> 
TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Select "OWNER","NAME","DB_LINK","NAMESPACE","TYPE","SHARABLE_MEM","LOADS","EXECUTIONS","LOCKS","PINS","KEPT","CHILD_LATCH","INVALIDATIONS" from V$DB_OBJECT_CACHE
WHERE
TYPE
IN('PACKAGE','PROCEDURE','TRIGGER','FUNCTION', 'PACKAGE BODY')
AND
SHARABLE_MEM>52100


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


R301001=.5


C: TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Select"OWNER","NAME","DB_LINK","NAMESPACE","TYPE","SHARABLE_MEM","LOADS","EXECUTIONS","LOCKS","PINS","KEPT","CHILD_LATCH","INVALIDATIONS"fromV$DB_OBJECT_CACHEWHERETYPEIN('PACKAGE','PROCEDURE','TRIGGER','FUNCTION','PACKAGEBODY')ANDSHARABLE_MEM>52100SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>DisconnectedfromOracleDatabase10gEnterpriseEditionRelease10.2.0.2.0-ProductionWiththePartitioning,OLAPandDataMiningoptions

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:02 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> 
TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Select "OWNER","NAME","DB_LINK","NAMESPACE","TYPE","SHARABLE_MEM","LOADS","EXECUTIONS","LOCKS","PINS","KEPT","CHILD_LATCH","INVALIDATIONS" from V$DB_OBJECT_CACHE
WHERE
TYPE
IN('PACKAGE','PROCEDURE','TRIGGER','FUNCTION', 'PACKAGE BODY')
AND
SHARABLE_MEM>52100


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


R301001=.6


D: TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Select"OWNER","NAME","DB_LINK","NAMESPACE","TYPE","SHARABLE_MEM","LOADS","EXECUTIONS","LOCKS","PINS","KEPT","CHILD_LATCH","INVALIDATIONS"fromV$DB_OBJECT_CACHEWHERETYPEIN('PACKAGE','PROCEDURE','TRIGGER','FUNCTION','PACKAGEBODY')ANDSHARABLE_MEM>52100SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>DisconnectedfromOracleDatabase10gEnterpriseEditionRelease10.2.0.2.0-ProductionWiththePartitioning,OLAPandDataMiningoptions

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:02 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> 
TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Select "OWNER","NAME","DB_LINK","NAMESPACE","TYPE","SHARABLE_MEM","LOADS","EXECUTIONS","LOCKS","PINS","KEPT","CHILD_LATCH","INVALIDATIONS" from V$DB_OBJECT_CACHE
WHERE
TYPE
IN('PACKAGE','PROCEDURE','TRIGGER','FUNCTION', 'PACKAGE BODY')
AND
SHARABLE_MEM>52100


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


R301001=.7


E: TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Select"OWNER","NAME","DB_LINK","NAMESPACE","TYPE","SHARABLE_MEM","LOADS","EXECUTIONS","LOCKS","PINS","KEPT","CHILD_LATCH","INVALIDATIONS"fromV$DB_OBJECT_CACHEWHERETYPEIN('PACKAGE','PROCEDURE','TRIGGER','FUNCTION','PACKAGEBODY')ANDSHARABLE_MEM>52100SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>DisconnectedfromOracleDatabase10gEnterpriseEditionRelease10.2.0.2.0-ProductionWiththePartitioning,OLAPandDataMiningoptions

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:02 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> 
TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Select "OWNER","NAME","DB_LINK","NAMESPACE","TYPE","SHARABLE_MEM","LOADS","EXECUTIONS","LOCKS","PINS","KEPT","CHILD_LATCH","INVALIDATIONS" from V$DB_OBJECT_CACHE
WHERE
TYPE
IN('PACKAGE','PROCEDURE','TRIGGER','FUNCTION', 'PACKAGE BODY')
AND
SHARABLE_MEM>52100


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


R301001=.8


F: TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Select"OWNER","NAME","DB_LINK","NAMESPACE","TYPE","SHARABLE_MEM","LOADS","EXECUTIONS","LOCKS","PINS","KEPT","CHILD_LATCH","INVALIDATIONS"fromV$DB_OBJECT_CACHEWHERETYPEIN('PACKAGE','PROCEDURE','TRIGGER','FUNCTION','PACKAGEBODY')ANDSHARABLE_MEM>52100SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>DisconnectedfromOracleDatabase10gEnterpriseEditionRelease10.2.0.2.0-ProductionWiththePartitioning,OLAPandDataMiningoptions

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:04 2015

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

SQL> Connected.
SQL> SQL> 
OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
SYS
DBMS_ADVISOR
								 TABLE/PROCEDURE	      PACKAGE				  58768 	 3	    0	       1	  0 NO		  3		0

SYS
DBMS_DATAPUMP
								 BODY			      PACKAGE BODY			 147181 	 1	  269	       1	  0 NO		  2		0

OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------

SYS
DBMS_SYS_SQL
								 BODY			      PACKAGE BODY			  67212 	 1	19726	       0	  0 NO		  2		0

SYS
KUPM$MCP

OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
								 BODY			      PACKAGE BODY			 256236 	 1	   12	       0	  0 NO		  1		0

SYS
DBMS_STATS
								 TABLE/PROCEDURE	      PACKAGE				 132494 	 1	    0	       0	  0 YES 	  3		0

SYS

OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
DBMS_SPACE
								 TABLE/PROCEDURE	      PACKAGE				  54670 	 1	    0	       0	  0 NO		  1		0

SYS
KUPW$WORKER
								 BODY			      PACKAGE BODY			 243739 	 1	   12	       0	  0 NO		  2		0


OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
SYS
DBMS_METADATA
								 BODY			      PACKAGE BODY			 128997 	 1	  666	       0	  0 NO		  1		0

SYS
DBMS_METADATA_UTIL
								 BODY			      PACKAGE BODY			  71150 	 1	  278	       0	  0 NO		  2		0

OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------

SYS
DBMS_XPLAN
								 BODY			      PACKAGE BODY			 112818 	 1	    1	       0	  0 NO		  3		0

SYS
DBMS_STATS

OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
								 BODY			      PACKAGE BODY			 459710 	 1	  193	       0	  0 YES 	  2		0

SYS
DBMS_PRVTAQIM
								 BODY			      PACKAGE BODY			 104817 	 1	   16	       0	  0 NO		  3		0

SYS

OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
DBMS_METADATA_INT
								 BODY			      PACKAGE BODY			 222905 	 1	  926	       0	  0 NO		  2		0

SYS
DBMS_SERVER_ALERT
								 TABLE/PROCEDURE	      PACKAGE				  87445 	 2	    0	       2	  0 NO		  1		0


OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
SYS
KUPF$FILE
								 BODY			      PACKAGE BODY			  87441 	 1	  345	       0	  0 NO		  2		0

SYS
DBMS_STATS_INTERNAL
								 BODY			      PACKAGE BODY			  87035 	 1	 5103	       0	  0 NO		  2		0

OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------

SYS
DBMS_STATS_INTERNAL
								 TABLE/PROCEDURE	      PACKAGE				 246179 	 1	12417	       0	  0 NO		  3		0

SYS
DBMS_PRVTAQIS

OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
								 BODY			      PACKAGE BODY			 108157 	 1	  157	       1	  0 NO		  1		0

SYS
DBMS_INTERNAL_LOGSTDBY
								 BODY			      PACKAGE BODY			 106838 	 1	    8	       0	  0 NO		  3		0

SYS

OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
PRVT_ADVISOR
								 BODY			      PACKAGE BODY			  75284 	 1	   65	       0	  0 NO		  2		0

DBSNMP
MGMT_BSLN
								 TABLE/PROCEDURE	      PACKAGE				  63948 	 4	    0	       1	  0 NO		  1		0


OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
SYS
DBMS_SPACE
								 BODY			      PACKAGE BODY			 107362 	 1	 9307	       0	  0 NO		  3		0

SYS
DBMS_SNAPSHOT_UTL
								 BODY			      PACKAGE BODY			  53905 	 1	   29	       0	  0 NO		  3		0

OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------

SYS
DBMS_RCVMAN
								 TABLE/PROCEDURE	      PACKAGE				 245031 	 4	    0	       1	  0 NO		  1		0

SYS
STANDARD

OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
								 TABLE/PROCEDURE	      PACKAGE				 439692 	 1	    0	      16	  0 NO		  3		0

SYS
DBMS_AQADM_SYS
								 BODY			      PACKAGE BODY			 213350 	 1	  308	       1	  0 NO		  3		0

SYS

OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
DBMS_RCVMAN
								 BODY			      PACKAGE BODY			 383755 	 2	    0	       1	  0 NO		  2		0


27 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


R301002=0.1


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:04 2015

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

SQL> Connected.
SQL> SQL> 
OWNER
------------------------------
PUBLIC

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


B: PUBLIC


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:05 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1073741824

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


R302001=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:05 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
536870912

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


R302002=0.15



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:05 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
838860800

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


R302003=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:06 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
536870912

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


R302004=0.15




******************** TOPIC 3.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:06 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
209715200

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


R303001=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:06 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
209715200

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


R303002=0




******************** TOPIC 3.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:07 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
157286400

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


R304001=0.1



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:07 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
157286400

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


R304002=0.1




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


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:07 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> 
COLUMN_EXPRESSION
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
UPPER("CUST_LAST_NAME")

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


R401001=0.5


A: COLUMN_EXPRESSION------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------UPPER("CUST_LAST_NAME")SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>DisconnectedfromOracleDatabase10gEnterpriseEditionRelease10.2.0.2.0-ProductionWiththePartitioning,OLAPandDataMiningoptions

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:08 2015

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

SQL> Connected.
SQL> SQL>   2    3    4  
INDEX_NAME
------------------------------
CUST_LAST_NAME_INDEX

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


R999999=1


A: CUST_LAST_NAME_INDEX

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:08 2015

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

SQL> Connected.
SQL> SQL> 
Explained.

SQL> 
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 3384556117

----------------------------------------------------------------------------------------------------
| Id  | Operation		    | Name		   | Rows  | Bytes | Cost (%CPU)| Time	   |
----------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT	    |			   |	83 |  2573 |	17   (0)| 00:00:01 |
|   1 |  TABLE ACCESS BY INDEX ROWID| CUSTOMERS 	   |	83 |  2573 |	17   (0)| 00:00:01 |
|*  2 |   INDEX RANGE SCAN	    | CUST_LAST_NAME_INDEX |	83 |	   |	 2   (0)| 00:00:01 |
----------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------

   2 - access(UPPER("CUST_LAST_NAME") LIKE 'TA%')
       filter(UPPER("CUST_LAST_NAME") LIKE 'TA%')

15 rows selected.

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


R401002=0.5


A: |*  2 |   INDEX RANGE SCAN	    | CUST_LAST_NAME_INDEX |	83 |	   |	 2   (0)| 00:00:01 |


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:08 2015

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

SQL> Connected.
SQL> SQL> Connected.
SQL> 
MON
---
YES

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


R402001=0.15


A: YES

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:08 2015

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

SQL> Connected.
SQL> SQL> Connected.
SQL> 
MON
---
YES

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


R402002=0.15


A: YES

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:09 2015

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

SQL> Connected.
SQL> SQL> Connected.
SQL> 
MON
---
YES

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


R402003=0.15


A: YES

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:09 2015

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

SQL> Connected.
SQL> SQL> Connected.
SQL> 
MON
---
YES

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


R402004=0.15


A: YES


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:09 2015

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

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 STUD_ID																																																																									   NOT NULL NUMBER
 FNAME																																																																											    VARCHAR2(20)
 LNAME																																																																											    VARCHAR2(20)

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


R403001=0.03


A:  STUD_ID																																																																									   NOT NULL NUMBER

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:09 2015

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

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 STUD_ID																																																																									   NOT NULL NUMBER
 FNAME																																																																											    VARCHAR2(20)
 LNAME																																																																											    VARCHAR2(20)

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


R403001=.06


B:  FNAME																																																																											    VARCHAR2(20)

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:09 2015

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

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 STUD_ID																																																																									   NOT NULL NUMBER
 FNAME																																																																											    VARCHAR2(20)
 LNAME																																																																											    VARCHAR2(20)

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


R403001=.09


C:  LNAME																																																																											    VARCHAR2(20)

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:10 2015

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

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 STUD_ID																																																																									   NOT NULL NUMBER
 CLASS_ID																																																																									   NOT NULL NUMBER

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


R403002=0.03


A:  STUD_ID																																																																									   NOT NULL NUMBER

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:10 2015

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

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 STUD_ID																																																																									   NOT NULL NUMBER
 CLASS_ID																																																																									   NOT NULL NUMBER

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


R403002=.06


B:  CLASS_ID																																																																									   NOT NULL NUMBER

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:11 2015

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

SQL> Connected.
SQL> SQL>   2  
C
-
P

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


R403003=0.03


A: P

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:11 2015

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

SQL> Connected.
SQL> SQL>   2  
C
-
R
P

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


R403004=0.03


A: P

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:11 2015

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

SQL> Connected.
SQL> SQL>   2  
C
-
R
P

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


R403005=0.03


A: R

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:11 2015

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

SQL> Connected.
SQL> SQL>   2  
C
-
R
P

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


R403006=0.03


A: P

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:11 2015

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

SQL> Connected.
SQL> SQL>   2  
C
-
R
P

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


R403007=0.03


A: R

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:12 2015

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

SQL> Connected.
SQL> SQL> 
INDEX_TYPE
---------------------------
IOT - TOP

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


R403008=0.6


A: IOT - TOP

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:12 2015

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

SQL> Connected.
SQL> SQL> 
COLUMN_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
STUD_ID
CLASS_ID

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


R403009=0.5


A: COLUMN_NAME ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- STUD_ID CLASS_ID  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 


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:12 2015

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

SQL> Connected.
SQL> SQL>   2  
 ANALYZEDT
----------
2193.26787

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


R404001=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:12 2015

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

SQL> Connected.
SQL> SQL>   2  
 ANALYZEDT
----------
2193.26787

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


R404001=0


A: 26787

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:13 2015

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

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

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


R404002=0.2



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:13 2015

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

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


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


R404003=0




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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:13 2015

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

SQL> Connected.
SQL> SQL>   2    3  
INDEX_TYPE
---------------------------
BITMAP
NORMAL

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


R405000=0.8


A: BITMAP


******************** TOPIC 4.6 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:13 2015

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

SQL> Connected.
SQL> SQL>   2    3  
     VALUE
----------
	 1

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


R406001=0.7



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:14 2015

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

SQL> Connected.
SQL> SQL>   2    3  
COMPRESS
--------
ENABLED

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


R406002=0.3


A: ENABLED

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:14 2015

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

SQL> Connected.
SQL> SQL>   2    3  
     VALUE
----------
	 1

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


R406003=0.1




******************** TOPIC 4.7 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:14 2015

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

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


R407001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:15 2015

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

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


R407002=0


A: 0


******************** TOPIC 4.8 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:15 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SIMILAR

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


R408000=0.5


A: SIMILAR


******************** TOPIC 4.9 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:16 2015

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

SQL> Connected.
SQL> SQL> 
SEGMEN
------
AUTO

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


R409001=1


A: AUTO

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:16 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


R409002=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:16 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


R409002=0


B: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:16 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


R409002=0


C: 0


******************** TOPIC 4.10 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:17 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> 
SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT last_name, salary FROM hr.employees
 select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*)  from "SH"."TRANSACTION" t
select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*),count(distinct "USERNAME"),sum(sys_op_opnsize("USERNAME")),substrb(dump(min("USERNAME"),16,0,32),1,120),substrb(dump(max("USERNAME"),16,0,32),1,120),count(distinct "USER_ID"),sum(sys_op_opnsize("USER_ID")),substrb(dump(min("USER_ID"),16,0,32),1,120),substrb(dump(max("USER_ID"),16,0,32),1,120),count("PASSWORD"),count(distinct "PASSWORD"),sum(sys_op_opnsize("PASSWORD")),substrb(dump(min("PASSWORD"),16,0,32),1,120),substrb(dump(max("PASSWORD"),16,0,32),1,120),count(distinct "ACCOUNT_STATUS"),sum(sys_op_opnsize("ACCOUNT_STATUS")),substrb(dump(min("ACCOUNT_STATUS"),16,0,32),1,120),substrb(dump(max("ACCOUNT_STATUS"),16,0,32),1,120),count("LOCK_DATE"),count(distinct "LOCK_DATE"),substrb(dump(min("LOCK_DATE"),16,0,32),1,120),substrb(dump(max("LOCK_DATE")
,16,0,32),1,120),count("EXPIRY_DATE"),count(distinct "EXPIRY_DATE"),substrb(dump(min("EXPIRY_DATE"),16,0,32),1,120),substrb(dump(max("EXPIRY_DATE"),16,0,32),1,120),count(distinct "DEFAULT_TABLESPACE"),sum(sys_op_opnsize("DEFAULT_TABLESPACE")),substrb(dump(min("DEFAULT_TABLESPACE"),16,0,32),1,120),substrb(dump(max("DEFAULT_TABLESPACE"),16,0,32),1,120),count(distinct "TEMPORARY_TABLESPACE"),sum(sys_op_opnsize("TEMPORARY_TABLESPACE")),substrb(dump(min("TEMPORARY_TABLESPACE"),16,0,32),1,120),substrb(dump(max("TEMPORARY_TABLESPACE"),16,0,32),1,120),count(distinct "CREATED"),substrb(dump(min("CREATED"),16,0,32),1,120),substrb(dump(max("CREATED"),16,0,32),1,120),count(distinct "PROFILE"),sum(sys_op_opnsize("PROFILE")),substrb(dump(min("PROFILE"),16,0,32),1,120),substrb(dump(max("PROFILE"),16,0,32),1,120),count("INITIAL_RSRC_CONSUMER_GROUP"),count(distinct "INITIAL_RSRC_CONSUMER_GROUP"),sum(sys_
op_opnsize("INITIAL_RSRC_CONSUMER_GROUP")),substrb(dump(min("INITIAL_RSRC_CONSUMER_GROUP"),16,0,32),1,120),substrb(dump(max("INITIAL_RSRC_CONSUMER_GROUP"),16,0,32),1,120),count("EXTERNAL_NAME"),count(distinct "EXTERNAL_NAME"),sum(sys_op_opnsize("EXTERNAL_NAME")),substrb(dump(min(substrb("EXTERNAL_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("EXTERNAL_NAME",1,32)),16,0,32),1,120) from "SH"."TRANSACTION" t

 select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*)  from "PERFSTAT"."STATS$LEVEL_DESCRIPTION" t
select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*),sum(sys_op_opnsize("SNAP_LEVEL")),substrb(dump(min("SNAP_LEVEL"),16,0,32),1,120),substrb(dump(max("SNAP_LEVEL"),16,0,32),1,120),count("DESCRIPTION"),count(distinct "DESCRIPTION"),sum(sys_op_opnsize("DESCRIPTION")),substrb(dump(min(substrb("DESCRIPTION",1,32)),16,0,32),1,120),substrb(dump(max(substrb("DESCRIPTION",1,32)),16,0,32),1,120) from "PERFSTAT"."STATS$LEVEL_DESCRIPTION" t
select /*+ no_parallel_index(t,"STATS$LEVEL_DESCRIPTION_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$LEVEL_DESCRIPTION_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11752,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$LEVEL_DESCRIPTION" t where "SNAP_LEVEL" is not null
 select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*)  from "SH"."CUSTOMERS" sample block (	6.7385444744,1) t
 select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*)  from "SH"."CUSTOMERS" t

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*),count(UPPER("CUST_LAST_NAME")),count(distinct UPPER("CUST_LAST_NAME")),sum(sys_op_opnsize(UPPER("CUST_LAST_NAME"))),substrb(dump(min(substrb(UPPER("CUST_LAST_NAME"),1,32)),16,0,32),1,120),substrb(dump(max(substrb(UPPER("CUST_LAST_NAME"),1,32)),16,0,32),1,120),sum(sys_op_opnsize("CUST_ID")),sum(sys_op_opnsize("CUST_FIRST_NAME")),sum(sys_op_opnsize("CUST_LAST_NAME")),sum(sys_op_opnsize("CUST_YEAR_OF_BIRTH")),count("CUST_MARITAL_STATUS"),sum(sys_op_opnsize("CUST_MARITAL_STATUS")),sum(sys_op_opnsize("CUST_STREET_ADDRESS")),sum(sys_op_opnsize("CUST_POSTAL_CODE")),sum(sys_op_opnsize("CUST_CITY")),sum(sys_op_opnsize("CUST_CITY_ID")),sum(sys_op_opnsize("CUST_STATE_PROVINCE")),sum(sys_op_opnsize("CUST_STATE_PROVINCE_ID")),sum(sys_op_opnsize("COUNTRY_ID"))
,sum(sys_op_opnsize("CUST_MAIN_PHONE_NUMBER")),count("CUST_INCOME_LEVEL"),sum(sys_op_opnsize("CUST_INCOME_LEVEL")),count("CUST_CREDIT_LIMIT"),sum(sys_op_opnsize("CUST_CREDIT_LIMIT")),count("CUST_EMAIL"),sum(sys_op_opnsize("CUST_EMAIL")),sum(sys_op_opnsize("CUST_TOTAL")),sum(sys_op_opnsize("CUST_TOTAL_ID")),count("CUST_SRC_ID"),sum(sys_op_opnsize("CUST_SRC_ID")),count("CUST_EFF_FROM"),count("CUST_EFF_TO"),count("CUST_VALID"),sum(sys_op_opnsize("CUST_VALID")) from "SH"."CUSTOMERS" sample (  9.9099099099) t

select	MONITORING  from  v$object_usage where INDEX_NAME=:"SYS_B_0"
select a.snap_level   value  from perfstat.stats$snapshot a where a.ucomment=:"SYS_B_0"
select	count(*) from perfstat.stats$snapshot

12 rows selected.

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


R410000=0


A: 0


******************** TOPIC 4.11 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:17 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


R411000=0


A: 0


******************** TOPIC 5 ********************


******************** TOPIC 5.1 ********************


******************** TOPIC 5.1.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:17 2015

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

SQL> Connected.
SQL> SQL> 
DEFAULT_TABLESPACE
------------------------------
TOOLS

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


A: TOOLS


******************** TOPIC 5.1.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:17 2015

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

SQL> Connected.
SQL> SQL> 
TEMPORARY_TABLESPACE
------------------------------
TEMP1

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


R501020=0.3


A: TEMP1


******************** TOPIC 5.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:18 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
VALUE_A: 0


R502000=0




******************** TOPIC 5.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:18 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


R503001=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:18 2015

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

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


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


R503002=0.8



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:18 2015

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

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


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


R503002=0


A: 0


******************** TOPIC 5.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:18 2015

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

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


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
grep: /home/oracle/statspack.ls: No such file or directory


R504000=0


A: 0


******************** TOPIC 6 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:19 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0

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


R600001=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:19 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0

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


R600002=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:19 2015

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

SQL> Connected.
SQL> SQL> 
BUFFER_
-------
DEFAULT

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


R600003=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:20 2015

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

SQL> Connected.
SQL> SQL> 
BUFFER_
-------
DEFAULT

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


R600004=0


A: 0
****************************************************************************************************


R101000: 0.1 full is 0.1 0.1
R102001: 0.1 full is 0.1 0.2
R102002: 0.2 full is 0.2 0.4
R201010: 0.1 full is 0.1 0.5
R201021: 0.1 full is 0.1 0.6
R201022: 0.1 full is 0.1 0.7
R201023: 0.03 full is 0.03 0.73
R201024: 0.03 full is 0.03 0.76
R201031: 0.2 full is 0.2 0.96
R201032: 0.2 full is 0.2 1.16
R201033: 0.2 full is 0.2 1.36
R201034: 0.2 full is 0.2 1.56
R201035: 0.2 full is 0.2 1.76
R201036: 0.2 full is 0.2 1.96
R201037: 0.2 full is 0.2 2.16
R201041: 0 full is 0.2 2.36
R201042: 0 full is 0.2 2.56
R201051: 0.2 full is 0.2 2.76
R201052: 0.2 full is 0.2 2.96
R201060: 0.44 full is 0.44 3.4
R201131: 0.2 full is 0.2 3.6
R201132: 0.2 full is 0.2 3.8
R201133: 0.2 full is 0.2 4.0
R201135: 0.2 full is 0.2 4.2
R201235: 0.2 full is 0.2 4.4
R301001: .8 full is 0.8 5.2
R301002: .2 full is 0.2 5.4
R302001: 0 full is 0.15 5.55
R302002: 0.15 full is 0.15 5.7
R302003: 0 full is 0.15 5.85
R302004: 0.15 full is 0.15 6.0
R303001: 0 full is 0.1 6.1
R303002: 0 full is 0.1 6.2
R304001: 0.1 full is 0.1 6.3
R304002: 0.1 full is 0.1 6.4
R401001: 0.5 full is 0.5 6.9
R401002: 0.5 full is 0.5 7.4
R402001: 0.15 full is 0.15 7.55
R402002: 0.15 full is 0.15 7.7
R402003: 0.15 full is 0.15 7.85
R402004: 0.15 full is 0.15 8
R403001: .09 full is 0.09 8.09
R403002: .06 full is 0.06 8.15
R403003: 0.03 full is 0.03 8.18
R403004: 0.03 full is 0.03 8.21
R403005: 0.03 full is 0.03 8.24
R403006: 0.03 full is 0.03 8.27
R403007: 0.03 full is 0.03 8.3
R403008: 0.6 full is 0.6 8.9
R403009: 0.5 full is 0.5 9.4
R404001: 0 full is 0.5 9.9
R404002: 0.2 full is 0.2 10.1
R404003: 0 full is 0.3 10.4
R405000: 0.8 full is 0.8 11.2
R406001: 0.7 full is 0.7 11.9
R406002: 0.3 full is 0.3 12.3
R407001: 0 full is 0.3 12.6
R407002: 0 full is 0.3 12.9
R408000: 0.5 full is 0.5 13.4
R409001: 1 full is 1 14.4
R409002: 0 full is 0.6 15
R410000: 0 full is 0.2 15.2
R411000: 0 full is 0.2 15.4
R501010: 0.3 full is 0.3 15.7
R501020: 0.3 full is 0.3 16.0
R502000: 0 full is 2 18.0
R503001: 0 full is 0.3 18.3
R503002: 0 full is 0.8 19.1
R504000: 0 full is 0.3 19.4
R600001: 0 full is 0.1 19.5
R600002: 0 full is 0.1 19.6
R600003: 0 full is 0.2 19.8
R600004: 0 full is 0.2 20.0


full of this section:
RESULT:
12.70


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