

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** 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 TNS_ADMIN=$ORACLE_HOME/network/admin
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:21:14 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:21:14 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/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


A: 0
ls: 0: No such file or directory


R102002=0




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


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


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

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> 
PRIVILEGE
----------------------------------------
CREATE SEQUENCE
ALTER SESSION
CREATE SYNONYM
CREATE ANY OUTLINE
CREATE TABLE
UNLIMITED TABLESPACE
CREATE SESSION
CREATE DATABASE LINK
ADMINISTER RESOURCE MANAGER
CREATE CLUSTER
CREATE DIMENSION

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

14 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:21:15 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:21:15 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:21:16 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:21:16 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:21:16 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:21:17 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:21:17 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:21:17 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:21:18 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:21:18 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


R201133=0




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

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


R201035=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


R201135=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> 
     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


R201235=0




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

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

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

SQL> Connected.
SQL> SQL> 
GRANTEE
------------------------------
OLTP_USER

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


A: OLTP_USER

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


R201042=0.2


A: YES


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:22 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:22 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:22 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:23 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:23 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:23 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:23 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:23 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:23 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:24 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 	 2	    0	       0	  0 NO		  3		0

SYS
DBMS_DATAPUMP
								 BODY			      PACKAGE BODY			 147129 	 1	  271	       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			  67200 	 1	35096	       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			 256244 	 1	   12	       0	  0 NO		  1		0

SYS
DBMS_STATS
								 TABLE/PROCEDURE	      PACKAGE				 132494 	 2	    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			 243755 	 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			 128993 	 1	  666	       0	  0 NO		  1		0

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

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

PERFSTAT
STATSPACK
								 BODY			      PACKAGE BODY			  64686 	 1	    1	       0	  0 YES 	  3		0

SYS
DBMS_XPLAN

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

PERFSTAT
STATSPACK
								 TABLE/PROCEDURE	      PACKAGE				  83346 	 1	    0	       0	  0 YES 	  1		0

SYS

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

SYS
DBMS_STATS
								 BODY			      PACKAGE BODY			 463606 	 1	  712	       0	  0 YES 	  2		0


OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
SYS
DBMS_PRVTAQIM
								 BODY			      PACKAGE BODY			 104845 	 1	   16	       0	  0 NO		  3		0

SYS
DBMS_METADATA_INT
								 BODY			      PACKAGE BODY			 222965 	 1	  926	       0	  0 NO		  2		0

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

SYS
KUPF$FILE
								 BODY			      PACKAGE BODY			  87405 	 1	  345	       0	  0 NO		  2		0

SYS
DBMS_STATS_INTERNAL

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

SYS
DBMS_PRVTAQIS
								 BODY			      PACKAGE BODY			 107913 	 2	   98	       1	  0 NO		  1		0

SYS

OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
DBMS_INTERNAL_LOGSTDBY
								 BODY			      PACKAGE BODY			 106790 	 1	   10	       0	  0 NO		  3		0

SYS
PRVT_ADVISOR
								 BODY			      PACKAGE BODY			  75280 	 1	   68	       0	  0 NO		  2		0


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

SYS
DBMS_SPACE
								 BODY			      PACKAGE BODY			 107438 	 1	13537	       0	  0 NO		  3		0

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

SYS
DBMS_SNAPSHOT_UTL
								 BODY			      PACKAGE BODY			  53909 	 2	   29	       0	  0 NO		  3		0

SYS
DBMS_RCVMAN

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

SYS
STANDARD
								 TABLE/PROCEDURE	      PACKAGE				 439692 	 1	    0	       8	  0 NO		  3		0

SYS

OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
DBMS_AQADM_SYS
								 BODY			      PACKAGE BODY			 213454 	 2	  252	       1	  0 NO		  3		0

SYS
DBMS_RCVMAN
								 BODY			      PACKAGE BODY			 383743 	 2	  357	       1	  0 NO		  2		0


28 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:25 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:26 2015

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

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

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


R302001=0



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

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

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

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


R302003=0



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

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

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

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_IDX

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

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

SQL> Connected.
SQL> SQL> 
Explained.

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

--------------------------------------------------------------------------------------------------
| Id  | Operation		    | Name		 | Rows  | Bytes | Cost (%CPU)| Time	 |
--------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT	    |			 |    84 |  2604 |    18   (0)| 00:00:01 |
|   1 |  TABLE ACCESS BY INDEX ROWID| CUSTOMERS 	 |    84 |  2604 |    18   (0)| 00:00:01 |
|*  2 |   INDEX RANGE SCAN	    | CUST_LAST_NAME_IDX |    84 |	 |     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_IDX |    84 |	 |     2   (0)| 00:00:01 |


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:30 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:31 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:31 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:31 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:32 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:32 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:32 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:33 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:33 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:33 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:34 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:34 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:34 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:34 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:35 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:35 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:35 2015

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

SQL> Connected.
SQL> SQL>   2  
 ANALYZEDT
----------
2193.26814

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

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

SQL> Connected.
SQL> SQL>   2  
 ANALYZEDT
----------
2193.26814

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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:21:36 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:36 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:37 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:37 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:37 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:38 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:38 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:39 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:40 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:40 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:40 2015

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

SQL> Connected.
SQL> SQL> 
SEGMENT_NAME
---------------------------------------------------------------------------------
T1
T2
T1_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


R409002=0.2


A: T1

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

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

SQL> Connected.
SQL> SQL> 
SEGMENT_NAME
---------------------------------------------------------------------------------
T1
T2
T1_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


R409002=.4


B: T2

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

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

SQL> Connected.
SQL> SQL> 
SEGMENT_NAME
---------------------------------------------------------------------------------
T1
T2
T1_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


R409002=.6


C: T1_ID


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

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

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

SQL> Connected.
SQL> SQL> SQL> SQL> 
SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT USER FROM DUAL
SELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (UPPER(USER) LIKE USERID)
SELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((UPPER(USER) LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
SELECT DECODE('A','A','1','2') FROM DUAL
SELECT last_name, salary FROM hr.employees
SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1),:"SYS_B_0"), NVL(SUM(C2),:"SYS_B_1") FROM (SELECT /*+ NO_PARALLEL("TRANSACTION") FULL("TRANSACTION") NO_PARALLEL_INDEX("TRANSACTION") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "TRANSACTION" "TRANSACTION") SAMPLESUB
select	* from transaction
select sysdate, trunc(SYSDATE+:"SYS_B_0"/:"SYS_B_1"/:"SYS_B_2"*:"SYS_B_3",:"SYS_B_4") from dual
SELECT :jobno jobno FROM DUAL
SELECT NAME NAME_COL_PLUS_SHOW_PARAM,DECODE(TYPE,:"SYS_B_00",:"SYS_B_01",:"SYS_B_02",:"SYS_B_03",:"SYS_B_04",:"SYS_B_05",:"SYS_B_06",:"SYS_B_07",:"SYS_B_08",:"SYS_B_09",	 :"SYS_B_10",:"SYS_B_11", :"SYS_B_12") TYPE,DISPLAY_VALUE VALUE_COL_PLUS_SHOW_PARAM FROM V$PARAMETER WHERE UPPER(NAME) LIKE UPPER(:"SYS_B_13") ORDER BY NAME_COL_PLUS_SHOW_PARAM,ROWNUM
select job, next_date, next_sec

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  from user_jobs
 where job = :jobno

select distinct
       dbid	       dbbid
     , instance_number instt_num
     , db_name	       dbb_name
     , instance_name   instt_name
     , host_name       host
  from stats$database_instance


SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT 'X' FROM STATS$DATABASE_INSTANCE WHERE INSTANCE_NUMBER = :B2 AND DBID = :B1
SELECT TO_CHAR(MAX(SNAP_TIME),'dd/mm/yyyy') FROM STATS$SNAPSHOT WHERE INSTANCE_NUMBER = :B2 AND DBID = :B1
select to_char(s.startup_time,:"SYS_B_00") instart_fmt
     , di.instance_name 				 inst_name
     , di.db_name					 db_name
     , s.snap_id					 snap_id
     , to_char(s.snap_time,:"SYS_B_01")        snapdat
     , s.snap_level					 lvl
     , substr(s.ucomment, :"SYS_B_02",:"SYS_B_03")			    commnt
  from stats$snapshot s
     , stats$database_instance di

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 where s.dbid		   = :dbid
   and di.dbid		   = :dbid
   and s.instance_number   = :inst_num
   and di.instance_number  = :inst_num
   and di.dbid		   = s.dbid
   and di.instance_number  = s.instance_number
   and di.startup_time	   = s.startup_time
   and s.snap_time	  >= decode( to_number(:"SYS_B_04")
				   , to_number(:"SYS_B_05",:"SYS_B_06",:"SYS_B_07"), s.snap_time
				   , :"SYS_B_08"						       , to_date(:"SYS_B_09",:"SYS_B_10")
				   , to_date(:max_snap_time,:"SYS_B_11") - (to_number(:"SYS_B_12") - :"SYS_B_13"))

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 order by db_name, instance_name, snap_id

SELECT SNAP_TIME , STARTUP_TIME , SESSION_ID , SERIAL# FROM STATS$SNAPSHOT WHERE SNAP_ID = :B3 AND INSTANCE_NUMBER = :B2 AND DBID = :B1
 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_index(t,"USER_ID_IDX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"USER_ID_IDX") */ count(*) as nrw,count(distinct sys_op_lbid(11959,'L',t.rowid)) as nlb,count(distinct "USER_ID") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SH"."TRANSACTION" t where "USER_ID" 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 "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

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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(11982,'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 "PERFSTAT"."STATS$STATSPACK_PARAMETER" 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 "SHARABLE_MEM_TH"),sum(sys_op_opnsize("SHARABLE_MEM_TH")),substrb(dump(min("SHARABLE_MEM_TH"),16,0,32),1,120),substrb(dump(max("SHARABLE_MEM_TH"),16,0,32),1,120),count(distinct "VERSION_COUNT_TH"),sum(sys_op_opnsize("VERSION_COUNT_TH")),substrb(dump(min("VERSION_COUNT_TH"),16,0,32),1,120),substrb(dump(max("VERSION_COUNT_TH"),16,0,32),1,120),count(distinct "PIN_STATSPACK"),sum(sys_op_opnsize("PIN_STATSPACK")),substrb(dump(min("PIN_STATSPACK"),16,0,32),1,120),substrb(dump(max("PIN_STATSPACK"),16,0,32),1,120),count(distinct "ALL_INIT"),sum(sys_op_opnsize("ALL_INIT")),substrb(dump(min("ALL_INIT"),16,0,32),1,120),substrb(dump(max("ALL_INIT"),16,0,32),1,120),count("LAST_MODIFIED"),count(distinct "LAST_MODIFIED"),substrb(dump(min("LAST_MO
DIFIED"),16,0,32),1,120),substrb(dump(max("LAST_MODIFIED"),16,0,32),1,120),count("UCOMMENT"),count(distinct "UCOMMENT"),sum(sys_op_opnsize("UCOMMENT")),substrb(dump(min(substrb("UCOMMENT",1,32)),16,0,32),1,120),substrb(dump(max(substrb("UCOMMENT",1,32)),16,0,32),1,120),count("JOB"),count(distinct "JOB"),sum(sys_op_opnsize("JOB")),substrb(dump(min("JOB"),16,0,32),1,120),substrb(dump(max("JOB"),16,0,32),1,120),count(distinct "SEG_PHY_READS_TH"),sum(sys_op_opnsize("SEG_PHY_READS_TH")),substrb(dump(min("SEG_PHY_READS_TH"),16,0,32),1,120),substrb(dump(max("SEG_PHY_READS_TH"),16,0,32),1,120),count(distinct "SEG_LOG_READS_TH"),sum(sys_op_opnsize("SEG_LOG_READS_TH")),substrb(dump(min("SEG_LOG_READS_TH"),16,0,32),1,120),substrb(dump(max("SEG_LOG_READS_TH"),16,0,32),1,120),count(distinct "SEG_BUFF_BUSY_TH"),sum(sys_op_opnsize("SEG_BUFF_BUSY_TH")),substrb(dump(min("SEG_BUFF_BUSY_TH"),16,0,32),1,120
),substrb(dump(max("SEG_BUFF_BUSY_TH"),16,0,32),1,120),count(distinct "SEG_ROWLOCK_W_TH"),sum(sys_op_opnsize("SEG_ROWLOCK_W_TH")),substrb(dump(min("SEG_ROWLOCK_W_TH"),16,0,32),1,120),substrb(dump(max("SEG_ROWLOCK_W_TH"),16,0,32),1,120),count(distinct "SEG_ITL_WAITS_TH"),sum(sys_op_opnsize("SEG_ITL_WAITS_TH")),substrb(dump(min("SEG_ITL_WAITS_TH"),16,0,32),1,120),substrb(dump(max("SEG_ITL_WAITS_TH"),16,0,32),1,120),count(distinct "SEG_CR_BKS_RC_TH"),sum(sys_op_opnsize("SEG_CR_BKS_RC_TH")),substrb(dump(min("SEG_CR_BKS_RC_TH"),16,0,32),1,120),substrb(dump(max("SEG_CR_BKS_RC_TH"),16,0,32),1,120),count(distinct "SEG_CU_BKS_RC_TH"),sum(sys_op_opnsize("SEG_CU_BKS_RC_TH")),substrb(dump(min("SEG_CU_BKS_RC_TH"),16,0,32),1,120),substrb(dump(max("SEG_CU_BKS_RC_TH"),16,0,32),1,120),count(distinct "OLD_SQL_CAPTURE_MTH"),sum(sys_op_opnsize("OLD_SQL_CAPTURE_MTH")),substrb(dump(min("OLD_SQL_CAPTURE_MTH"),
16,0,32),1,120),substrb(dump(max("OLD_SQL_CAPTURE_MTH"),16,0,32),1,120),sum(sys_op_opnsize("DBID")),sum(sys_op_opnsize("INSTANCE_NUMBER")),count(distinct "SESSION_ID"),sum(sys_op_opnsize("SESSION_ID")),substrb(dump(min("SESSION_ID"),16,0,32),1,120),substrb(dump(max("SESSION_ID"),16,0,32),1,120),count(distinct "SNAP_LEVEL"),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(distinct "NUM_SQL"),sum(sys_op_opnsize("NUM_SQL")),substrb(dump(min("NUM_SQL"),16,0,32),1,120),substrb(dump(max("NUM_SQL"),16,0,32),1,120),count(distinct "EXECUTIONS_TH"),sum(sys_op_opnsize("EXECUTIONS_TH")),substrb(dump(min("EXECUTIONS_TH"),16,0,32),1,120),substrb(dump(max("EXECUTIONS_TH"),16,0,32),1,120),count(distinct "PARSE_CALLS_TH"),sum(sys_op_opnsize("PARSE_CALLS_TH")),substrb(dump(min("PARSE_CALLS_TH"),16,0,32),1,120),substrb(dum
p(max("PARSE_CALLS_TH"),16,0,32),1,120),count(distinct "DISK_READS_TH"),sum(sys_op_opnsize("DISK_READS_TH")),substrb(dump(min("DISK_READS_TH"),16,0,32),1,120),substrb(dump(max("DISK_READS_TH"),16,0,32),1,120),count(distinct "BUFFER_GETS_TH"),sum(sys_op_opnsize("BUFFER_GETS_TH")),substrb(dump(min("BUFFER_GETS_TH"),16,0,32),1,120),substrb(dump(max("BUFFER_GETS_TH"),16,0,32),1,120) from "PERFSTAT"."STATS$STATSPACK_PARAMETER" t

select /*+ no_parallel_index(t,"STATS$STATSPACK_PARAMETER_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$STATSPACK_PARAMETER_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12097,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$STATSPACK_PARAMETER" t where "DBID" is not null or "INSTANCE_NUMBER" 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 "PERFSTAT"."STATS$IDLE_EVENT" 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("EVENT")),substrb(dump(min(substrb("EVENT",1,32)),16,0,32),1,120),substrb(dump(max(substrb("EVENT",1,32)),16,0,32),1,120) from "PERFSTAT"."STATS$IDLE_EVENT" t

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select /*+ no_parallel_index(t,"STATS$IDLE_EVENT_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$IDLE_EVENT_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12178,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$IDLE_EVENT" t where "EVENT" 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 "PERFSTAT"."STATS$DATABASE_INSTANCE" 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("DBID")),sum(sys_op_opnsize("INSTANCE_NUMBER")),count(distinct "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "PARALLEL"),sum(sys_op_opnsize("PARALLEL")),substrb(dump(min("PARALLEL"),16,0,32),1,120),substrb(dump(max("PARALLEL"),16,0,32),1,120),count(distinct "VERSION"),sum(sys_op_opnsize("VERSION")),substrb(dump(min("VERSION"),16,0,32),1,120),substrb(dump(max("VERSION"),16,0,32),1,120),count(distinct "DB_NAME"),sum(sys_op_opnsize("DB_NAME")),substrb(dump(min("DB_NAME"),16,0,32),1,120),substrb(dump(max("DB_NAME"),16,0,32),1,120),count(distinct "INSTANCE_NAME"),sum(sys_op_opnsize("INSTANCE_NAME")),substrb(dump(min("INSTANCE_NAME"),16
,0,32),1,120),substrb(dump(max("INSTANCE_NAME"),16,0,32),1,120),count("HOST_NAME"),count(distinct "HOST_NAME"),sum(sys_op_opnsize("HOST_NAME")),substrb(dump(min(substrb("HOST_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("HOST_NAME",1,32)),16,0,32),1,120) from "PERFSTAT"."STATS$DATABASE_INSTANCE" t

select /*+ no_parallel_index(t,"STATS$DATABASE_INSTANCE_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$DATABASE_INSTANCE_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11979,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$DATABASE_INSTANCE" t where "DBID" is not null or "INSTANCE_NUMBER" is not null or "STARTUP_TIME" 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 "PERFSTAT"."STATS$SNAPSHOT" 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_ID")),sum(sys_op_opnsize("DBID")),sum(sys_op_opnsize("INSTANCE_NUMBER")),count(distinct "SESSION_ID"),sum(sys_op_opnsize("SESSION_ID")),substrb(dump(min("SESSION_ID"),16,0,32),1,120),substrb(dump(max("SESSION_ID"),16,0,32),1,120),count("SERIAL#"),count(distinct "SERIAL#"),sum(sys_op_opnsize("SERIAL#")),substrb(dump(min("SERIAL#"),16,0,32),1,120),substrb(dump(max("SERIAL#"),16,0,32),1,120),count("SNAP_LEVEL"),count(distinct "SNAP_LEVEL"),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("UCOMMENT"),count(distinct "UCOMMENT"),sum(sys_op_opnsize("UCOMMENT")),substrb(dump(min(substrb("UCOMMENT",1,32)),16,0,32),1,120),substrb(dump(max(substrb("
UCOMMENT",1,32)),16,0,32),1,120),count("EXECUTIONS_TH"),count(distinct "EXECUTIONS_TH"),sum(sys_op_opnsize("EXECUTIONS_TH")),substrb(dump(min("EXECUTIONS_TH"),16,0,32),1,120),substrb(dump(max("EXECUTIONS_TH"),16,0,32),1,120),count("PARSE_CALLS_TH"),count(distinct "PARSE_CALLS_TH"),sum(sys_op_opnsize("PARSE_CALLS_TH")),substrb(dump(min("PARSE_CALLS_TH"),16,0,32),1,120),substrb(dump(max("PARSE_CALLS_TH"),16,0,32),1,120),count("DISK_READS_TH"),count(distinct "DISK_READS_TH"),sum(sys_op_opnsize("DISK_READS_TH")),substrb(dump(min("DISK_READS_TH"),16,0,32),1,120),substrb(dump(max("DISK_READS_TH"),16,0,32),1,120),count("BUFFER_GETS_TH"),count(distinct "BUFFER_GETS_TH"),sum(sys_op_opnsize("BUFFER_GETS_TH")),substrb(dump(min("BUFFER_GETS_TH"),16,0,32),1,120),substrb(dump(max("BUFFER_GETS_TH"),16,0,32),1,120),count("SHARABLE_MEM_TH"),count(distinct "SHARABLE_MEM_TH"),sum(sys_op_opnsize("SHARABLE_M
EM_TH")),substrb(dump(min("SHARABLE_MEM_TH"),16,0,32),1,120),substrb(dump(max("SHARABLE_MEM_TH"),16,0,32),1,120),count("VERSION_COUNT_TH"),count(distinct "VERSION_COUNT_TH"),sum(sys_op_opnsize("VERSION_COUNT_TH")),substrb(dump(min("VERSION_COUNT_TH"),16,0,32),1,120),substrb(dump(max("VERSION_COUNT_TH"),16,0,32),1,120),count(distinct "SEG_PHY_READS_TH"),sum(sys_op_opnsize("SEG_PHY_READS_TH")),substrb(dump(min("SEG_PHY_READS_TH"),16,0,32),1,120),substrb(dump(max("SEG_PHY_READS_TH"),16,0,32),1,120),count(distinct "SEG_LOG_READS_TH"),sum(sys_op_opnsize("SEG_LOG_READS_TH")),substrb(dump(min("SEG_LOG_READS_TH"),16,0,32),1,120),substrb(dump(max("SEG_LOG_READS_TH"),16,0,32),1,120),count(distinct "SEG_BUFF_BUSY_TH"),sum(sys_op_opnsize("SEG_BUFF_BUSY_TH")),substrb(dump(min("SEG_BUFF_BUSY_TH"),16,0,32),1,120),substrb(dump(max("SEG_BUFF_BUSY_TH"),16,0,32),1,120),count(distinct "SEG_ROWLOCK_W_TH"),su
m(sys_op_opnsize("SEG_ROWLOCK_W_TH")),substrb(dump(min("SEG_ROWLOCK_W_TH"),16,0,32),1,120),substrb(dump(max("SEG_ROWLOCK_W_TH"),16,0,32),1,120),count(distinct "SEG_ITL_WAITS_TH"),sum(sys_op_opnsize("SEG_ITL_WAITS_TH")),substrb(dump(min("SEG_ITL_WAITS_TH"),16,0,32),1,120),substrb(dump(max("SEG_ITL_WAITS_TH"),16,0,32),1,120),count("SEG_CR_BKS_RC_TH"),count(distinct "SEG_CR_BKS_RC_TH"),sum(sys_op_opnsize("SEG_CR_BKS_RC_TH")),substrb(dump(min("SEG_CR_BKS_RC_TH"),16,0,32),1,120),substrb(dump(max("SEG_CR_BKS_RC_TH"),16,0,32),1,120),count("SEG_CU_BKS_RC_TH"),count(distinct "SEG_CU_BKS_RC_TH"),sum(sys_op_opnsize("SEG_CU_BKS_RC_TH")),substrb(dump(min("SEG_CU_BKS_RC_TH"),16,0,32),1,120),substrb(dump(max("SEG_CU_BKS_RC_TH"),16,0,32),1,120),count("SEG_CR_BKS_SD_TH"),count(distinct "SEG_CR_BKS_SD_TH"),sum(sys_op_opnsize("SEG_CR_BKS_SD_TH")),substrb(dump(min("SEG_CR_BKS_SD_TH"),16,0,32),1,120),substrb

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(dump(max("SEG_CR_BKS_SD_TH"),16,0,32),1,120),count("SEG_CU_BKS_SD_TH"),count(distinct "SEG_CU_BKS_SD_TH"),sum(sys_op_opnsize("SEG_CU_BKS_SD_TH")),substrb(dump(min("SEG_CU_BKS_SD_TH"),16,0,32),1,120),substrb(dump(max("SEG_CU_BKS_SD_TH"),16,0,32),1,120),count("SNAPSHOT_EXEC_TIME_S"),count(distinct "SNAPSHOT_EXEC_TIME_S"),sum(sys_op_opnsize("SNAPSHOT_EXEC_TIME_S")),substrb(dump(min("SNAPSHOT_EXEC_TIME_S"),16,0,32),1,120),substrb(dump(max("SNAPSHOT_EXEC_TIME_S"),16,0,32),1,120),count("ALL_INIT"),count(distinct "ALL_INIT"),sum(sys_op_opnsize("ALL_INIT")),substrb(dump(min("ALL_INIT"),16,0,32),1,120),substrb(dump(max("ALL_INIT"),16,0,32),1,120),count("BASELINE"),count(distinct "BASELINE"),sum(sys_op_opnsize("BASELINE")),substrb(dump(min("BASELINE"),16,0,32),1,120),substrb(dump(max("BASELINE"),16,0,32),1,120) from "PERFSTAT"."STATS$SNAPSHOT" t

select /*+ no_parallel_index(t,"STATS$SNAPSHOT_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SNAPSHOT_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11985,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SNAPSHOT" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" 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 "PERFSTAT"."STATS$DB_CACHE_ADVICE" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "ID"),sum(sys_op_opnsize("ID")),substrb(dump(min("ID"),16,0,32),1,120),substrb(dump(max("ID"),16,0,32),1,120),count(distinct "NAME"),sum(sys_op_opnsize("NAME")),substrb(dump(min("NAME"),16,0,32),1,120),substrb(dump(max("NAME"),16,0,32),1,120),count(distinct "BLOCK_SIZE"),sum(sys_op_opn
size("BLOCK_SIZE")),substrb(dump(min("BLOCK_SIZE"),16,0,32),1,120),substrb(dump(max("BLOCK_SIZE"),16,0,32),1,120),count(distinct "BUFFERS_FOR_ESTIMATE"),sum(sys_op_opnsize("BUFFERS_FOR_ESTIMATE")),substrb(dump(min("BUFFERS_FOR_ESTIMATE"),16,0,32),1,120),substrb(dump(max("BUFFERS_FOR_ESTIMATE"),16,0,32),1,120),count("ADVICE_STATUS"),count(distinct "ADVICE_STATUS"),sum(sys_op_opnsize("ADVICE_STATUS")),substrb(dump(min("ADVICE_STATUS"),16,0,32),1,120),substrb(dump(max("ADVICE_STATUS"),16,0,32),1,120),count("SIZE_FOR_ESTIMATE"),count(distinct "SIZE_FOR_ESTIMATE"),sum(sys_op_opnsize("SIZE_FOR_ESTIMATE")),substrb(dump(min("SIZE_FOR_ESTIMATE"),16,0,32),1,120),substrb(dump(max("SIZE_FOR_ESTIMATE"),16,0,32),1,120),count("SIZE_FACTOR"),count(distinct "SIZE_FACTOR"),sum(sys_op_opnsize("SIZE_FACTOR")),substrb(dump(min("SIZE_FACTOR"),16,0,32),1,120),substrb(dump(max("SIZE_FACTOR"),16,0,32),1,120),cou
nt("ESTD_PHYSICAL_READ_FACTOR"),count(distinct "ESTD_PHYSICAL_READ_FACTOR"),sum(sys_op_opnsize("ESTD_PHYSICAL_READ_FACTOR")),substrb(dump(min("ESTD_PHYSICAL_READ_FACTOR"),16,0,32),1,120),substrb(dump(max("ESTD_PHYSICAL_READ_FACTOR"),16,0,32),1,120),count("ESTD_PHYSICAL_READS"),count(distinct "ESTD_PHYSICAL_READS"),sum(sys_op_opnsize("ESTD_PHYSICAL_READS")),substrb(dump(min("ESTD_PHYSICAL_READS"),16,0,32),1,120),substrb(dump(max("ESTD_PHYSICAL_READS"),16,0,32),1,120),count("ESTD_PHYSICAL_READ_TIME"),count(distinct "ESTD_PHYSICAL_READ_TIME"),sum(sys_op_opnsize("ESTD_PHYSICAL_READ_TIME")),substrb(dump(min("ESTD_PHYSICAL_READ_TIME"),16,0,32),1,120),substrb(dump(max("ESTD_PHYSICAL_READ_TIME"),16,0,32),1,120),count("ESTD_PCT_OF_DB_TIME_FOR_READS"),count(distinct "ESTD_PCT_OF_DB_TIME_FOR_READS"),sum(sys_op_opnsize("ESTD_PCT_OF_DB_TIME_FOR_READS")),substrb(dump(min("ESTD_PCT_OF_DB_TIME_FOR_READS
"),16,0,32),1,120),substrb(dump(max("ESTD_PCT_OF_DB_TIME_FOR_READS"),16,0,32),1,120),count("ESTD_CLUSTER_READS"),count(distinct "ESTD_CLUSTER_READS"),sum(sys_op_opnsize("ESTD_CLUSTER_READS")),substrb(dump(min("ESTD_CLUSTER_READS"),16,0,32),1,120),substrb(dump(max("ESTD_CLUSTER_READS"),16,0,32),1,120),count("ESTD_CLUSTER_READ_TIME"),count(distinct "ESTD_CLUSTER_READ_TIME"),sum(sys_op_opnsize("ESTD_CLUSTER_READ_TIME")),substrb(dump(min("ESTD_CLUSTER_READ_TIME"),16,0,32),1,120),substrb(dump(max("ESTD_CLUSTER_READ_TIME"),16,0,32),1,120) from "PERFSTAT"."STATS$DB_CACHE_ADVICE" t

select /*+ no_parallel_index(t,"STATS$DB_CACHE_ADVICE_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$DB_CACHE_ADVICE_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11988,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$DB_CACHE_ADVICE" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "ID" is not null or "BUFFERS_FOR_ESTIMATE" 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 "PERFSTAT"."STATS$TEMPSTATXS" 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(distinct "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "TSNAME"),sum(sys_op_opnsize("TSNAME")),substrb(dump(min("TSNAME"),16,0,32),1,120),substrb(dump(max("TSNAME"),16,0,32),1,120),count(distinct "FILENAME"),sum(sys_op_opnsize("FILENAME")),substrb(dump(min(substrb("FILENAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("FILENAME",1,32))
,16,0,32),1,120),count("PHYRDS"),count(distinct "PHYRDS"),sum(sys_op_opnsize("PHYRDS")),substrb(dump(min("PHYRDS"),16,0,32),1,120),substrb(dump(max("PHYRDS"),16,0,32),1,120),count("PHYWRTS"),count(distinct "PHYWRTS"),sum(sys_op_opnsize("PHYWRTS")),substrb(dump(min("PHYWRTS"),16,0,32),1,120),substrb(dump(max("PHYWRTS"),16,0,32),1,120),count("SINGLEBLKRDS"),count(distinct "SINGLEBLKRDS"),sum(sys_op_opnsize("SINGLEBLKRDS")),substrb(dump(min("SINGLEBLKRDS"),16,0,32),1,120),substrb(dump(max("SINGLEBLKRDS"),16,0,32),1,120),count("READTIM"),count(distinct "READTIM"),sum(sys_op_opnsize("READTIM")),substrb(dump(min("READTIM"),16,0,32),1,120),substrb(dump(max("READTIM"),16,0,32),1,120),count("WRITETIM"),count(distinct "WRITETIM"),sum(sys_op_opnsize("WRITETIM")),substrb(dump(min("WRITETIM"),16,0,32),1,120),substrb(dump(max("WRITETIM"),16,0,32),1,120),count("SINGLEBLKRDTIM"),count(distinct "SINGLEBL
KRDTIM"),sum(sys_op_opnsize("SINGLEBLKRDTIM")),substrb(dump(min("SINGLEBLKRDTIM"),16,0,32),1,120),substrb(dump(max("SINGLEBLKRDTIM"),16,0,32),1,120),count("PHYBLKRD"),count(distinct "PHYBLKRD"),sum(sys_op_opnsize("PHYBLKRD")),substrb(dump(min("PHYBLKRD"),16,0,32),1,120),substrb(dump(max("PHYBLKRD"),16,0,32),1,120),count("PHYBLKWRT"),count(distinct "PHYBLKWRT"),sum(sys_op_opnsize("PHYBLKWRT")),substrb(dump(min("PHYBLKWRT"),16,0,32),1,120),substrb(dump(max("PHYBLKWRT"),16,0,32),1,120),count("WAIT_COUNT"),count(distinct "WAIT_COUNT"),sum(sys_op_opnsize("WAIT_COUNT")),substrb(dump(min("WAIT_COUNT"),16,0,32),1,120),substrb(dump(max("WAIT_COUNT"),16,0,32),1,120),count("TIME"),count(distinct "TIME"),sum(sys_op_opnsize("TIME")),substrb(dump(min("TIME"),16,0,32),1,120),substrb(dump(max("TIME"),16,0,32),1,120),count("FILE#"),count(distinct "FILE#"),sum(sys_op_opnsize("FILE#")),substrb(dump(min("FI
LE#"),16,0,32),1,120),substrb(dump(max("FILE#"),16,0,32),1,120) from "PERFSTAT"."STATS$TEMPSTATXS" t

select /*+ no_parallel_index(t,"STATS$TEMPSTATXS_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$TEMPSTATXS_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11994,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$TEMPSTATXS" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "TSNAME" is not null or "FILENAME" 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 "PERFSTAT"."STATS$LATCH" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "NAME"),sum(sys_op_opnsize("NAME")),substrb(dump(min(substrb("NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("NAME",1,32)),16,0,32),1,120),count(distinct "LATCH#"),sum(sys_op_opnsize("LATCH#")),substrb(dump(min("LATCH#"),16,0,32),1,120),substrb(dump(max("LATCH#"),16,0,32),1,120)
,count("LEVEL#"),count(distinct "LEVEL#"),sum(sys_op_opnsize("LEVEL#")),substrb(dump(min("LEVEL#"),16,0,32),1,120),substrb(dump(max("LEVEL#"),16,0,32),1,120),count("GETS"),count(distinct "GETS"),sum(sys_op_opnsize("GETS")),substrb(dump(min("GETS"),16,0,32),1,120),substrb(dump(max("GETS"),16,0,32),1,120),count("MISSES"),count(distinct "MISSES"),sum(sys_op_opnsize("MISSES")),substrb(dump(min("MISSES"),16,0,32),1,120),substrb(dump(max("MISSES"),16,0,32),1,120),count("SLEEPS"),count(distinct "SLEEPS"),sum(sys_op_opnsize("SLEEPS")),substrb(dump(min("SLEEPS"),16,0,32),1,120),substrb(dump(max("SLEEPS"),16,0,32),1,120),count("IMMEDIATE_GETS"),count(distinct "IMMEDIATE_GETS"),sum(sys_op_opnsize("IMMEDIATE_GETS")),substrb(dump(min("IMMEDIATE_GETS"),16,0,32),1,120),substrb(dump(max("IMMEDIATE_GETS"),16,0,32),1,120),count("IMMEDIATE_MISSES"),count(distinct "IMMEDIATE_MISSES"),sum(sys_op_opnsize("IMM
EDIATE_MISSES")),substrb(dump(min("IMMEDIATE_MISSES"),16,0,32),1,120),substrb(dump(max("IMMEDIATE_MISSES"),16,0,32),1,120),count("SPIN_GETS"),count(distinct "SPIN_GETS"),sum(sys_op_opnsize("SPIN_GETS")),substrb(dump(min("SPIN_GETS"),16,0,32),1,120),substrb(dump(max("SPIN_GETS"),16,0,32),1,120),count("SLEEP1"),count(distinct "SLEEP1"),sum(sys_op_opnsize("SLEEP1")),substrb(dump(min("SLEEP1"),16,0,32),1,120),substrb(dump(max("SLEEP1"),16,0,32),1,120),count("SLEEP2"),count(distinct "SLEEP2"),sum(sys_op_opnsize("SLEEP2")),substrb(dump(min("SLEEP2"),16,0,32),1,120),substrb(dump(max("SLEEP2"),16,0,32),1,120),count("SLEEP3"),count(distinct "SLEEP3"),sum(sys_op_opnsize("SLEEP3")),substrb(dump(min("SLEEP3"),16,0,32),1,120),substrb(dump(max("SLEEP3"),16,0,32),1,120),count("SLEEP4"),count(distinct "SLEEP4"),sum(sys_op_opnsize("SLEEP4")),substrb(dump(min("SLEEP4"),16,0,32),1,120),substrb(dump(max("SL
EEP4"),16,0,32),1,120),count("WAIT_TIME"),count(distinct "WAIT_TIME"),sum(sys_op_opnsize("WAIT_TIME")),substrb(dump(min("WAIT_TIME"),16,0,32),1,120),substrb(dump(max("WAIT_TIME"),16,0,32),1,120) from "PERFSTAT"."STATS$LATCH" t

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select /*+ no_parallel_index(t,"STATS$LATCH_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$LATCH_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11997,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$LATCH" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "NAME" 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 "PERFSTAT"."STATS$LATCH_MISSES_SUMMARY" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "PARENT_NAME"),sum(sys_op_opnsize("PARENT_NAME")),substrb(dump(min(substrb("PARENT_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("PARENT_NAME",1,32)),16,0,32),1,120),count(distinct "WHERE_IN_CODE"),sum(sys_op_opnsize("WHERE_IN_CODE")),substrb(dump(min(substrb("WHERE_IN_CODE",1,
32)),16,0,32),1,120),substrb(dump(max(substrb("WHERE_IN_CODE",1,32)),16,0,32),1,120),count("NWFAIL_COUNT"),count(distinct "NWFAIL_COUNT"),sum(sys_op_opnsize("NWFAIL_COUNT")),substrb(dump(min("NWFAIL_COUNT"),16,0,32),1,120),substrb(dump(max("NWFAIL_COUNT"),16,0,32),1,120),count("SLEEP_COUNT"),count(distinct "SLEEP_COUNT"),sum(sys_op_opnsize("SLEEP_COUNT")),substrb(dump(min("SLEEP_COUNT"),16,0,32),1,120),substrb(dump(max("SLEEP_COUNT"),16,0,32),1,120),count("WTR_SLP_COUNT"),count(distinct "WTR_SLP_COUNT"),sum(sys_op_opnsize("WTR_SLP_COUNT")),substrb(dump(min("WTR_SLP_COUNT"),16,0,32),1,120),substrb(dump(max("WTR_SLP_COUNT"),16,0,32),1,120) from "PERFSTAT"."STATS$LATCH_MISSES_SUMMARY" t

select /*+ no_parallel_index(t,"STATS$LATCH_MISSES_SUMMARY_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$LATCH_MISSES_SUMMARY_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12006,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$LATCH_MISSES_SUMMARY" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "PARENT_NAME" is not null or "WHERE_IN_CODE" 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 "PERFSTAT"."STATS$LIBRARYCACHE" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "NAMESPACE"),sum(sys_op_opnsize("NAMESPACE")),substrb(dump(min("NAMESPACE"),16,0,32),1,120),substrb(dump(max("NAMESPACE"),16,0,32),1,120),count("GETS"),count(distinct "GETS"),sum(sys_op_opnsize("GETS")),substrb(dump(min("GETS"),16,0,32),1,120),substrb(dump(max("GETS"),16,0,32),1,120),c
ount("GETHITS"),count(distinct "GETHITS"),sum(sys_op_opnsize("GETHITS")),substrb(dump(min("GETHITS"),16,0,32),1,120),substrb(dump(max("GETHITS"),16,0,32),1,120),count("PINS"),count(distinct "PINS"),sum(sys_op_opnsize("PINS")),substrb(dump(min("PINS"),16,0,32),1,120),substrb(dump(max("PINS"),16,0,32),1,120),count("PINHITS"),count(distinct "PINHITS"),sum(sys_op_opnsize("PINHITS")),substrb(dump(min("PINHITS"),16,0,32),1,120),substrb(dump(max("PINHITS"),16,0,32),1,120),count("RELOADS"),count(distinct "RELOADS"),sum(sys_op_opnsize("RELOADS")),substrb(dump(min("RELOADS"),16,0,32),1,120),substrb(dump(max("RELOADS"),16,0,32),1,120),count("INVALIDATIONS"),count(distinct "INVALIDATIONS"),sum(sys_op_opnsize("INVALIDATIONS")),substrb(dump(min("INVALIDATIONS"),16,0,32),1,120),substrb(dump(max("INVALIDATIONS"),16,0,32),1,120),count("DLM_LOCK_REQUESTS"),count(distinct "DLM_LOCK_REQUESTS"),sum(sys_op_op
nsize("DLM_LOCK_REQUESTS")),substrb(dump(min("DLM_LOCK_REQUESTS"),16,0,32),1,120),substrb(dump(max("DLM_LOCK_REQUESTS"),16,0,32),1,120),count("DLM_PIN_REQUESTS"),count(distinct "DLM_PIN_REQUESTS"),sum(sys_op_opnsize("DLM_PIN_REQUESTS")),substrb(dump(min("DLM_PIN_REQUESTS"),16,0,32),1,120),substrb(dump(max("DLM_PIN_REQUESTS"),16,0,32),1,120),count("DLM_PIN_RELEASES"),count(distinct "DLM_PIN_RELEASES"),sum(sys_op_opnsize("DLM_PIN_RELEASES")),substrb(dump(min("DLM_PIN_RELEASES"),16,0,32),1,120),substrb(dump(max("DLM_PIN_RELEASES"),16,0,32),1,120),count("DLM_INVALIDATION_REQUESTS"),count(distinct "DLM_INVALIDATION_REQUESTS"),sum(sys_op_opnsize("DLM_INVALIDATION_REQUESTS")),substrb(dump(min("DLM_INVALIDATION_REQUESTS"),16,0,32),1,120),substrb(dump(max("DLM_INVALIDATION_REQUESTS"),16,0,32),1,120),count("DLM_INVALIDATIONS"),count(distinct "DLM_INVALIDATIONS"),sum(sys_op_opnsize("DLM_INVALIDATIO

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NS")),substrb(dump(min("DLM_INVALIDATIONS"),16,0,32),1,120),substrb(dump(max("DLM_INVALIDATIONS"),16,0,32),1,120) from "PERFSTAT"."STATS$LIBRARYCACHE" t

select /*+ no_parallel_index(t,"STATS$LIBRARYCACHE_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$LIBRARYCACHE_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12009,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$LIBRARYCACHE" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "NAMESPACE" 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 "PERFSTAT"."STATS$BUFFER_POOL_STATISTICS" 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("SET_MSIZE"),count(distinct "SET_MSIZE"),sum(sys_op_opnsize("SET_MSIZE")),substrb(dump(min("SET_MSIZE"),16,0,32),1,120),substrb(dump(max("SET_MSIZE"),16,0,32),1,120),count("CNUM_REPL"),count(distinct "CNUM_REPL"),sum(sys_op_opnsize("CNUM_REPL")),substrb(dump(min("CNUM_REPL"),16,0,32),1,120),substrb(dump(max("CNUM_REPL"),16,0,32),1,120),count("CNUM_WRITE"),count(distinct "CNUM_WRITE"),sum(sys_op_opnsize("CNUM_WRITE")),substrb(dump(min("CNUM_WRITE"),16,0,32),1,120),substrb(dump(max("CNUM_WRITE"),16,0,32),1,120),count("CNUM_SET"),count(distinct "CNUM_SET"),sum(sys_op_opnsize("CNUM_SET")),substrb(dump(min("CNUM_SET"),16,0,32),1,120),substrb(dump(max("CNUM_SET"),16,0,32),1,120),count("BUF_GOT"),count(distinct "BUF_GOT"),sum(sys_op_opnsize("BUF_G
OT")),substrb(dump(min("BUF_GOT"),16,0,32),1,120),substrb(dump(max("BUF_GOT"),16,0,32),1,120),count("SUM_WRITE"),count(distinct "SUM_WRITE"),sum(sys_op_opnsize("SUM_WRITE")),substrb(dump(min("SUM_WRITE"),16,0,32),1,120),substrb(dump(max("SUM_WRITE"),16,0,32),1,120),count("SUM_SCAN"),count(distinct "SUM_SCAN"),sum(sys_op_opnsize("SUM_SCAN")),substrb(dump(min("SUM_SCAN"),16,0,32),1,120),substrb(dump(max("SUM_SCAN"),16,0,32),1,120),count("FREE_BUFFER_WAIT"),count(distinct "FREE_BUFFER_WAIT"),sum(sys_op_opnsize("FREE_BUFFER_WAIT")),substrb(dump(min("FREE_BUFFER_WAIT"),16,0,32),1,120),substrb(dump(max("FREE_BUFFER_WAIT"),16,0,32),1,120),count("WRITE_COMPLETE_WAIT"),count(distinct "WRITE_COMPLETE_WAIT"),sum(sys_op_opnsize("WRITE_COMPLETE_WAIT")),substrb(dump(min("WRITE_COMPLETE_WAIT"),16,0,32),1,120),substrb(dump(max("WRITE_COMPLETE_WAIT"),16,0,32),1,120),count("BUFFER_BUSY_WAIT"),count(distin
ct "BUFFER_BUSY_WAIT"),sum(sys_op_opnsize("BUFFER_BUSY_WAIT")),substrb(dump(min("BUFFER_BUSY_WAIT"),16,0,32),1,120),substrb(dump(max("BUFFER_BUSY_WAIT"),16,0,32),1,120),count("FREE_BUFFER_INSPECTED"),count(distinct "FREE_BUFFER_INSPECTED"),sum(sys_op_opnsize("FREE_BUFFER_INSPECTED")),substrb(dump(min("FREE_BUFFER_INSPECTED"),16,0,32),1,120),substrb(dump(max("FREE_BUFFER_INSPECTED"),16,0,32),1,120),count("DIRTY_BUFFERS_INSPECTED"),count(distinct "DIRTY_BUFFERS_INSPECTED"),sum(sys_op_opnsize("DIRTY_BUFFERS_INSPECTED")),substrb(dump(min("DIRTY_BUFFERS_INSPECTED"),16,0,32),1,120),substrb(dump(max("DIRTY_BUFFERS_INSPECTED"),16,0,32),1,120),count("DB_BLOCK_CHANGE"),count(distinct "DB_BLOCK_CHANGE"),sum(sys_op_opnsize("DB_BLOCK_CHANGE")),substrb(dump(min("DB_BLOCK_CHANGE"),16,0,32),1,120),substrb(dump(max("DB_BLOCK_CHANGE"),16,0,32),1,120),count("DB_BLOCK_GETS"),count(distinct "DB_BLOCK_GETS"),
sum(sys_op_opnsize("DB_BLOCK_GETS")),substrb(dump(min("DB_BLOCK_GETS"),16,0,32),1,120),substrb(dump(max("DB_BLOCK_GETS"),16,0,32),1,120),count("CONSISTENT_GETS"),count(distinct "CONSISTENT_GETS"),sum(sys_op_opnsize("CONSISTENT_GETS")),substrb(dump(min("CONSISTENT_GETS"),16,0,32),1,120),substrb(dump(max("CONSISTENT_GETS"),16,0,32),1,120),count("PHYSICAL_READS"),count(distinct "PHYSICAL_READS"),sum(sys_op_opnsize("PHYSICAL_READS")),substrb(dump(min("PHYSICAL_READS"),16,0,32),1,120),substrb(dump(max("PHYSICAL_READS"),16,0,32),1,120),count("PHYSICAL_WRITES"),count(distinct "PHYSICAL_WRITES"),sum(sys_op_opnsize("PHYSICAL_WRITES")),substrb(dump(min("PHYSICAL_WRITES"),16,0,32),1,120),substrb(dump(max("PHYSICAL_WRITES"),16,0,32),1,120),count(distinct "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "D
BID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "ID"),sum(sys_op_opnsize("ID")),substrb(dump(min("ID"),16,0,32),1,120),substrb(dump(max("ID"),16,0,32),1,120),count("NAME"),count(distinct "NAME"),sum(sys_op_opnsize("NAME")),substrb(dump(min("NAME"),16,0,32),1,120),substrb(dump(max("NAME"),16,0,32),1,120),count("BLOCK_SIZE"),count(distinct "BLOCK_SIZE"),sum(sys_op_opnsize("BLOCK_SIZE")),substrb(dump(min("BLOCK_SIZE"),16,0,32),1,120),substrb(dump(max("BLOCK_SIZE"),16,0,32),1,120) from "PERFSTAT"."STATS$BUFFER_POOL_STATISTICS" t

select /*+ no_parallel_index(t,"STATS$BUFFER_POOL_STATS_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$BUFFER_POOL_STATS_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12012,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$BUFFER_POOL_STATISTICS" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "ID" is not null

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(*)  from "PERFSTAT"."STATS$ROLLSTAT" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "USN"),sum(sys_op_opnsize("USN")),substrb(dump(min("USN"),16,0,32),1,120),substrb(dump(max("USN"),16,0,32),1,120),count("EXTENTS"),count(distinct "EXTENTS"),sum(sys_op_opnsize("EXTENTS")),substrb(dump(min("EXTENTS"),16,0,32),1,120),substrb(dump(max("EXTENTS"),16,0,32),1,120),count("RSS
IZE"),count(distinct "RSSIZE"),sum(sys_op_opnsize("RSSIZE")),substrb(dump(min("RSSIZE"),16,0,32),1,120),substrb(dump(max("RSSIZE"),16,0,32),1,120),count("WRITES"),count(distinct "WRITES"),sum(sys_op_opnsize("WRITES")),substrb(dump(min("WRITES"),16,0,32),1,120),substrb(dump(max("WRITES"),16,0,32),1,120),count("XACTS"),count(distinct "XACTS"),sum(sys_op_opnsize("XACTS")),substrb(dump(min("XACTS"),16,0,32),1,120),substrb(dump(max("XACTS"),16,0,32),1,120),count("GETS"),count(distinct "GETS"),sum(sys_op_opnsize("GETS")),substrb(dump(min("GETS"),16,0,32),1,120),substrb(dump(max("GETS"),16,0,32),1,120),count("WAITS"),count(distinct "WAITS"),sum(sys_op_opnsize("WAITS")),substrb(dump(min("WAITS"),16,0,32),1,120),substrb(dump(max("WAITS"),16,0,32),1,120),count("OPTSIZE"),count(distinct "OPTSIZE"),sum(sys_op_opnsize("OPTSIZE")),substrb(dump(min("OPTSIZE"),16,0,32),1,120),substrb(dump(max("OPTSIZE")
,16,0,32),1,120),count("HWMSIZE"),count(distinct "HWMSIZE"),sum(sys_op_opnsize("HWMSIZE")),substrb(dump(min("HWMSIZE"),16,0,32),1,120),substrb(dump(max("HWMSIZE"),16,0,32),1,120),count("SHRINKS"),count(distinct "SHRINKS"),sum(sys_op_opnsize("SHRINKS")),substrb(dump(min("SHRINKS"),16,0,32),1,120),substrb(dump(max("SHRINKS"),16,0,32),1,120),count("WRAPS"),count(distinct "WRAPS"),sum(sys_op_opnsize("WRAPS")),substrb(dump(min("WRAPS"),16,0,32),1,120),substrb(dump(max("WRAPS"),16,0,32),1,120),count("EXTENDS"),count(distinct "EXTENDS"),sum(sys_op_opnsize("EXTENDS")),substrb(dump(min("EXTENDS"),16,0,32),1,120),substrb(dump(max("EXTENDS"),16,0,32),1,120),count("AVESHRINK"),count(distinct "AVESHRINK"),sum(sys_op_opnsize("AVESHRINK")),substrb(dump(min("AVESHRINK"),16,0,32),1,120),substrb(dump(max("AVESHRINK"),16,0,32),1,120),count("AVEACTIVE"),count(distinct "AVEACTIVE"),sum(sys_op_opnsize("AVEACT
IVE")),substrb(dump(min("AVEACTIVE"),16,0,32),1,120),substrb(dump(max("AVEACTIVE"),16,0,32),1,120) from "PERFSTAT"."STATS$ROLLSTAT" t

select /*+ no_parallel_index(t,"STATS$ROLLSTAT_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$ROLLSTAT_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12015,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$ROLLSTAT" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "USN" 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 "PERFSTAT"."STATS$ROWCACHE_SUMMARY" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "PARAMETER"),sum(sys_op_opnsize("PARAMETER")),substrb(dump(min("PARAMETER"),16,0,32),1,120),substrb(dump(max("PARAMETER"),16,0,32),1,120),count("TOTAL_USAGE"),count(distinct "TOTAL_USAGE"),sum(sys_op_opnsize("TOTAL_USAGE")),substrb(dump(min("TOTAL_USAGE"),16,0,32),1,120),substrb(dump(m
ax("TOTAL_USAGE"),16,0,32),1,120),count("USAGE"),count(distinct "USAGE"),sum(sys_op_opnsize("USAGE")),substrb(dump(min("USAGE"),16,0,32),1,120),substrb(dump(max("USAGE"),16,0,32),1,120),count("GETS"),count(distinct "GETS"),sum(sys_op_opnsize("GETS")),substrb(dump(min("GETS"),16,0,32),1,120),substrb(dump(max("GETS"),16,0,32),1,120),count("GETMISSES"),count(distinct "GETMISSES"),sum(sys_op_opnsize("GETMISSES")),substrb(dump(min("GETMISSES"),16,0,32),1,120),substrb(dump(max("GETMISSES"),16,0,32),1,120),count("SCANS"),count(distinct "SCANS"),sum(sys_op_opnsize("SCANS")),substrb(dump(min("SCANS"),16,0,32),1,120),substrb(dump(max("SCANS"),16,0,32),1,120),count("SCANMISSES"),count(distinct "SCANMISSES"),sum(sys_op_opnsize("SCANMISSES")),substrb(dump(min("SCANMISSES"),16,0,32),1,120),substrb(dump(max("SCANMISSES"),16,0,32),1,120),count("SCANCOMPLETES"),count(distinct "SCANCOMPLETES"),sum(sys_op_
opnsize("SCANCOMPLETES")),substrb(dump(min("SCANCOMPLETES"),16,0,32),1,120),substrb(dump(max("SCANCOMPLETES"),16,0,32),1,120),count("MODIFICATIONS"),count(distinct "MODIFICATIONS"),sum(sys_op_opnsize("MODIFICATIONS")),substrb(dump(min("MODIFICATIONS"),16,0,32),1,120),substrb(dump(max("MODIFICATIONS"),16,0,32),1,120),count("FLUSHES"),count(distinct "FLUSHES"),sum(sys_op_opnsize("FLUSHES")),substrb(dump(min("FLUSHES"),16,0,32),1,120),substrb(dump(max("FLUSHES"),16,0,32),1,120),count("DLM_REQUESTS"),count(distinct "DLM_REQUESTS"),sum(sys_op_opnsize("DLM_REQUESTS")),substrb(dump(min("DLM_REQUESTS"),16,0,32),1,120),substrb(dump(max("DLM_REQUESTS"),16,0,32),1,120),count("DLM_CONFLICTS"),count(distinct "DLM_CONFLICTS"),sum(sys_op_opnsize("DLM_CONFLICTS")),substrb(dump(min("DLM_CONFLICTS"),16,0,32),1,120),substrb(dump(max("DLM_CONFLICTS"),16,0,32),1,120),count("DLM_RELEASES"),count(distinct "DLM

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
_RELEASES"),sum(sys_op_opnsize("DLM_RELEASES")),substrb(dump(min("DLM_RELEASES"),16,0,32),1,120),substrb(dump(max("DLM_RELEASES"),16,0,32),1,120) from "PERFSTAT"."STATS$ROWCACHE_SUMMARY" t

select /*+ no_parallel_index(t,"STATS$ROWCACHE_SUMMARY_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$ROWCACHE_SUMMARY_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12018,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$ROWCACHE_SUMMARY" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "PARAMETER" 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 "PERFSTAT"."STATS$SGA" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "NAME"),sum(sys_op_opnsize("NAME")),substrb(dump(min(substrb("NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("NAME",1,32)),16,0,32),1,120),count(distinct "VALUE"),sum(sys_op_opnsize("VALUE")),substrb(dump(min("VALUE"),16,0,32),1,120),substrb(dump(max("VALUE"),16,0,32),1,120),cou
nt("STARTUP_TIME"),count(distinct "STARTUP_TIME"),substrb(dump(min("STARTUP_TIME"),16,0,32),1,120),substrb(dump(max("STARTUP_TIME"),16,0,32),1,120),count("PARALLEL"),count(distinct "PARALLEL"),sum(sys_op_opnsize("PARALLEL")),substrb(dump(min("PARALLEL"),16,0,32),1,120),substrb(dump(max("PARALLEL"),16,0,32),1,120),count("VERSION"),count(distinct "VERSION"),sum(sys_op_opnsize("VERSION")),substrb(dump(min("VERSION"),16,0,32),1,120),substrb(dump(max("VERSION"),16,0,32),1,120) from "PERFSTAT"."STATS$SGA" t

select /*+ no_parallel_index(t,"STATS$SGA_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SGA_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12021,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SGA" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "NAME" 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 "PERFSTAT"."STATS$SGASTAT" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "NAME"),sum(sys_op_opnsize("NAME")),substrb(dump(min(substrb("NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("NAME",1,32)),16,0,32),1,120),count("POOL"),count(distinct "POOL"),sum(sys_op_opnsize("POOL")),substrb(dump(min("POOL"),16,0,32),1,120),substrb(dump(max("POOL"),16,0,32),
1,120),count("BYTES"),count(distinct "BYTES"),sum(sys_op_opnsize("BYTES")),substrb(dump(min("BYTES"),16,0,32),1,120),substrb(dump(max("BYTES"),16,0,32),1,120) from "PERFSTAT"."STATS$SGASTAT" t

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select /*+ no_parallel_index(t,"STATS$SGASTAT_U") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SGASTAT_U") */ count(*) as nrw,count(distinct sys_op_lbid(12024,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SGASTAT" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "NAME" is not null or "POOL" 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 "PERFSTAT"."STATS$SYSSTAT" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "STATISTIC#"),sum(sys_op_opnsize("STATISTIC#")),substrb(dump(min("STATISTIC#"),16,0,32),1,120),substrb(dump(max("STATISTIC#"),16,0,32),1,120),count(distinct "NAME"),sum(sys_op_opnsize("NAME")),substrb(dump(min(substrb("NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("NAME",1,32))
,16,0,32),1,120),count("VALUE"),count(distinct "VALUE"),sum(sys_op_opnsize("VALUE")),substrb(dump(min("VALUE"),16,0,32),1,120),substrb(dump(max("VALUE"),16,0,32),1,120) from "PERFSTAT"."STATS$SYSSTAT" t

select /*+ no_parallel_index(t,"STATS$SYSSTAT_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SYSSTAT_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12027,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SYSSTAT" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "NAME" 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 "PERFSTAT"."STATS$SYSTEM_EVENT" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "EVENT"),sum(sys_op_opnsize("EVENT")),substrb(dump(min(substrb("EVENT",1,32)),16,0,32),1,120),substrb(dump(max(substrb("EVENT",1,32)),16,0,32),1,120),count("TOTAL_WAITS"),count(distinct "TOTAL_WAITS"),sum(sys_op_opnsize("TOTAL_WAITS")),substrb(dump(min("TOTAL_WAITS"),16,0,32),1,120),su
bstrb(dump(max("TOTAL_WAITS"),16,0,32),1,120),count("TOTAL_TIMEOUTS"),count(distinct "TOTAL_TIMEOUTS"),sum(sys_op_opnsize("TOTAL_TIMEOUTS")),substrb(dump(min("TOTAL_TIMEOUTS"),16,0,32),1,120),substrb(dump(max("TOTAL_TIMEOUTS"),16,0,32),1,120),count("TIME_WAITED_MICRO"),count(distinct "TIME_WAITED_MICRO"),sum(sys_op_opnsize("TIME_WAITED_MICRO")),substrb(dump(min("TIME_WAITED_MICRO"),16,0,32),1,120),substrb(dump(max("TIME_WAITED_MICRO"),16,0,32),1,120),count("EVENT_ID"),count(distinct "EVENT_ID"),sum(sys_op_opnsize("EVENT_ID")),substrb(dump(min("EVENT_ID"),16,0,32),1,120),substrb(dump(max("EVENT_ID"),16,0,32),1,120) from "PERFSTAT"."STATS$SYSTEM_EVENT" t


SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select /*+ no_parallel_index(t,"STATS$SYSTEM_EVENT_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SYSTEM_EVENT_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12033,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SYSTEM_EVENT" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "EVENT" 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 "PERFSTAT"."STATS$BG_EVENT_SUMMARY" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "EVENT"),sum(sys_op_opnsize("EVENT")),substrb(dump(min(substrb("EVENT",1,32)),16,0,32),1,120),substrb(dump(max(substrb("EVENT",1,32)),16,0,32),1,120),count("TOTAL_WAITS"),count(distinct "TOTAL_WAITS"),sum(sys_op_opnsize("TOTAL_WAITS")),substrb(dump(min("TOTAL_WAITS"),16,0,32),1,120),su
bstrb(dump(max("TOTAL_WAITS"),16,0,32),1,120),count("TOTAL_TIMEOUTS"),count(distinct "TOTAL_TIMEOUTS"),sum(sys_op_opnsize("TOTAL_TIMEOUTS")),substrb(dump(min("TOTAL_TIMEOUTS"),16,0,32),1,120),substrb(dump(max("TOTAL_TIMEOUTS"),16,0,32),1,120),count("TIME_WAITED_MICRO"),count(distinct "TIME_WAITED_MICRO"),sum(sys_op_opnsize("TIME_WAITED_MICRO")),substrb(dump(min("TIME_WAITED_MICRO"),16,0,32),1,120),substrb(dump(max("TIME_WAITED_MICRO"),16,0,32),1,120) from "PERFSTAT"."STATS$BG_EVENT_SUMMARY" t

select /*+ no_parallel_index(t,"STATS$BG_EVENT_SUMMARY_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$BG_EVENT_SUMMARY_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12039,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$BG_EVENT_SUMMARY" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "EVENT" 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 "PERFSTAT"."STATS$WAITSTAT" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "CLASS"),sum(sys_op_opnsize("CLASS")),substrb(dump(min("CLASS"),16,0,32),1,120),substrb(dump(max("CLASS"),16,0,32),1,120),count("WAIT_COUNT"),count(distinct "WAIT_COUNT"),sum(sys_op_opnsize("WAIT_COUNT")),substrb(dump(min("WAIT_COUNT"),16,0,32),1,120),substrb(dump(max("WAIT_COUNT"),16,
0,32),1,120),count("TIME"),count(distinct "TIME"),sum(sys_op_opnsize("TIME")),substrb(dump(min("TIME"),16,0,32),1,120),substrb(dump(max("TIME"),16,0,32),1,120) from "PERFSTAT"."STATS$WAITSTAT" t

select /*+ no_parallel_index(t,"STATS$WAITSTAT_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$WAITSTAT_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12042,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$WAITSTAT" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "CLASS" is not null

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(*)  from "PERFSTAT"."STATS$ENQUEUE_STATISTICS" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "EQ_TYPE"),sum(sys_op_opnsize("EQ_TYPE")),substrb(dump(min("EQ_TYPE"),16,0,32),1,120),substrb(dump(max("EQ_TYPE"),16,0,32),1,120),count(distinct "REQ_REASON"),sum(sys_op_opnsize("REQ_REASON")),substrb(dump(min(substrb("REQ_REASON",1,32)),16,0,32),1,120),substrb(dump(max(substrb("REQ_RE
ASON",1,32)),16,0,32),1,120),count("TOTAL_REQ#"),count(distinct "TOTAL_REQ#"),sum(sys_op_opnsize("TOTAL_REQ#")),substrb(dump(min("TOTAL_REQ#"),16,0,32),1,120),substrb(dump(max("TOTAL_REQ#"),16,0,32),1,120),count("TOTAL_WAIT#"),count(distinct "TOTAL_WAIT#"),sum(sys_op_opnsize("TOTAL_WAIT#")),substrb(dump(min("TOTAL_WAIT#"),16,0,32),1,120),substrb(dump(max("TOTAL_WAIT#"),16,0,32),1,120),count("SUCC_REQ#"),count(distinct "SUCC_REQ#"),sum(sys_op_opnsize("SUCC_REQ#")),substrb(dump(min("SUCC_REQ#"),16,0,32),1,120),substrb(dump(max("SUCC_REQ#"),16,0,32),1,120),count("FAILED_REQ#"),count(distinct "FAILED_REQ#"),sum(sys_op_opnsize("FAILED_REQ#")),substrb(dump(min("FAILED_REQ#"),16,0,32),1,120),substrb(dump(max("FAILED_REQ#"),16,0,32),1,120),count("CUM_WAIT_TIME"),count(distinct "CUM_WAIT_TIME"),sum(sys_op_opnsize("CUM_WAIT_TIME")),substrb(dump(min("CUM_WAIT_TIME"),16,0,32),1,120),substrb(dump(max
("CUM_WAIT_TIME"),16,0,32),1,120),count("EVENT#"),count(distinct "EVENT#"),sum(sys_op_opnsize("EVENT#")),substrb(dump(min("EVENT#"),16,0,32),1,120),substrb(dump(max("EVENT#"),16,0,32),1,120) from "PERFSTAT"."STATS$ENQUEUE_STATISTICS" t

select /*+ no_parallel_index(t,"STATS$ENQUEUE_STATISTICS_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$ENQUEUE_STATISTICS_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12045,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$ENQUEUE_STATISTICS" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "EQ_TYPE" is not null or "REQ_REASON" 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 "PERFSTAT"."STATS$SQL_SUMMARY" 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("FORCE_MATCHING_SIGNATURE"),count(distinct "FORCE_MATCHING_SIGNATURE"),sum(sys_op_opnsize("FORCE_MATCHING_SIGNATURE")),substrb(dump(min("FORCE_MATCHING_SIGNATURE"),16,0,32),1,120),substrb(dump(max("FORCE_MATCHING_SIGNATURE"),16,0,32),1,120),count("LAST_ACTIVE_TIME"),count(distinct "LAST_ACTIVE_TIME"),substrb(dump(min("LAST_ACTIVE_TIME"),16,0,32),1,120),substrb(dump(max("LAST_ACTIVE_TIME"),16,0,32),1,120),sum(sys_op_opnsize("SNAP_ID")),sum(sys_op_opnsize("DBID")),sum(sys_op_opnsize("INSTANCE_NUMBER")),count(distinct "TEXT_SUBSET"),sum(sys_op_opnsize("TEXT_SUBSET")),substrb(dump(min("TEXT_SUBSET"),16,0,32),1,120),substrb(dump(max("TEXT_SUBSET"),16,0,32),1,120),count("SQL_TEXT"),count(distinct "SQL_TEXT"),sum(sys_op_opnsize("SQL_TEXT")),substr
b(dump(min(substrb("SQL_TEXT",1,32)),16,0,32),1,120),substrb(dump(max(substrb("SQL_TEXT",1,32)),16,0,32),1,120),count("SQL_ID"),count(distinct "SQL_ID"),sum(sys_op_opnsize("SQL_ID")),substrb(dump(min("SQL_ID"),16,0,32),1,120),substrb(dump(max("SQL_ID"),16,0,32),1,120),count("SHARABLE_MEM"),count(distinct "SHARABLE_MEM"),sum(sys_op_opnsize("SHARABLE_MEM")),substrb(dump(min("SHARABLE_MEM"),16,0,32),1,120),substrb(dump(max("SHARABLE_MEM"),16,0,32),1,120),count("SORTS"),count(distinct "SORTS"),sum(sys_op_opnsize("SORTS")),substrb(dump(min("SORTS"),16,0,32),1,120),substrb(dump(max("SORTS"),16,0,32),1,120),count("MODULE"),count(distinct "MODULE"),sum(sys_op_opnsize("MODULE")),substrb(dump(min(substrb("MODULE",1,32)),16,0,32),1,120),substrb(dump(max(substrb("MODULE",1,32)),16,0,32),1,120),count("LOADED_VERSIONS"),count(distinct "LOADED_VERSIONS"),sum(sys_op_opnsize("LOADED_VERSIONS")),substrb(d
ump(min("LOADED_VERSIONS"),16,0,32),1,120),substrb(dump(max("LOADED_VERSIONS"),16,0,32),1,120),count("FETCHES"),count(distinct "FETCHES"),sum(sys_op_opnsize("FETCHES")),substrb(dump(min("FETCHES"),16,0,32),1,120),substrb(dump(max("FETCHES"),16,0,32),1,120),count("EXECUTIONS"),count(distinct "EXECUTIONS"),sum(sys_op_opnsize("EXECUTIONS")),substrb(dump(min("EXECUTIONS"),16,0,32),1,120),substrb(dump(max("EXECUTIONS"),16,0,32),1,120),count("PX_SERVERS_EXECUTIONS"),count(distinct "PX_SERVERS_EXECUTIONS"),sum(sys_op_opnsize("PX_SERVERS_EXECUTIONS")),substrb(dump(min("PX_SERVERS_EXECUTIONS"),16,0,32),1,120),substrb(dump(max("PX_SERVERS_EXECUTIONS"),16,0,32),1,120),count("END_OF_FETCH_COUNT"),count(distinct "END_OF_FETCH_COUNT"),sum(sys_op_opnsize("END_OF_FETCH_COUNT")),substrb(dump(min("END_OF_FETCH_COUNT"),16,0,32),1,120),substrb(dump(max("END_OF_FETCH_COUNT"),16,0,32),1,120),count("LOADS"),co
unt(distinct "LOADS"),sum(sys_op_opnsize("LOADS")),substrb(dump(min("LOADS"),16,0,32),1,120),substrb(dump(max("LOADS"),16,0,32),1,120),count("INVALIDATIONS"),count(distinct "INVALIDATIONS"),sum(sys_op_opnsize("INVALIDATIONS")),substrb(dump(min("INVALIDATIONS"),16,0,32),1,120),substrb(dump(max("INVALIDATIONS"),16,0,32),1,120),count("PARSE_CALLS"),count(distinct "PARSE_CALLS"),sum(sys_op_opnsize("PARSE_CALLS")),substrb(dump(min("PARSE_CALLS"),16,0,32),1,120),substrb(dump(max("PARSE_CALLS"),16,0,32),1,120),count("DISK_READS"),count(distinct "DISK_READS"),sum(sys_op_opnsize("DISK_READS")),substrb(dump(min("DISK_READS"),16,0,32),1,120),substrb(dump(max("DISK_READS"),16,0,32),1,120),count("DIRECT_WRITES"),count(distinct "DIRECT_WRITES"),sum(sys_op_opnsize("DIRECT_WRITES")),substrb(dump(min("DIRECT_WRITES"),16,0,32),1,120),substrb(dump(max("DIRECT_WRITES"),16,0,32),1,120),count("BUFFER_GETS"),c

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ount(distinct "BUFFER_GETS"),sum(sys_op_opnsize("BUFFER_GETS")),substrb(dump(min("BUFFER_GETS"),16,0,32),1,120),substrb(dump(max("BUFFER_GETS"),16,0,32),1,120),count("APPLICATION_WAIT_TIME"),count(distinct "APPLICATION_WAIT_TIME"),sum(sys_op_opnsize("APPLICATION_WAIT_TIME")),substrb(dump(min("APPLICATION_WAIT_TIME"),16,0,32),1,120),substrb(dump(max("APPLICATION_WAIT_TIME"),16,0,32),1,120),count("CONCURRENCY_WAIT_TIME"),count(distinct "CONCURRENCY_WAIT_TIME"),sum(sys_op_opnsize("CONCURRENCY_WAIT_TIME")),substrb(dump(min("CONCURRENCY_WAIT_TIME"),16,0,32),1,120),substrb(dump(max("CONCURRENCY_WAIT_TIME"),16,0,32),1,120),count("CLUSTER_WAIT_TIME"),count(distinct "CLUSTER_WAIT_TIME"),sum(sys_op_opnsize("CLUSTER_WAIT_TIME")),substrb(dump(min("CLUSTER_WAIT_TIME"),16,0,32),1,120),substrb(dump(max("CLUSTER_WAIT_TIME"),16,0,32),1,120),count("USER_IO_WAIT_TIME"),count(distinct "USER_IO_WAIT_TIME"),s
um(sys_op_opnsize("USER_IO_WAIT_TIME")),substrb(dump(min("USER_IO_WAIT_TIME"),16,0,32),1,120),substrb(dump(max("USER_IO_WAIT_TIME"),16,0,32),1,120),count("PLSQL_EXEC_TIME"),count(distinct "PLSQL_EXEC_TIME"),sum(sys_op_opnsize("PLSQL_EXEC_TIME")),substrb(dump(min("PLSQL_EXEC_TIME"),16,0,32),1,120),substrb(dump(max("PLSQL_EXEC_TIME"),16,0,32),1,120),count("JAVA_EXEC_TIME"),count(distinct "JAVA_EXEC_TIME"),sum(sys_op_opnsize("JAVA_EXEC_TIME")),substrb(dump(min("JAVA_EXEC_TIME"),16,0,32),1,120),substrb(dump(max("JAVA_EXEC_TIME"),16,0,32),1,120),count("ROWS_PROCESSED"),count(distinct "ROWS_PROCESSED"),sum(sys_op_opnsize("ROWS_PROCESSED")),substrb(dump(min("ROWS_PROCESSED"),16,0,32),1,120),substrb(dump(max("ROWS_PROCESSED"),16,0,32),1,120),count("COMMAND_TYPE"),count(distinct "COMMAND_TYPE"),sum(sys_op_opnsize("COMMAND_TYPE")),substrb(dump(min("COMMAND_TYPE"),16,0,32),1,120),substrb(dump(max("
COMMAND_TYPE"),16,0,32),1,120),count("ADDRESS"),sum(sys_op_opnsize("ADDRESS")),count("HASH_VALUE"),sum(sys_op_opnsize("HASH_VALUE")),count(distinct "OLD_HASH_VALUE"),sum(sys_op_opnsize("OLD_HASH_VALUE")),substrb(dump(min("OLD_HASH_VALUE"),16,0,32),1,120),substrb(dump(max("OLD_HASH_VALUE"),16,0,32),1,120),count("VERSION_COUNT"),count(distinct "VERSION_COUNT"),sum(sys_op_opnsize("VERSION_COUNT")),substrb(dump(min("VERSION_COUNT"),16,0,32),1,120),substrb(dump(max("VERSION_COUNT"),16,0,32),1,120),count("CPU_TIME"),count(distinct "CPU_TIME"),sum(sys_op_opnsize("CPU_TIME")),substrb(dump(min("CPU_TIME"),16,0,32),1,120),substrb(dump(max("CPU_TIME"),16,0,32),1,120),count("ELAPSED_TIME"),count(distinct "ELAPSED_TIME"),sum(sys_op_opnsize("ELAPSED_TIME")),substrb(dump(min("ELAPSED_TIME"),16,0,32),1,120),substrb(dump(max("ELAPSED_TIME"),16,0,32),1,120),count("OUTLINE_SID"),count(distinct "OUTLINE_SID
"),sum(sys_op_opnsize("OUTLINE_SID")),substrb(dump(min("OUTLINE_SID"),16,0,32),1,120),substrb(dump(max("OUTLINE_SID"),16,0,32),1,120),count("OUTLINE_CATEGORY"),count(distinct "OUTLINE_CATEGORY"),sum(sys_op_opnsize("OUTLINE_CATEGORY")),substrb(dump(min(substrb("OUTLINE_CATEGORY",1,32)),16,0,32),1,120),substrb(dump(max(substrb("OUTLINE_CATEGORY",1,32)),16,0,32),1,120),count("CHILD_LATCH"),count(distinct "CHILD_LATCH"),sum(sys_op_opnsize("CHILD_LATCH")),substrb(dump(min("CHILD_LATCH"),16,0,32),1,120),substrb(dump(max("CHILD_LATCH"),16,0,32),1,120),count("SQL_PROFILE"),count(distinct "SQL_PROFILE"),sum(sys_op_opnsize("SQL_PROFILE")),substrb(dump(min(substrb("SQL_PROFILE",1,32)),16,0,32),1,120),substrb(dump(max(substrb("SQL_PROFILE",1,32)),16,0,32),1,120),count("PROGRAM_ID"),count(distinct "PROGRAM_ID"),sum(sys_op_opnsize("PROGRAM_ID")),substrb(dump(min("PROGRAM_ID"),16,0,32),1,120),substrb(d
ump(max("PROGRAM_ID"),16,0,32),1,120),count("PROGRAM_LINE#"),count(distinct "PROGRAM_LINE#"),sum(sys_op_opnsize("PROGRAM_LINE#")),substrb(dump(min("PROGRAM_LINE#"),16,0,32),1,120),substrb(dump(max("PROGRAM_LINE#"),16,0,32),1,120),count("EXACT_MATCHING_SIGNATURE"),count(distinct "EXACT_MATCHING_SIGNATURE"),sum(sys_op_opnsize("EXACT_MATCHING_SIGNATURE")),substrb(dump(min("EXACT_MATCHING_SIGNATURE"),16,0,32),1,120),substrb(dump(max("EXACT_MATCHING_SIGNATURE"),16,0,32),1,120) from "PERFSTAT"."STATS$SQL_SUMMARY" t

select /*+ no_parallel_index(t,"STATS$SQL_SUMMARY_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SQL_SUMMARY_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12048,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SQL_SUMMARY" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "OLD_HASH_VALUE" is not null or "TEXT_SUBSET" 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 "PERFSTAT"."STATS$SQL_STATISTICS" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "TOTAL_SQL"),sum(sys_op_opnsize("TOTAL_SQL")),substrb(dump(min("TOTAL_SQL"),16,0,32),1,120),substrb(dump(max("TOTAL_SQL"),16,0,32),1,120),count(distinct "TOTAL_SQL_MEM"),sum(sys_op_opnsize("TOTAL_SQL_MEM")),substrb(dump(min("TOTAL_SQL_MEM"),16,0,32),1,120),substrb(dump(max("TOTAL_SQL_M
EM"),16,0,32),1,120),count(distinct "SINGLE_USE_SQL"),sum(sys_op_opnsize("SINGLE_USE_SQL")),substrb(dump(min("SINGLE_USE_SQL"),16,0,32),1,120),substrb(dump(max("SINGLE_USE_SQL"),16,0,32),1,120),count(distinct "SINGLE_USE_SQL_MEM"),sum(sys_op_opnsize("SINGLE_USE_SQL_MEM")),substrb(dump(min("SINGLE_USE_SQL_MEM"),16,0,32),1,120),substrb(dump(max("SINGLE_USE_SQL_MEM"),16,0,32),1,120),count("TOTAL_CURSORS"),count(distinct "TOTAL_CURSORS"),sum(sys_op_opnsize("TOTAL_CURSORS")),substrb(dump(min("TOTAL_CURSORS"),16,0,32),1,120),substrb(dump(max("TOTAL_CURSORS"),16,0,32),1,120) from "PERFSTAT"."STATS$SQL_STATISTICS" t


SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select /*+ no_parallel_index(t,"STATS$SQL_STATISTICS_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SQL_STATISTICS_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12054,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SQL_STATISTICS" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" 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 "PERFSTAT"."STATS$RESOURCE_LIMIT" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "RESOURCE_NAME"),sum(sys_op_opnsize("RESOURCE_NAME")),substrb(dump(min("RESOURCE_NAME"),16,0,32),1,120),substrb(dump(max("RESOURCE_NAME"),16,0,32),1,120),count("CURRENT_UTILIZATION"),count(distinct "CURRENT_UTILIZATION"),sum(sys_op_opnsize("CURRENT_UTILIZATION")),substrb(dump(min("CURR
ENT_UTILIZATION"),16,0,32),1,120),substrb(dump(max("CURRENT_UTILIZATION"),16,0,32),1,120),count("MAX_UTILIZATION"),count(distinct "MAX_UTILIZATION"),sum(sys_op_opnsize("MAX_UTILIZATION")),substrb(dump(min("MAX_UTILIZATION"),16,0,32),1,120),substrb(dump(max("MAX_UTILIZATION"),16,0,32),1,120),count("INITIAL_ALLOCATION"),count(distinct "INITIAL_ALLOCATION"),sum(sys_op_opnsize("INITIAL_ALLOCATION")),substrb(dump(min("INITIAL_ALLOCATION"),16,0,32),1,120),substrb(dump(max("INITIAL_ALLOCATION"),16,0,32),1,120),count("LIMIT_VALUE"),count(distinct "LIMIT_VALUE"),sum(sys_op_opnsize("LIMIT_VALUE")),substrb(dump(min("LIMIT_VALUE"),16,0,32),1,120),substrb(dump(max("LIMIT_VALUE"),16,0,32),1,120) from "PERFSTAT"."STATS$RESOURCE_LIMIT" t

select /*+ no_parallel_index(t,"STATS$RESOURCE_LIMIT_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$RESOURCE_LIMIT_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12057,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$RESOURCE_LIMIT" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "RESOURCE_NAME" 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 "PERFSTAT"."STATS$UNDOSTAT" 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 "BEGIN_TIME"),substrb(dump(min("BEGIN_TIME"),16,0,32),1,120),substrb(dump(max("BEGIN_TIME"),16,0,32),1,120),count(distinct "END_TIME"),substrb(dump(min("END_TIME"),16,0,32),1,120),substrb(dump(max("END_TIME"),16,0,32),1,120),count(distinct "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),sum(sys_op_opnsize("DBID")),sum(sys_op_opnsize("INSTANCE_NUMBER")),count(distinct "UNDOTSN"),sum(sys_op_opnsize("UNDOTSN")),substrb(dump(min("UNDOTSN"),16,0,32),1,120),substrb(dump(max("UNDOTSN"),16,0,32),1,120),count("UNDOBLKS"),count(distinct "UNDOBLKS"),sum(sys_op_opnsize("UNDOBLKS")),substrb(dump(min("UNDOBLKS"),16,0,32),1,120),substrb(dump(max("UNDOBLKS"),16,0,32)
,1,120),count("TXNCOUNT"),count(distinct "TXNCOUNT"),sum(sys_op_opnsize("TXNCOUNT")),substrb(dump(min("TXNCOUNT"),16,0,32),1,120),substrb(dump(max("TXNCOUNT"),16,0,32),1,120),count("MAXQUERYLEN"),count(distinct "MAXQUERYLEN"),sum(sys_op_opnsize("MAXQUERYLEN")),substrb(dump(min("MAXQUERYLEN"),16,0,32),1,120),substrb(dump(max("MAXQUERYLEN"),16,0,32),1,120),count("MAXQUERYID"),count(distinct "MAXQUERYID"),sum(sys_op_opnsize("MAXQUERYID")),substrb(dump(min("MAXQUERYID"),16,0,32),1,120),substrb(dump(max("MAXQUERYID"),16,0,32),1,120),count("MAXCONCURRENCY"),count(distinct "MAXCONCURRENCY"),sum(sys_op_opnsize("MAXCONCURRENCY")),substrb(dump(min("MAXCONCURRENCY"),16,0,32),1,120),substrb(dump(max("MAXCONCURRENCY"),16,0,32),1,120),count("UNXPSTEALCNT"),count(distinct "UNXPSTEALCNT"),sum(sys_op_opnsize("UNXPSTEALCNT")),substrb(dump(min("UNXPSTEALCNT"),16,0,32),1,120),substrb(dump(max("UNXPSTEALCNT"
),16,0,32),1,120),count("UNXPBLKRELCNT"),count(distinct "UNXPBLKRELCNT"),sum(sys_op_opnsize("UNXPBLKRELCNT")),substrb(dump(min("UNXPBLKRELCNT"),16,0,32),1,120),substrb(dump(max("UNXPBLKRELCNT"),16,0,32),1,120),count("UNXPBLKREUCNT"),count(distinct "UNXPBLKREUCNT"),sum(sys_op_opnsize("UNXPBLKREUCNT")),substrb(dump(min("UNXPBLKREUCNT"),16,0,32),1,120),substrb(dump(max("UNXPBLKREUCNT"),16,0,32),1,120),count("EXPSTEALCNT"),count(distinct "EXPSTEALCNT"),sum(sys_op_opnsize("EXPSTEALCNT")),substrb(dump(min("EXPSTEALCNT"),16,0,32),1,120),substrb(dump(max("EXPSTEALCNT"),16,0,32),1,120),count("EXPBLKRELCNT"),count(distinct "EXPBLKRELCNT"),sum(sys_op_opnsize("EXPBLKRELCNT")),substrb(dump(min("EXPBLKRELCNT"),16,0,32),1,120),substrb(dump(max("EXPBLKRELCNT"),16,0,32),1,120),count("EXPBLKREUCNT"),count(distinct "EXPBLKREUCNT"),sum(sys_op_opnsize("EXPBLKREUCNT")),substrb(dump(min("EXPBLKREUCNT"),16,0,32
),1,120),substrb(dump(max("EXPBLKREUCNT"),16,0,32),1,120),count("SSOLDERRCNT"),count(distinct "SSOLDERRCNT"),sum(sys_op_opnsize("SSOLDERRCNT")),substrb(dump(min("SSOLDERRCNT"),16,0,32),1,120),substrb(dump(max("SSOLDERRCNT"),16,0,32),1,120),count("NOSPACEERRCNT"),count(distinct "NOSPACEERRCNT"),sum(sys_op_opnsize("NOSPACEERRCNT")),substrb(dump(min("NOSPACEERRCNT"),16,0,32),1,120),substrb(dump(max("NOSPACEERRCNT"),16,0,32),1,120),count("ACTIVEBLKS"),count(distinct "ACTIVEBLKS"),sum(sys_op_opnsize("ACTIVEBLKS")),substrb(dump(min("ACTIVEBLKS"),16,0,32),1,120),substrb(dump(max("ACTIVEBLKS"),16,0,32),1,120),count("UNEXPIREDBLKS"),count(distinct "UNEXPIREDBLKS"),sum(sys_op_opnsize("UNEXPIREDBLKS")),substrb(dump(min("UNEXPIREDBLKS"),16,0,32),1,120),substrb(dump(max("UNEXPIREDBLKS"),16,0,32),1,120),count("EXPIREDBLKS"),count(distinct "EXPIREDBLKS"),sum(sys_op_opnsize("EXPIREDBLKS")),substrb(dump(

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
min("EXPIREDBLKS"),16,0,32),1,120),substrb(dump(max("EXPIREDBLKS"),16,0,32),1,120),count("TUNED_UNDORETENTION"),count(distinct "TUNED_UNDORETENTION"),sum(sys_op_opnsize("TUNED_UNDORETENTION")),substrb(dump(min("TUNED_UNDORETENTION"),16,0,32),1,120),substrb(dump(max("TUNED_UNDORETENTION"),16,0,32),1,120) from "PERFSTAT"."STATS$UNDOSTAT" t

select /*+ no_parallel_index(t,"STATS$UNDOSTAT_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$UNDOSTAT_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12072,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$UNDOSTAT" t where "BEGIN_TIME" is not null or "END_TIME" is not null or "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" 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 "PERFSTAT"."STATS$SEG_STAT_OBJ" 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("DATAOBJ#")),sum(sys_op_opnsize("OBJ#")),sum(sys_op_opnsize("TS#")),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "OWNER"),sum(sys_op_opnsize("OWNER")),substrb(dump(min("OWNER"),16,0,32),1,120),substrb(dump(max("OWNER"),16,0,32),1,120),count(distinct "OBJECT_NAME"),sum(sys_op_opnsize("OBJECT_NAME")),substrb(dump(min("OBJECT_NAME"),16,0,32),1,120),substrb(dump(max("OBJECT_NAME"),16,0,32),1,120),count("SUBOBJECT_NAME"),count(distinct "SUBOBJECT_NAME"),sum(sys_op_opnsize("SUBOBJECT_NAME")),substrb(dump(min("SUBOBJECT_NAME"),16,0,32),1,120),substrb(dump(max("SUBOBJECT_NAME"),16,0,32),1,120),count("OBJECT_TYPE"),count(distinct "OBJE
CT_TYPE"),sum(sys_op_opnsize("OBJECT_TYPE")),substrb(dump(min("OBJECT_TYPE"),16,0,32),1,120),substrb(dump(max("OBJECT_TYPE"),16,0,32),1,120),count(distinct "TABLESPACE_NAME"),sum(sys_op_opnsize("TABLESPACE_NAME")),substrb(dump(min("TABLESPACE_NAME"),16,0,32),1,120),substrb(dump(max("TABLESPACE_NAME"),16,0,32),1,120) from "PERFSTAT"."STATS$SEG_STAT_OBJ" t

select /*+ no_parallel_index(t,"STATS$SEG_STAT_OBJ_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SEG_STAT_OBJ_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12085,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SEG_STAT_OBJ" t where "DATAOBJ#" is not null or "OBJ#" is not null or "TS#" is not null or "DBID" 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 "PERFSTAT"."STATS$PGASTAT" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "NAME"),sum(sys_op_opnsize("NAME")),substrb(dump(min(substrb("NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("NAME",1,32)),16,0,32),1,120),count("VALUE"),count(distinct "VALUE"),sum(sys_op_opnsize("VALUE")),substrb(dump(min("VALUE"),16,0,32),1,120),substrb(dump(max("VALUE"),16,0
,32),1,120) from "PERFSTAT"."STATS$PGASTAT" t

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select /*+ no_parallel_index(t,"STATS$SQL_PGASTAT_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SQL_PGASTAT_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12088,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$PGASTAT" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "NAME" 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 "PERFSTAT"."STATS$PARAMETER" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "NAME"),sum(sys_op_opnsize("NAME")),substrb(dump(min(substrb("NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("NAME",1,32)),16,0,32),1,120),count("VALUE"),count(distinct "VALUE"),sum(sys_op_opnsize("VALUE")),substrb(dump(min(substrb("VALUE",1,32)),16,0,32),1,120),substrb(dump(max
(substrb("VALUE",1,32)),16,0,32),1,120),count("ISDEFAULT"),count(distinct "ISDEFAULT"),sum(sys_op_opnsize("ISDEFAULT")),substrb(dump(min("ISDEFAULT"),16,0,32),1,120),substrb(dump(max("ISDEFAULT"),16,0,32),1,120),count("ISMODIFIED"),count(distinct "ISMODIFIED"),sum(sys_op_opnsize("ISMODIFIED")),substrb(dump(min("ISMODIFIED"),16,0,32),1,120),substrb(dump(max("ISMODIFIED"),16,0,32),1,120) from "PERFSTAT"."STATS$PARAMETER" t

select /*+ no_parallel_index(t,"STATS$PARAMETER_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$PARAMETER_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12091,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$PARAMETER" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "NAME" 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 "PERFSTAT"."STATS$INSTANCE_RECOVERY" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count("RECOVERY_ESTIMATED_IOS"),count(distinct "RECOVERY_ESTIMATED_IOS"),sum(sys_op_opnsize("RECOVERY_ESTIMATED_IOS")),substrb(dump(min("RECOVERY_ESTIMATED_IOS"),16,0,32),1,120),substrb(dump(max("RECOVERY_ESTIMATED_IOS"),16,0,32),1,120),count("ACTUAL_REDO_BLKS"),count(distinct "ACTUAL_REDO_BLKS"),sum
(sys_op_opnsize("ACTUAL_REDO_BLKS")),substrb(dump(min("ACTUAL_REDO_BLKS"),16,0,32),1,120),substrb(dump(max("ACTUAL_REDO_BLKS"),16,0,32),1,120),count("TARGET_REDO_BLKS"),count(distinct "TARGET_REDO_BLKS"),sum(sys_op_opnsize("TARGET_REDO_BLKS")),substrb(dump(min("TARGET_REDO_BLKS"),16,0,32),1,120),substrb(dump(max("TARGET_REDO_BLKS"),16,0,32),1,120),count("LOG_FILE_SIZE_REDO_BLKS"),count(distinct "LOG_FILE_SIZE_REDO_BLKS"),sum(sys_op_opnsize("LOG_FILE_SIZE_REDO_BLKS")),substrb(dump(min("LOG_FILE_SIZE_REDO_BLKS"),16,0,32),1,120),substrb(dump(max("LOG_FILE_SIZE_REDO_BLKS"),16,0,32),1,120),count("LOG_CHKPT_TIMEOUT_REDO_BLKS"),count(distinct "LOG_CHKPT_TIMEOUT_REDO_BLKS"),sum(sys_op_opnsize("LOG_CHKPT_TIMEOUT_REDO_BLKS")),substrb(dump(min("LOG_CHKPT_TIMEOUT_REDO_BLKS"),16,0,32),1,120),substrb(dump(max("LOG_CHKPT_TIMEOUT_REDO_BLKS"),16,0,32),1,120),count("LOG_CHKPT_INTERVAL_REDO_BLKS"),count(di
stinct "LOG_CHKPT_INTERVAL_REDO_BLKS"),sum(sys_op_opnsize("LOG_CHKPT_INTERVAL_REDO_BLKS")),substrb(dump(min("LOG_CHKPT_INTERVAL_REDO_BLKS"),16,0,32),1,120),substrb(dump(max("LOG_CHKPT_INTERVAL_REDO_BLKS"),16,0,32),1,120),count("FAST_START_IO_TARGET_REDO_BLKS"),count(distinct "FAST_START_IO_TARGET_REDO_BLKS"),sum(sys_op_opnsize("FAST_START_IO_TARGET_REDO_BLKS")),substrb(dump(min("FAST_START_IO_TARGET_REDO_BLKS"),16,0,32),1,120),substrb(dump(max("FAST_START_IO_TARGET_REDO_BLKS"),16,0,32),1,120),count("TARGET_MTTR"),count(distinct "TARGET_MTTR"),sum(sys_op_opnsize("TARGET_MTTR")),substrb(dump(min("TARGET_MTTR"),16,0,32),1,120),substrb(dump(max("TARGET_MTTR"),16,0,32),1,120),count("ESTIMATED_MTTR"),count(distinct "ESTIMATED_MTTR"),sum(sys_op_opnsize("ESTIMATED_MTTR")),substrb(dump(min("ESTIMATED_MTTR"),16,0,32),1,120),substrb(dump(max("ESTIMATED_MTTR"),16,0,32),1,120),count("CKPT_BLOCK_WRITE

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
S"),count(distinct "CKPT_BLOCK_WRITES"),sum(sys_op_opnsize("CKPT_BLOCK_WRITES")),substrb(dump(min("CKPT_BLOCK_WRITES"),16,0,32),1,120),substrb(dump(max("CKPT_BLOCK_WRITES"),16,0,32),1,120) from "PERFSTAT"."STATS$INSTANCE_RECOVERY" t

select /*+ no_parallel_index(t,"STATS$INSTANCE_RECOVERY_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$INSTANCE_RECOVERY_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12094,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$INSTANCE_RECOVERY" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" 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 "PERFSTAT"."STATS$SHARED_POOL_ADVICE" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "SHARED_POOL_SIZE_FOR_ESTIMATE"),sum(sys_op_opnsize("SHARED_POOL_SIZE_FOR_ESTIMATE")),substrb(dump(min("SHARED_POOL_SIZE_FOR_ESTIMATE"),16,0,32),1,120),substrb(dump(max("SHARED_POOL_SIZE_FOR_ESTIMATE"),16,0,32),1,120),count("SHARED_POOL_SIZE_FACTOR"),count(distinct "SHARED_POOL_SIZE_FA
CTOR"),sum(sys_op_opnsize("SHARED_POOL_SIZE_FACTOR")),substrb(dump(min("SHARED_POOL_SIZE_FACTOR"),16,0,32),1,120),substrb(dump(max("SHARED_POOL_SIZE_FACTOR"),16,0,32),1,120),count("ESTD_LC_SIZE"),count(distinct "ESTD_LC_SIZE"),sum(sys_op_opnsize("ESTD_LC_SIZE")),substrb(dump(min("ESTD_LC_SIZE"),16,0,32),1,120),substrb(dump(max("ESTD_LC_SIZE"),16,0,32),1,120),count("ESTD_LC_MEMORY_OBJECTS"),count(distinct "ESTD_LC_MEMORY_OBJECTS"),sum(sys_op_opnsize("ESTD_LC_MEMORY_OBJECTS")),substrb(dump(min("ESTD_LC_MEMORY_OBJECTS"),16,0,32),1,120),substrb(dump(max("ESTD_LC_MEMORY_OBJECTS"),16,0,32),1,120),count("ESTD_LC_TIME_SAVED"),count(distinct "ESTD_LC_TIME_SAVED"),sum(sys_op_opnsize("ESTD_LC_TIME_SAVED")),substrb(dump(min("ESTD_LC_TIME_SAVED"),16,0,32),1,120),substrb(dump(max("ESTD_LC_TIME_SAVED"),16,0,32),1,120),count("ESTD_LC_TIME_SAVED_FACTOR"),count(distinct "ESTD_LC_TIME_SAVED_FACTOR"),sum(sy
s_op_opnsize("ESTD_LC_TIME_SAVED_FACTOR")),substrb(dump(min("ESTD_LC_TIME_SAVED_FACTOR"),16,0,32),1,120),substrb(dump(max("ESTD_LC_TIME_SAVED_FACTOR"),16,0,32),1,120),count("ESTD_LC_LOAD_TIME"),count(distinct "ESTD_LC_LOAD_TIME"),sum(sys_op_opnsize("ESTD_LC_LOAD_TIME")),substrb(dump(min("ESTD_LC_LOAD_TIME"),16,0,32),1,120),substrb(dump(max("ESTD_LC_LOAD_TIME"),16,0,32),1,120),count("ESTD_LC_LOAD_TIME_FACTOR"),count(distinct "ESTD_LC_LOAD_TIME_FACTOR"),sum(sys_op_opnsize("ESTD_LC_LOAD_TIME_FACTOR")),substrb(dump(min("ESTD_LC_LOAD_TIME_FACTOR"),16,0,32),1,120),substrb(dump(max("ESTD_LC_LOAD_TIME_FACTOR"),16,0,32),1,120),count("ESTD_LC_MEMORY_OBJECT_HITS"),count(distinct "ESTD_LC_MEMORY_OBJECT_HITS"),sum(sys_op_opnsize("ESTD_LC_MEMORY_OBJECT_HITS")),substrb(dump(min("ESTD_LC_MEMORY_OBJECT_HITS"),16,0,32),1,120),substrb(dump(max("ESTD_LC_MEMORY_OBJECT_HITS"),16,0,32),1,120) from "PERFSTAT"."
STATS$SHARED_POOL_ADVICE" t

select /*+ no_parallel_index(t,"STATS$SHARED_POOL_ADVICE_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SHARED_POOL_ADVICE_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12100,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SHARED_POOL_ADVICE" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "SHARED_POOL_SIZE_FOR_ESTIMATE" 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 "PERFSTAT"."STATS$SQL_WORKAREA_HISTOGRAM" 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(distinct "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "LOW_OPTIMAL_SIZE"),sum(sys_op_opnsize("LOW_OPTIMAL_SIZE")),substrb(dump(min("LOW_OPTIMAL_SIZE"),16,0,32),1,120),substrb(dump(max("LOW_OPTIMAL_SIZE"),16,0,32),1,120),count(distinct "HIGH_OPTIMAL_SIZE"),sum(sys_op_opnsize("HIGH_OPTIMAL_SIZE")),substrb(dump(min("HIGH_OPTIMAL_SIZE"),16,0,
32),1,120),substrb(dump(max("HIGH_OPTIMAL_SIZE"),16,0,32),1,120),count("OPTIMAL_EXECUTIONS"),count(distinct "OPTIMAL_EXECUTIONS"),sum(sys_op_opnsize("OPTIMAL_EXECUTIONS")),substrb(dump(min("OPTIMAL_EXECUTIONS"),16,0,32),1,120),substrb(dump(max("OPTIMAL_EXECUTIONS"),16,0,32),1,120),count("ONEPASS_EXECUTIONS"),count(distinct "ONEPASS_EXECUTIONS"),sum(sys_op_opnsize("ONEPASS_EXECUTIONS")),substrb(dump(min("ONEPASS_EXECUTIONS"),16,0,32),1,120),substrb(dump(max("ONEPASS_EXECUTIONS"),16,0,32),1,120),count("MULTIPASSES_EXECUTIONS"),count(distinct "MULTIPASSES_EXECUTIONS"),sum(sys_op_opnsize("MULTIPASSES_EXECUTIONS")),substrb(dump(min("MULTIPASSES_EXECUTIONS"),16,0,32),1,120),substrb(dump(max("MULTIPASSES_EXECUTIONS"),16,0,32),1,120),count("TOTAL_EXECUTIONS"),count(distinct "TOTAL_EXECUTIONS"),sum(sys_op_opnsize("TOTAL_EXECUTIONS")),substrb(dump(min("TOTAL_EXECUTIONS"),16,0,32),1,120),substrb(du
mp(max("TOTAL_EXECUTIONS"),16,0,32),1,120) from "PERFSTAT"."STATS$SQL_WORKAREA_HISTOGRAM" t

select /*+ no_parallel_index(t,"STATS$SQL_WORKAREA_HIST_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SQL_WORKAREA_HIST_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12103,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SQL_WORKAREA_HISTOGRAM" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "LOW_OPTIMAL_SIZE" is not null or "HIGH_OPTIMAL_SIZE" 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 "PERFSTAT"."STATS$PGA_TARGET_ADVICE" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "PGA_TARGET_FOR_ESTIMATE"),sum(sys_op_opnsize("PGA_TARGET_FOR_ESTIMATE")),substrb(dump(min("PGA_TARGET_FOR_ESTIMATE"),16,0,32),1,120),substrb(dump(max("PGA_TARGET_FOR_ESTIMATE"),16,0,32),1,120),count("PGA_TARGET_FACTOR"),count(distinct "PGA_TARGET_FACTOR"),sum(sys_op_opnsize("PGA_TARGE
T_FACTOR")),substrb(dump(min("PGA_TARGET_FACTOR"),16,0,32),1,120),substrb(dump(max("PGA_TARGET_FACTOR"),16,0,32),1,120),count("ADVICE_STATUS"),count(distinct "ADVICE_STATUS"),sum(sys_op_opnsize("ADVICE_STATUS")),substrb(dump(min("ADVICE_STATUS"),16,0,32),1,120),substrb(dump(max("ADVICE_STATUS"),16,0,32),1,120),count("BYTES_PROCESSED"),count(distinct "BYTES_PROCESSED"),sum(sys_op_opnsize("BYTES_PROCESSED")),substrb(dump(min("BYTES_PROCESSED"),16,0,32),1,120),substrb(dump(max("BYTES_PROCESSED"),16,0,32),1,120),count("ESTD_EXTRA_BYTES_RW"),count(distinct "ESTD_EXTRA_BYTES_RW"),sum(sys_op_opnsize("ESTD_EXTRA_BYTES_RW")),substrb(dump(min("ESTD_EXTRA_BYTES_RW"),16,0,32),1,120),substrb(dump(max("ESTD_EXTRA_BYTES_RW"),16,0,32),1,120),count("ESTD_PGA_CACHE_HIT_PERCENTAGE"),count(distinct "ESTD_PGA_CACHE_HIT_PERCENTAGE"),sum(sys_op_opnsize("ESTD_PGA_CACHE_HIT_PERCENTAGE")),substrb(dump(min("ESTD_P
GA_CACHE_HIT_PERCENTAGE"),16,0,32),1,120),substrb(dump(max("ESTD_PGA_CACHE_HIT_PERCENTAGE"),16,0,32),1,120),count("ESTD_OVERALLOC_COUNT"),count(distinct "ESTD_OVERALLOC_COUNT"),sum(sys_op_opnsize("ESTD_OVERALLOC_COUNT")),substrb(dump(min("ESTD_OVERALLOC_COUNT"),16,0,32),1,120),substrb(dump(max("ESTD_OVERALLOC_COUNT"),16,0,32),1,120) from "PERFSTAT"."STATS$PGA_TARGET_ADVICE" t

select /*+ no_parallel_index(t,"STATS$PGA_TARGET_ADVICE_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$PGA_TARGET_ADVICE_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12106,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$PGA_TARGET_ADVICE" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "PGA_TARGET_FOR_ESTIMATE" is not null

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(*)  from "PERFSTAT"."STATS$JAVA_POOL_ADVICE" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "JAVA_POOL_SIZE_FOR_ESTIMATE"),sum(sys_op_opnsize("JAVA_POOL_SIZE_FOR_ESTIMATE")),substrb(dump(min("JAVA_POOL_SIZE_FOR_ESTIMATE"),16,0,32),1,120),substrb(dump(max("JAVA_POOL_SIZE_FOR_ESTIMATE"),16,0,32),1,120),count("JAVA_POOL_SIZE_FACTOR"),count(distinct "JAVA_POOL_SIZE_FACTOR"),sum(s
ys_op_opnsize("JAVA_POOL_SIZE_FACTOR")),substrb(dump(min("JAVA_POOL_SIZE_FACTOR"),16,0,32),1,120),substrb(dump(max("JAVA_POOL_SIZE_FACTOR"),16,0,32),1,120),count("ESTD_LC_SIZE"),count(distinct "ESTD_LC_SIZE"),sum(sys_op_opnsize("ESTD_LC_SIZE")),substrb(dump(min("ESTD_LC_SIZE"),16,0,32),1,120),substrb(dump(max("ESTD_LC_SIZE"),16,0,32),1,120),count("ESTD_LC_MEMORY_OBJECTS"),count(distinct "ESTD_LC_MEMORY_OBJECTS"),sum(sys_op_opnsize("ESTD_LC_MEMORY_OBJECTS")),substrb(dump(min("ESTD_LC_MEMORY_OBJECTS"),16,0,32),1,120),substrb(dump(max("ESTD_LC_MEMORY_OBJECTS"),16,0,32),1,120),count("ESTD_LC_TIME_SAVED"),count(distinct "ESTD_LC_TIME_SAVED"),sum(sys_op_opnsize("ESTD_LC_TIME_SAVED")),substrb(dump(min("ESTD_LC_TIME_SAVED"),16,0,32),1,120),substrb(dump(max("ESTD_LC_TIME_SAVED"),16,0,32),1,120),count("ESTD_LC_TIME_SAVED_FACTOR"),count(distinct "ESTD_LC_TIME_SAVED_FACTOR"),sum(sys_op_opnsize("ESTD
_LC_TIME_SAVED_FACTOR")),substrb(dump(min("ESTD_LC_TIME_SAVED_FACTOR"),16,0,32),1,120),substrb(dump(max("ESTD_LC_TIME_SAVED_FACTOR"),16,0,32),1,120),count("ESTD_LC_LOAD_TIME"),count(distinct "ESTD_LC_LOAD_TIME"),sum(sys_op_opnsize("ESTD_LC_LOAD_TIME")),substrb(dump(min("ESTD_LC_LOAD_TIME"),16,0,32),1,120),substrb(dump(max("ESTD_LC_LOAD_TIME"),16,0,32),1,120),count("ESTD_LC_LOAD_TIME_FACTOR"),count(distinct "ESTD_LC_LOAD_TIME_FACTOR"),sum(sys_op_opnsize("ESTD_LC_LOAD_TIME_FACTOR")),substrb(dump(min("ESTD_LC_LOAD_TIME_FACTOR"),16,0,32),1,120),substrb(dump(max("ESTD_LC_LOAD_TIME_FACTOR"),16,0,32),1,120),count("ESTD_LC_MEMORY_OBJECT_HITS"),count(distinct "ESTD_LC_MEMORY_OBJECT_HITS"),sum(sys_op_opnsize("ESTD_LC_MEMORY_OBJECT_HITS")),substrb(dump(min("ESTD_LC_MEMORY_OBJECT_HITS"),16,0,32),1,120),substrb(dump(max("ESTD_LC_MEMORY_OBJECT_HITS"),16,0,32),1,120) from "PERFSTAT"."STATS$JAVA_POOL_AD
VICE" t

select /*+ no_parallel_index(t,"STATS$JAVA_POOL_ADVICE_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$JAVA_POOL_ADVICE_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12109,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$JAVA_POOL_ADVICE" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "JAVA_POOL_SIZE_FOR_ESTIMATE" 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 "PERFSTAT"."STATS$THREAD" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "THREAD#"),sum(sys_op_opnsize("THREAD#")),substrb(dump(min("THREAD#"),16,0,32),1,120),substrb(dump(max("THREAD#"),16,0,32),1,120),count("THREAD_INSTANCE_NUMBER"),count(distinct "THREAD_INSTANCE_NUMBER"),sum(sys_op_opnsize("THREAD_INSTANCE_NUMBER")),substrb(dump(min("THREAD_INSTANCE_NUM
BER"),16,0,32),1,120),substrb(dump(max("THREAD_INSTANCE_NUMBER"),16,0,32),1,120),count("STATUS"),count(distinct "STATUS"),sum(sys_op_opnsize("STATUS")),substrb(dump(min("STATUS"),16,0,32),1,120),substrb(dump(max("STATUS"),16,0,32),1,120),count("OPEN_TIME"),count(distinct "OPEN_TIME"),substrb(dump(min("OPEN_TIME"),16,0,32),1,120),substrb(dump(max("OPEN_TIME"),16,0,32),1,120),count("CURRENT_GROUP#"),count(distinct "CURRENT_GROUP#"),sum(sys_op_opnsize("CURRENT_GROUP#")),substrb(dump(min("CURRENT_GROUP#"),16,0,32),1,120),substrb(dump(max("CURRENT_GROUP#"),16,0,32),1,120),count("SEQUENCE#"),count(distinct "SEQUENCE#"),sum(sys_op_opnsize("SEQUENCE#")),substrb(dump(min("SEQUENCE#"),16,0,32),1,120),substrb(dump(max("SEQUENCE#"),16,0,32),1,120) from "PERFSTAT"."STATS$THREAD" t


SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select /*+ no_parallel_index(t,"STATS$THREAD_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$THREAD_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12112,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$THREAD" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "THREAD#" 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 "PERFSTAT"."STATS$FILE_HISTOGRAM" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "FILE#"),sum(sys_op_opnsize("FILE#")),substrb(dump(min("FILE#"),16,0,32),1,120),substrb(dump(max("FILE#"),16,0,32),1,120),count(distinct "SINGLEBLKRDTIM_MILLI"),sum(sys_op_opnsize("SINGLEBLKRDTIM_MILLI")),substrb(dump(min("SINGLEBLKRDTIM_MILLI"),16,0,32),1,120),substrb(dump(max("SINGLE
BLKRDTIM_MILLI"),16,0,32),1,120),count("SINGLEBLKRDS"),count(distinct "SINGLEBLKRDS"),sum(sys_op_opnsize("SINGLEBLKRDS")),substrb(dump(min("SINGLEBLKRDS"),16,0,32),1,120),substrb(dump(max("SINGLEBLKRDS"),16,0,32),1,120) from "PERFSTAT"."STATS$FILE_HISTOGRAM" t

select /*+ no_parallel_index(t,"STATS$FILE_HISTOGRAM_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$FILE_HISTOGRAM_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12115,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$FILE_HISTOGRAM" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "FILE#" is not null or "SINGLEBLKRDTIM_MILLI" 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 "PERFSTAT"."STATS$TEMP_HISTOGRAM" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "FILE#"),sum(sys_op_opnsize("FILE#")),substrb(dump(min("FILE#"),16,0,32),1,120),substrb(dump(max("FILE#"),16,0,32),1,120),count(distinct "SINGLEBLKRDTIM_MILLI"),sum(sys_op_opnsize("SINGLEBLKRDTIM_MILLI")),substrb(dump(min("SINGLEBLKRDTIM_MILLI"),16,0,32),1,120),substrb(dump(max("SINGLE
BLKRDTIM_MILLI"),16,0,32),1,120),count("SINGLEBLKRDS"),count(distinct "SINGLEBLKRDS"),sum(sys_op_opnsize("SINGLEBLKRDS")),substrb(dump(min("SINGLEBLKRDS"),16,0,32),1,120),substrb(dump(max("SINGLEBLKRDS"),16,0,32),1,120) from "PERFSTAT"."STATS$TEMP_HISTOGRAM" t

select /*+ no_parallel_index(t,"STATS$TEMP_HISTOGRAM_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$TEMP_HISTOGRAM_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12118,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$TEMP_HISTOGRAM" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "FILE#" is not null or "SINGLEBLKRDTIM_MILLI" is not null

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(*)  from "PERFSTAT"."STATS$EVENT_HISTOGRAM" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "EVENT_ID"),sum(sys_op_opnsize("EVENT_ID")),substrb(dump(min("EVENT_ID"),16,0,32),1,120),substrb(dump(max("EVENT_ID"),16,0,32),1,120),count(distinct "WAIT_TIME_MILLI"),sum(sys_op_opnsize("WAIT_TIME_MILLI")),substrb(dump(min("WAIT_TIME_MILLI"),16,0,32),1,120),substrb(dump(max("WAIT_TIME
_MILLI"),16,0,32),1,120),count("WAIT_COUNT"),count(distinct "WAIT_COUNT"),sum(sys_op_opnsize("WAIT_COUNT")),substrb(dump(min("WAIT_COUNT"),16,0,32),1,120),substrb(dump(max("WAIT_COUNT"),16,0,32),1,120) from "PERFSTAT"."STATS$EVENT_HISTOGRAM" t

select /*+ no_parallel_index(t,"STATS$EVENT_HISTOGRAM_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$EVENT_HISTOGRAM_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12121,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$EVENT_HISTOGRAM" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "EVENT_ID" is not null or "WAIT_TIME_MILLI" 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 "PERFSTAT"."STATS$TIME_MODEL_STATNAME" 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("STAT_ID")),substrb(dump(min("STAT_ID"),16,0,32),1,120),substrb(dump(max("STAT_ID"),16,0,32),1,120),count(distinct "STAT_NAME"),sum(sys_op_opnsize("STAT_NAME")),substrb(dump(min(substrb("STAT_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("STAT_NAME",1,32)),16,0,32),1,120) from "PERFSTAT"."STATS$TIME_MODEL_STATNAME" t
select /*+ no_parallel_index(t,"STATS$TIME_MODEL_STATNAME_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$TIME_MODEL_STATNAME_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12124,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$TIME_MODEL_STATNAME" t where "STAT_ID" 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 "PERFSTAT"."STATS$SYS_TIME_MODEL" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "STAT_ID"),sum(sys_op_opnsize("STAT_ID")),substrb(dump(min("STAT_ID"),16,0,32),1,120),substrb(dump(max("STAT_ID"),16,0,32),1,120),count(distinct "VALUE"),sum(sys_op_opnsize("VALUE")),substrb(dump(min("VALUE"),16,0,32),1,120),substrb(dump(max("VALUE"),16,0,32),1,120) from "PERFSTAT"."ST
ATS$SYS_TIME_MODEL" t

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select /*+ no_parallel_index(t,"STATS$SYS_TIME_MODEL_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SYS_TIME_MODEL_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12127,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SYS_TIME_MODEL" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "STAT_ID" 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 "PERFSTAT"."STATS$RULE_SET" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "OWNER"),sum(sys_op_opnsize("OWNER")),substrb(dump(min("OWNER"),16,0,32),1,120),substrb(dump(max("OWNER"),16,0,32),1,120),count(distinct "NAME"),sum(sys_op_opnsize("NAME")),substrb(dump(min("NAME"),16,0,32),1,120),substrb(dump(max("NAME"),16,0,32),1,120),count(distinct "STARTUP_TIME"),
substrb(dump(min("STARTUP_TIME"),16,0,32),1,120),substrb(dump(max("STARTUP_TIME"),16,0,32),1,120),count("CPU_TIME"),count(distinct "CPU_TIME"),sum(sys_op_opnsize("CPU_TIME")),substrb(dump(min("CPU_TIME"),16,0,32),1,120),substrb(dump(max("CPU_TIME"),16,0,32),1,120),count("ELAPSED_TIME"),count(distinct "ELAPSED_TIME"),sum(sys_op_opnsize("ELAPSED_TIME")),substrb(dump(min("ELAPSED_TIME"),16,0,32),1,120),substrb(dump(max("ELAPSED_TIME"),16,0,32),1,120),count("EVALUATIONS"),count(distinct "EVALUATIONS"),sum(sys_op_opnsize("EVALUATIONS")),substrb(dump(min("EVALUATIONS"),16,0,32),1,120),substrb(dump(max("EVALUATIONS"),16,0,32),1,120),count("SQL_FREE_EVALUATIONS"),count(distinct "SQL_FREE_EVALUATIONS"),sum(sys_op_opnsize("SQL_FREE_EVALUATIONS")),substrb(dump(min("SQL_FREE_EVALUATIONS"),16,0,32),1,120),substrb(dump(max("SQL_FREE_EVALUATIONS"),16,0,32),1,120),count("SQL_EXECUTIONS"),count(distinct
"SQL_EXECUTIONS"),sum(sys_op_opnsize("SQL_EXECUTIONS")),substrb(dump(min("SQL_EXECUTIONS"),16,0,32),1,120),substrb(dump(max("SQL_EXECUTIONS"),16,0,32),1,120),count("RELOADS"),count(distinct "RELOADS"),sum(sys_op_opnsize("RELOADS")),substrb(dump(min("RELOADS"),16,0,32),1,120),substrb(dump(max("RELOADS"),16,0,32),1,120) from "PERFSTAT"."STATS$RULE_SET" t

select /*+ no_parallel_index(t,"STATS$RULE_SET_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$RULE_SET_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12151,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$RULE_SET" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "OWNER" is not null or "NAME" 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 "PERFSTAT"."STATS$OSSTATNAME" 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("OSSTAT_ID")),substrb(dump(min("OSSTAT_ID"),16,0,32),1,120),substrb(dump(max("OSSTAT_ID"),16,0,32),1,120),count(distinct "STAT_NAME"),sum(sys_op_opnsize("STAT_NAME")),substrb(dump(min(substrb("STAT_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("STAT_NAME",1,32)),16,0,32),1,120) from "PERFSTAT"."STATS$OSSTATNAME" t
select /*+ no_parallel_index(t,"STATS$OSSSTATNAME_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$OSSSTATNAME_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12154,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$OSSTATNAME" t where "OSSTAT_ID" is not null

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(*)  from "PERFSTAT"."STATS$OSSTAT" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "OSSTAT_ID"),sum(sys_op_opnsize("OSSTAT_ID")),substrb(dump(min("OSSTAT_ID"),16,0,32),1,120),substrb(dump(max("OSSTAT_ID"),16,0,32),1,120),count("VALUE"),count(distinct "VALUE"),sum(sys_op_opnsize("VALUE")),substrb(dump(min("VALUE"),16,0,32),1,120),substrb(dump(max("VALUE"),16,0,32),1,1
20) from "PERFSTAT"."STATS$OSSTAT" t

select /*+ no_parallel_index(t,"STATS$OSSTAT_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$OSSTAT_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12157,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$OSSTAT" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "OSSTAT_ID" 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 "PERFSTAT"."STATS$PROCESS_ROLLUP" 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_ID")),sum(sys_op_opnsize("DBID")),sum(sys_op_opnsize("INSTANCE_NUMBER")),sum(sys_op_opnsize("PID")),sum(sys_op_opnsize("SERIAL#")),count("SPID"),count(distinct "SPID"),sum(sys_op_opnsize("SPID")),substrb(dump(min("SPID"),16,0,32),1,120),substrb(dump(max("SPID"),16,0,32),1,120),count("PROGRAM"),count(distinct "PROGRAM"),sum(sys_op_opnsize("PROGRAM")),substrb(dump(min(substrb("PROGRAM",1,32)),16,0,32),1,120),substrb(dump(max(substrb("PROGRAM",1,32)),16,0,32),1,120),count("BACKGROUND"),count(distinct "BACKGROUND"),sum(sys_op_opnsize("BACKGROUND")),substrb(dump(min("BACKGROUND"),16,0,32),1,120),substrb(dump(max("BACKGROUND"),16,0,32),1,120),count("PGA_USED_MEM"),count(distinct "PGA_USED_MEM"),sum(sys_op_opnsize("PGA_USED_MEM"
)),substrb(dump(min("PGA_USED_MEM"),16,0,32),1,120),substrb(dump(max("PGA_USED_MEM"),16,0,32),1,120),count("PGA_ALLOC_MEM"),count(distinct "PGA_ALLOC_MEM"),sum(sys_op_opnsize("PGA_ALLOC_MEM")),substrb(dump(min("PGA_ALLOC_MEM"),16,0,32),1,120),substrb(dump(max("PGA_ALLOC_MEM"),16,0,32),1,120),count("PGA_FREEABLE_MEM"),count(distinct "PGA_FREEABLE_MEM"),sum(sys_op_opnsize("PGA_FREEABLE_MEM")),substrb(dump(min("PGA_FREEABLE_MEM"),16,0,32),1,120),substrb(dump(max("PGA_FREEABLE_MEM"),16,0,32),1,120),count("MAX_PGA_ALLOC_MEM"),count(distinct "MAX_PGA_ALLOC_MEM"),sum(sys_op_opnsize("MAX_PGA_ALLOC_MEM")),substrb(dump(min("MAX_PGA_ALLOC_MEM"),16,0,32),1,120),substrb(dump(max("MAX_PGA_ALLOC_MEM"),16,0,32),1,120),count("MAX_PGA_MAX_MEM"),count(distinct "MAX_PGA_MAX_MEM"),sum(sys_op_opnsize("MAX_PGA_MAX_MEM")),substrb(dump(min("MAX_PGA_MAX_MEM"),16,0,32),1,120),substrb(dump(max("MAX_PGA_MAX_MEM"),16
,0,32),1,120),count("AVG_PGA_ALLOC_MEM"),count(distinct "AVG_PGA_ALLOC_MEM"),sum(sys_op_opnsize("AVG_PGA_ALLOC_MEM")),substrb(dump(min("AVG_PGA_ALLOC_MEM"),16,0,32),1,120),substrb(dump(max("AVG_PGA_ALLOC_MEM"),16,0,32),1,120),count("STDDEV_PGA_ALLOC_MEM"),count(distinct "STDDEV_PGA_ALLOC_MEM"),sum(sys_op_opnsize("STDDEV_PGA_ALLOC_MEM")),substrb(dump(min("STDDEV_PGA_ALLOC_MEM"),16,0,32),1,120),substrb(dump(max("STDDEV_PGA_ALLOC_MEM"),16,0,32),1,120),count("NUM_PROCESSES"),count(distinct "NUM_PROCESSES"),sum(sys_op_opnsize("NUM_PROCESSES")),substrb(dump(min("NUM_PROCESSES"),16,0,32),1,120),substrb(dump(max("NUM_PROCESSES"),16,0,32),1,120) from "PERFSTAT"."STATS$PROCESS_ROLLUP" t

select /*+ no_parallel_index(t,"STATS$$PROCESS_ROLLUP_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$$PROCESS_ROLLUP_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12160,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$PROCESS_ROLLUP" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "PID" is not null or "SERIAL#" is not null

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(*)  from "PERFSTAT"."STATS$PROCESS_MEMORY_ROLLUP" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "PID"),sum(sys_op_opnsize("PID")),substrb(dump(min("PID"),16,0,32),1,120),substrb(dump(max("PID"),16,0,32),1,120),count(distinct "SERIAL#"),sum(sys_op_opnsize("SERIAL#")),substrb(dump(min("SERIAL#"),16,0,32),1,120),substrb(dump(max("SERIAL#"),16,0,32),1,120),count(distinct "CATEGORY"),
sum(sys_op_opnsize("CATEGORY")),substrb(dump(min("CATEGORY"),16,0,32),1,120),substrb(dump(max("CATEGORY"),16,0,32),1,120),count("ALLOCATED"),count(distinct "ALLOCATED"),sum(sys_op_opnsize("ALLOCATED")),substrb(dump(min("ALLOCATED"),16,0,32),1,120),substrb(dump(max("ALLOCATED"),16,0,32),1,120),count("USED"),count(distinct "USED"),sum(sys_op_opnsize("USED")),substrb(dump(min("USED"),16,0,32),1,120),substrb(dump(max("USED"),16,0,32),1,120),count("MAX_ALLOCATED"),count(distinct "MAX_ALLOCATED"),sum(sys_op_opnsize("MAX_ALLOCATED")),substrb(dump(min("MAX_ALLOCATED"),16,0,32),1,120),substrb(dump(max("MAX_ALLOCATED"),16,0,32),1,120),count("MAX_MAX_ALLOCATED"),count(distinct "MAX_MAX_ALLOCATED"),sum(sys_op_opnsize("MAX_MAX_ALLOCATED")),substrb(dump(min("MAX_MAX_ALLOCATED"),16,0,32),1,120),substrb(dump(max("MAX_MAX_ALLOCATED"),16,0,32),1,120),count("AVG_ALLOCATED"),count(distinct "AVG_ALLOCATED"),
sum(sys_op_opnsize("AVG_ALLOCATED")),substrb(dump(min("AVG_ALLOCATED"),16,0,32),1,120),substrb(dump(max("AVG_ALLOCATED"),16,0,32),1,120),count("STDDEV_ALLOCATED"),count(distinct "STDDEV_ALLOCATED"),sum(sys_op_opnsize("STDDEV_ALLOCATED")),substrb(dump(min("STDDEV_ALLOCATED"),16,0,32),1,120),substrb(dump(max("STDDEV_ALLOCATED"),16,0,32),1,120),count("NON_ZERO_ALLOCATIONS"),count(distinct "NON_ZERO_ALLOCATIONS"),sum(sys_op_opnsize("NON_ZERO_ALLOCATIONS")),substrb(dump(min("NON_ZERO_ALLOCATIONS"),16,0,32),1,120),substrb(dump(max("NON_ZERO_ALLOCATIONS"),16,0,32),1,120) from "PERFSTAT"."STATS$PROCESS_MEMORY_ROLLUP" t

select /*+ no_parallel_index(t,"STATS$PROCESS_MEMORY_ROLLUP_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$PROCESS_MEMORY_ROLLUP_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12163,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$PROCESS_MEMORY_ROLLUP" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "PID" is not null or "SERIAL#" is not null or "CATEGORY" 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 "PERFSTAT"."STATS$SGA_TARGET_ADVICE" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "SGA_SIZE"),sum(sys_op_opnsize("SGA_SIZE")),substrb(dump(min("SGA_SIZE"),16,0,32),1,120),substrb(dump(max("SGA_SIZE"),16,0,32),1,120),count("SGA_SIZE_FACTOR"),count(distinct "SGA_SIZE_FACTOR"),sum(sys_op_opnsize("SGA_SIZE_FACTOR")),substrb(dump(min("SGA_SIZE_FACTOR"),16,0,32),1,120),su
bstrb(dump(max("SGA_SIZE_FACTOR"),16,0,32),1,120),count("ESTD_DB_TIME"),count(distinct "ESTD_DB_TIME"),sum(sys_op_opnsize("ESTD_DB_TIME")),substrb(dump(min("ESTD_DB_TIME"),16,0,32),1,120),substrb(dump(max("ESTD_DB_TIME"),16,0,32),1,120),count("ESTD_DB_TIME_FACTOR"),count(distinct "ESTD_DB_TIME_FACTOR"),sum(sys_op_opnsize("ESTD_DB_TIME_FACTOR")),substrb(dump(min("ESTD_DB_TIME_FACTOR"),16,0,32),1,120),substrb(dump(max("ESTD_DB_TIME_FACTOR"),16,0,32),1,120),count("ESTD_PHYSICAL_READS"),count(distinct "ESTD_PHYSICAL_READS"),sum(sys_op_opnsize("ESTD_PHYSICAL_READS")),substrb(dump(min("ESTD_PHYSICAL_READS"),16,0,32),1,120),substrb(dump(max("ESTD_PHYSICAL_READS"),16,0,32),1,120) from "PERFSTAT"."STATS$SGA_TARGET_ADVICE" t

select /*+ no_parallel_index(t,"STATS$SGA_TARGET_ADVICE_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SGA_TARGET_ADVICE_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12166,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SGA_TARGET_ADVICE" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "SGA_SIZE" is not null

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(*)  from "PERFSTAT"."STATS$STREAMS_POOL_ADVICE" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "STREAMS_POOL_SIZE_FOR_ESTIMATE"),sum(sys_op_opnsize("STREAMS_POOL_SIZE_FOR_ESTIMATE")),substrb(dump(min("STREAMS_POOL_SIZE_FOR_ESTIMATE"),16,0,32),1,120),substrb(dump(max("STREAMS_POOL_SIZE_FOR_ESTIMATE"),16,0,32),1,120),count("STREAMS_POOL_SIZE_FACTOR"),count(distinct "STREAMS_POOL_S
IZE_FACTOR"),sum(sys_op_opnsize("STREAMS_POOL_SIZE_FACTOR")),substrb(dump(min("STREAMS_POOL_SIZE_FACTOR"),16,0,32),1,120),substrb(dump(max("STREAMS_POOL_SIZE_FACTOR"),16,0,32),1,120),count("ESTD_SPILL_COUNT"),count(distinct "ESTD_SPILL_COUNT"),sum(sys_op_opnsize("ESTD_SPILL_COUNT")),substrb(dump(min("ESTD_SPILL_COUNT"),16,0,32),1,120),substrb(dump(max("ESTD_SPILL_COUNT"),16,0,32),1,120),count("ESTD_SPILL_TIME"),count(distinct "ESTD_SPILL_TIME"),sum(sys_op_opnsize("ESTD_SPILL_TIME")),substrb(dump(min("ESTD_SPILL_TIME"),16,0,32),1,120),substrb(dump(max("ESTD_SPILL_TIME"),16,0,32),1,120),count("ESTD_UNSPILL_COUNT"),count(distinct "ESTD_UNSPILL_COUNT"),sum(sys_op_opnsize("ESTD_UNSPILL_COUNT")),substrb(dump(min("ESTD_UNSPILL_COUNT"),16,0,32),1,120),substrb(dump(max("ESTD_UNSPILL_COUNT"),16,0,32),1,120),count("ESTD_UNSPILL_TIME"),count(distinct "ESTD_UNSPILL_TIME"),sum(sys_op_opnsize("ESTD_UNS
PILL_TIME")),substrb(dump(min("ESTD_UNSPILL_TIME"),16,0,32),1,120),substrb(dump(max("ESTD_UNSPILL_TIME"),16,0,32),1,120) from "PERFSTAT"."STATS$STREAMS_POOL_ADVICE" t

select /*+ no_parallel_index(t,"STATS$STREAMS_POOL_ADVICE_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$STREAMS_POOL_ADVICE_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12169,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$STREAMS_POOL_ADVICE" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "STREAMS_POOL_SIZE_FOR_ESTIMATE" 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 "PERFSTAT"."STATS$MUTEX_SLEEP" 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 "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),count(distinct "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120),count(distinct "INSTANCE_NUMBER"),sum(sys_op_opnsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distinct "MUTEX_TYPE"),sum(sys_op_opnsize("MUTEX_TYPE")),substrb(dump(min("MUTEX_TYPE"),16,0,32),1,120),substrb(dump(max("MUTEX_TYPE"),16,0,32),1,120),count(distinct "LOCATION"),sum(sys_op_opnsize("LOCATION")),substrb(dump(min(substrb("LOCATION",1,32)),16,0,32),1,120),substrb(dump(max(substrb("
LOCATION",1,32)),16,0,32),1,120),count("SLEEPS"),count(distinct "SLEEPS"),sum(sys_op_opnsize("SLEEPS")),substrb(dump(min("SLEEPS"),16,0,32),1,120),substrb(dump(max("SLEEPS"),16,0,32),1,120),count("WAIT_TIME"),count(distinct "WAIT_TIME"),sum(sys_op_opnsize("WAIT_TIME")),substrb(dump(min("WAIT_TIME"),16,0,32),1,120),substrb(dump(max("WAIT_TIME"),16,0,32),1,120) from "PERFSTAT"."STATS$MUTEX_SLEEP" t

select /*+ no_parallel_index(t,"STATS$MUTEX_SLEEP_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$MUTEX_SLEEP_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12172,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$MUTEX_SLEEP" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "MUTEX_TYPE" is not null or "LOCATION" is not null

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(*)  from "PERFSTAT"."STATS$SEG_STAT" 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_ID")),sum(sys_op_opnsize("DBID")),sum(sys_op_opnsize("INSTANCE_NUMBER")),sum(sys_op_opnsize("DATAOBJ#")),sum(sys_op_opnsize("OBJ#")),sum(sys_op_opnsize("TS#")),count("LOGICAL_READS"),count(distinct "LOGICAL_READS"),sum(sys_op_opnsize("LOGICAL_READS")),substrb(dump(min("LOGICAL_READS"),16,0,32),1,120),substrb(dump(max("LOGICAL_READS"),16,0,32),1,120),count("BUFFER_BUSY_WAITS"),count(distinct "BUFFER_BUSY_WAITS"),sum(sys_op_opnsize("BUFFER_BUSY_WAITS")),substrb(dump(min("BUFFER_BUSY_WAITS"),16,0,32),1,120),substrb(dump(max("BUFFER_BUSY_WAITS"),16,0,32),1,120),count("DB_BLOCK_CHANGES"),count(distinct "DB_BLOCK_CHANGES"),sum(sys_op_opnsize("DB_BLOCK_CHANGES")),substrb(dump(min("DB_BLOCK_CHANGES"),16,0,32),1,120),substrb(dump(
max("DB_BLOCK_CHANGES"),16,0,32),1,120),count("PHYSICAL_READS"),count(distinct "PHYSICAL_READS"),sum(sys_op_opnsize("PHYSICAL_READS")),substrb(dump(min("PHYSICAL_READS"),16,0,32),1,120),substrb(dump(max("PHYSICAL_READS"),16,0,32),1,120),count("PHYSICAL_WRITES"),count(distinct "PHYSICAL_WRITES"),sum(sys_op_opnsize("PHYSICAL_WRITES")),substrb(dump(min("PHYSICAL_WRITES"),16,0,32),1,120),substrb(dump(max("PHYSICAL_WRITES"),16,0,32),1,120),count("DIRECT_PHYSICAL_READS"),count(distinct "DIRECT_PHYSICAL_READS"),sum(sys_op_opnsize("DIRECT_PHYSICAL_READS")),substrb(dump(min("DIRECT_PHYSICAL_READS"),16,0,32),1,120),substrb(dump(max("DIRECT_PHYSICAL_READS"),16,0,32),1,120),count("DIRECT_PHYSICAL_WRITES"),count(distinct "DIRECT_PHYSICAL_WRITES"),sum(sys_op_opnsize("DIRECT_PHYSICAL_WRITES")),substrb(dump(min("DIRECT_PHYSICAL_WRITES"),16,0,32),1,120),substrb(dump(max("DIRECT_PHYSICAL_WRITES"),16,0,32)
,1,120),count("GC_CR_BLOCKS_RECEIVED"),count(distinct "GC_CR_BLOCKS_RECEIVED"),sum(sys_op_opnsize("GC_CR_BLOCKS_RECEIVED")),substrb(dump(min("GC_CR_BLOCKS_RECEIVED"),16,0,32),1,120),substrb(dump(max("GC_CR_BLOCKS_RECEIVED"),16,0,32),1,120),count("GC_CURRENT_BLOCKS_RECEIVED"),count(distinct "GC_CURRENT_BLOCKS_RECEIVED"),sum(sys_op_opnsize("GC_CURRENT_BLOCKS_RECEIVED")),substrb(dump(min("GC_CURRENT_BLOCKS_RECEIVED"),16,0,32),1,120),substrb(dump(max("GC_CURRENT_BLOCKS_RECEIVED"),16,0,32),1,120),count("GC_BUFFER_BUSY"),count(distinct "GC_BUFFER_BUSY"),sum(sys_op_opnsize("GC_BUFFER_BUSY")),substrb(dump(min("GC_BUFFER_BUSY"),16,0,32),1,120),substrb(dump(max("GC_BUFFER_BUSY"),16,0,32),1,120),count("ITL_WAITS"),count(distinct "ITL_WAITS"),sum(sys_op_opnsize("ITL_WAITS")),substrb(dump(min("ITL_WAITS"),16,0,32),1,120),substrb(dump(max("ITL_WAITS"),16,0,32),1,120),count("ROW_LOCK_WAITS"),count(dist
inct "ROW_LOCK_WAITS"),sum(sys_op_opnsize("ROW_LOCK_WAITS")),substrb(dump(min("ROW_LOCK_WAITS"),16,0,32),1,120),substrb(dump(max("ROW_LOCK_WAITS"),16,0,32),1,120),count("GLOBAL_CACHE_CR_BLOCKS_SERVED"),count(distinct "GLOBAL_CACHE_CR_BLOCKS_SERVED"),sum(sys_op_opnsize("GLOBAL_CACHE_CR_BLOCKS_SERVED")),substrb(dump(min("GLOBAL_CACHE_CR_BLOCKS_SERVED"),16,0,32),1,120),substrb(dump(max("GLOBAL_CACHE_CR_BLOCKS_SERVED"),16,0,32),1,120),count("GLOBAL_CACHE_CU_BLOCKS_SERVED"),count(distinct "GLOBAL_CACHE_CU_BLOCKS_SERVED"),sum(sys_op_opnsize("GLOBAL_CACHE_CU_BLOCKS_SERVED")),substrb(dump(min("GLOBAL_CACHE_CU_BLOCKS_SERVED"),16,0,32),1,120),substrb(dump(max("GLOBAL_CACHE_CU_BLOCKS_SERVED"),16,0,32),1,120) from "PERFSTAT"."STATS$SEG_STAT" t

select /*+ no_parallel_index(t,"STATS$SEG_STAT_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SEG_STAT_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12082,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SEG_STAT" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "DATAOBJ#" is not null or "OBJ#" is not null or "TS#" 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 "PERFSTAT"."STATS$SQLTEXT" 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("OLD_HASH_VALUE")),sum(sys_op_opnsize("TEXT_SUBSET")),sum(sys_op_opnsize("PIECE")),count("SQL_ID"),count(distinct "SQL_ID"),sum(sys_op_opnsize("SQL_ID")),substrb(dump(min("SQL_ID"),16,0,32),1,120),substrb(dump(max("SQL_ID"),16,0,32),1,120),count("SQL_TEXT"),count(distinct "SQL_TEXT"),sum(sys_op_opnsize("SQL_TEXT")),substrb(dump(min(substrb("SQL_TEXT",1,32)),16,0,32),1,120),substrb(dump(max(substrb("SQL_TEXT",1,32)),16,0,32),1,120),count("ADDRESS"),count(distinct "ADDRESS"),sum(sys_op_opnsize("ADDRESS")),substrb(dump(min("ADDRESS"),16,0,32),1,120),substrb(dump(max("ADDRESS"),16,0,32),1,120),count("COMMAND_TYPE"),count(distinct "COMMAND_TYPE"),sum(sys_op_opnsize("COMMAND_TYPE")),substrb(dump(min("COMMAND_TYPE"),16,0,32),1,120),su
bstrb(dump(max("COMMAND_TYPE"),16,0,32),1,120),count("LAST_SNAP_ID"),count(distinct "LAST_SNAP_ID"),sum(sys_op_opnsize("LAST_SNAP_ID")),substrb(dump(min("LAST_SNAP_ID"),16,0,32),1,120),substrb(dump(max("LAST_SNAP_ID"),16,0,32),1,120) from "PERFSTAT"."STATS$SQLTEXT" t


SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select /*+ no_parallel_index(t,"STATS$SQLTEXT_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SQLTEXT_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12051,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SQLTEXT" t where "OLD_HASH_VALUE" is not null or "TEXT_SUBSET" is not null or "PIECE" 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 "PERFSTAT"."STATS$SQL_PLAN_USAGE" 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_ID")),sum(sys_op_opnsize("DBID")),sum(sys_op_opnsize("INSTANCE_NUMBER")),count(distinct "OLD_HASH_VALUE"),sum(sys_op_opnsize("OLD_HASH_VALUE")),substrb(dump(min("OLD_HASH_VALUE"),16,0,32),1,120),substrb(dump(max("OLD_HASH_VALUE"),16,0,32),1,120),count(distinct "TEXT_SUBSET"),sum(sys_op_opnsize("TEXT_SUBSET")),substrb(dump(min("TEXT_SUBSET"),16,0,32),1,120),substrb(dump(max("TEXT_SUBSET"),16,0,32),1,120),sum(sys_op_opnsize("PLAN_HASH_VALUE")),count("HASH_VALUE"),sum(sys_op_opnsize("HASH_VALUE")),count("SQL_ID"),count(distinct "SQL_ID"),sum(sys_op_opnsize("SQL_ID")),substrb(dump(min("SQL_ID"),16,0,32),1,120),substrb(dump(max("SQL_ID"),16,0,32),1,120),count(distinct "COST"),sum(sys_op_opnsize("COST")),substrb(dump(min("COST"
),16,0,32),1,120),substrb(dump(max("COST"),16,0,32),1,120),count("ADDRESS"),sum(sys_op_opnsize("ADDRESS")),count("OPTIMIZER"),count(distinct "OPTIMIZER"),sum(sys_op_opnsize("OPTIMIZER")),substrb(dump(min("OPTIMIZER"),16,0,32),1,120),substrb(dump(max("OPTIMIZER"),16,0,32),1,120),count("LAST_ACTIVE_TIME"),count(distinct "LAST_ACTIVE_TIME"),substrb(dump(min("LAST_ACTIVE_TIME"),16,0,32),1,120),substrb(dump(max("LAST_ACTIVE_TIME"),16,0,32),1,120) from "PERFSTAT"."STATS$SQL_PLAN_USAGE" t

select /*+ no_parallel_index(t,"STATS$SQL_PLAN_USAGE_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SQL_PLAN_USAGE_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12075,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SQL_PLAN_USAGE" t where "SNAP_ID" is not null or "DBID" is not null or "INSTANCE_NUMBER" is not null or "OLD_HASH_VALUE" is not null or "TEXT_SUBSET" is not null or "PLAN_HASH_VALUE" is not null or "COST" is not null
select /*+ no_parallel_index(t,"STATS$SQL_PLAN_USAGE_HV") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SQL_PLAN_USAGE_HV") */ count(*) as nrw,count(distinct sys_op_lbid(12076,'L',t.rowid)) as nlb,count(distinct "OLD_HASH_VALUE") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SQL_PLAN_USAGE" t where "OLD_HASH_VALUE" 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 "PERFSTAT"."STATS$SQL_PLAN" 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("OBJECT_OWNER"),count(distinct "OBJECT_OWNER"),sum(sys_op_opnsize("OBJECT_OWNER")),substrb(dump(min("OBJECT_OWNER"),16,0,32),1,120),substrb(dump(max("OBJECT_OWNER"),16,0,32),1,120),count("OBJECT_NAME"),count(distinct "OBJECT_NAME"),sum(sys_op_opnsize("OBJECT_NAME")),substrb(dump(min("OBJECT_NAME"),16,0,32),1,120),substrb(dump(max("OBJECT_NAME"),16,0,32),1,120),count("OBJECT_ALIAS"),count(distinct "OBJECT_ALIAS"),sum(sys_op_opnsize("OBJECT_ALIAS")),substrb(dump(min(substrb("OBJECT_ALIAS",1,32)),16,0,32),1,120),substrb(dump(max(substrb("OBJECT_ALIAS",1,32)),16,0,32),1,120),count("OBJECT_TYPE"),count(distinct "OBJECT_TYPE"),sum(sys_op_opnsize("OBJECT_TYPE")),substrb(dump(min("OBJECT_TYPE"),16,0,32),1,120),substrb(dump(max("OBJECT_TYPE"),16,0,3
2),1,120),count("OPTIMIZER"),count(distinct "OPTIMIZER"),sum(sys_op_opnsize("OPTIMIZER")),substrb(dump(min("OPTIMIZER"),16,0,32),1,120),substrb(dump(max("OPTIMIZER"),16,0,32),1,120),count("PARENT_ID"),count(distinct "PARENT_ID"),sum(sys_op_opnsize("PARENT_ID")),substrb(dump(min("PARENT_ID"),16,0,32),1,120),substrb(dump(max("PARENT_ID"),16,0,32),1,120),count("DEPTH"),count(distinct "DEPTH"),sum(sys_op_opnsize("DEPTH")),substrb(dump(min("DEPTH"),16,0,32),1,120),substrb(dump(max("DEPTH"),16,0,32),1,120),count("POSITION"),count(distinct "POSITION"),sum(sys_op_opnsize("POSITION")),substrb(dump(min("POSITION"),16,0,32),1,120),substrb(dump(max("POSITION"),16,0,32),1,120),count("SEARCH_COLUMNS"),count(distinct "SEARCH_COLUMNS"),sum(sys_op_opnsize("SEARCH_COLUMNS")),substrb(dump(min("SEARCH_COLUMNS"),16,0,32),1,120),substrb(dump(max("SEARCH_COLUMNS"),16,0,32),1,120),count("COST"),count(distinct "
COST"),sum(sys_op_opnsize("COST")),substrb(dump(min("COST"),16,0,32),1,120),substrb(dump(max("COST"),16,0,32),1,120),count("CARDINALITY"),count(distinct "CARDINALITY"),sum(sys_op_opnsize("CARDINALITY")),substrb(dump(min("CARDINALITY"),16,0,32),1,120),substrb(dump(max("CARDINALITY"),16,0,32),1,120),count("BYTES"),count(distinct "BYTES"),sum(sys_op_opnsize("BYTES")),substrb(dump(min("BYTES"),16,0,32),1,120),substrb(dump(max("BYTES"),16,0,32),1,120),count("OTHER_TAG"),count(distinct "OTHER_TAG"),sum(sys_op_opnsize("OTHER_TAG")),substrb(dump(min(substrb("OTHER_TAG",1,32)),16,0,32),1,120),substrb(dump(max(substrb("OTHER_TAG",1,32)),16,0,32),1,120),count("PARTITION_START"),count(distinct "PARTITION_START"),sum(sys_op_opnsize("PARTITION_START")),substrb(dump(min("PARTITION_START"),16,0,32),1,120),substrb(dump(max("PARTITION_START"),16,0,32),1,120),count("PARTITION_STOP"),count(distinct "PARTITI

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ON_STOP"),sum(sys_op_opnsize("PARTITION_STOP")),substrb(dump(min("PARTITION_STOP"),16,0,32),1,120),substrb(dump(max("PARTITION_STOP"),16,0,32),1,120),count("PARTITION_ID"),count(distinct "PARTITION_ID"),sum(sys_op_opnsize("PARTITION_ID")),substrb(dump(min("PARTITION_ID"),16,0,32),1,120),substrb(dump(max("PARTITION_ID"),16,0,32),1,120),count("OTHER"),count(distinct "OTHER"),sum(sys_op_opnsize("OTHER")),substrb(dump(min(substrb("OTHER",1,32)),16,0,32),1,120),substrb(dump(max(substrb("OTHER",1,32)),16,0,32),1,120),count("DISTRIBUTION"),count(distinct "DISTRIBUTION"),sum(sys_op_opnsize("DISTRIBUTION")),substrb(dump(min("DISTRIBUTION"),16,0,32),1,120),substrb(dump(max("DISTRIBUTION"),16,0,32),1,120),count("CPU_COST"),count(distinct "CPU_COST"),sum(sys_op_opnsize("CPU_COST")),substrb(dump(min("CPU_COST"),16,0,32),1,120),substrb(dump(max("CPU_COST"),16,0,32),1,120),count("IO_COST"),count(distin
ct "IO_COST"),sum(sys_op_opnsize("IO_COST")),substrb(dump(min("IO_COST"),16,0,32),1,120),substrb(dump(max("IO_COST"),16,0,32),1,120),count("TEMP_SPACE"),count(distinct "TEMP_SPACE"),sum(sys_op_opnsize("TEMP_SPACE")),substrb(dump(min("TEMP_SPACE"),16,0,32),1,120),substrb(dump(max("TEMP_SPACE"),16,0,32),1,120),count("ACCESS_PREDICATES"),count(distinct "ACCESS_PREDICATES"),sum(sys_op_opnsize("ACCESS_PREDICATES")),substrb(dump(min(substrb("ACCESS_PREDICATES",1,32)),16,0,32),1,120),substrb(dump(max(substrb("ACCESS_PREDICATES",1,32)),16,0,32),1,120),count("FILTER_PREDICATES"),count(distinct "FILTER_PREDICATES"),sum(sys_op_opnsize("FILTER_PREDICATES")),substrb(dump(min(substrb("FILTER_PREDICATES",1,32)),16,0,32),1,120),substrb(dump(max(substrb("FILTER_PREDICATES",1,32)),16,0,32),1,120),count("PROJECTION"),count(distinct "PROJECTION"),sum(sys_op_opnsize("PROJECTION")),substrb(dump(min(substrb("P
ROJECTION",1,32)),16,0,32),1,120),substrb(dump(max(substrb("PROJECTION",1,32)),16,0,32),1,120),count("TIME"),count(distinct "TIME"),sum(sys_op_opnsize("TIME")),substrb(dump(min("TIME"),16,0,32),1,120),substrb(dump(max("TIME"),16,0,32),1,120),count("QBLOCK_NAME"),count(distinct "QBLOCK_NAME"),sum(sys_op_opnsize("QBLOCK_NAME")),substrb(dump(min("QBLOCK_NAME"),16,0,32),1,120),substrb(dump(max("QBLOCK_NAME"),16,0,32),1,120),count("REMARKS"),count(distinct "REMARKS"),sum(sys_op_opnsize("REMARKS")),substrb(dump(min(substrb("REMARKS",1,32)),16,0,32),1,120),substrb(dump(max(substrb("REMARKS",1,32)),16,0,32),1,120),count("SNAP_ID"),count(distinct "SNAP_ID"),sum(sys_op_opnsize("SNAP_ID")),substrb(dump(min("SNAP_ID"),16,0,32),1,120),substrb(dump(max("SNAP_ID"),16,0,32),1,120),sum(sys_op_opnsize("PLAN_HASH_VALUE")),count(distinct "ID"),sum(sys_op_opnsize("ID")),substrb(dump(min("ID"),16,0,32),1,120)
,substrb(dump(max("ID"),16,0,32),1,120),count("OPERATION"),count(distinct "OPERATION"),sum(sys_op_opnsize("OPERATION")),substrb(dump(min("OPERATION"),16,0,32),1,120),substrb(dump(max("OPERATION"),16,0,32),1,120),count("OPTIONS"),count(distinct "OPTIONS"),sum(sys_op_opnsize("OPTIONS")),substrb(dump(min("OPTIONS"),16,0,32),1,120),substrb(dump(max("OPTIONS"),16,0,32),1,120),count("OBJECT_NODE"),count(distinct "OBJECT_NODE"),sum(sys_op_opnsize("OBJECT_NODE")),substrb(dump(min(substrb("OBJECT_NODE",1,32)),16,0,32),1,120),substrb(dump(max(substrb("OBJECT_NODE",1,32)),16,0,32),1,120),count("OBJECT#"),count(distinct "OBJECT#"),sum(sys_op_opnsize("OBJECT#")),substrb(dump(min("OBJECT#"),16,0,32),1,120),substrb(dump(max("OBJECT#"),16,0,32),1,120) from "PERFSTAT"."STATS$SQL_PLAN" t

select /*+ no_parallel_index(t,"STATS$SQL_PLAN_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$SQL_PLAN_PK") */ count(*) as nrw,count(distinct sys_op_lbid(12079,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$SQL_PLAN" t where "PLAN_HASH_VALUE" is not null or "ID" 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
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("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")),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")) from "SH"."CUSTOMERS" sample (  9.9099099099) t


SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select trunc(SYSDATE+:"SYS_B_0"/:"SYS_B_1"/:"SYS_B_2"*:"SYS_B_3",:"SYS_B_4") from dual
select sysdate+(:"SYS_B_0")/(:"SYS_B_1"*:"SYS_B_2") from dual
select a.snap_level   value  from perfstat.stats$snapshot a where a.ucomment=:"SYS_B_0"
select	count(*) from perfstat.stats$snapshot

177 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:42 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:42 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:42 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:43 2015

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

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

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


R502000=2




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

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

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

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

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


R503001=0



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

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

SQL> Connected.
SQL> SQL> 
BUFFER_
-------
KEEP

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 full is 0.1 0.2
R102002: 0 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 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.2 full is 0.2 2.36
R201042: 0.2 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 full is 0.2 4.0
R201135: 0 full is 0.2 4.2
R201235: 0 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: .6 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: 2 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:
14.60


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