

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** 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 PATH=/u01/app/oracle/product/10.2.0/db_1/jdk/bin:$ORACLE_HOME/bin:$PATH
export LANG=en_US
export ORACLE_SID=PROD
export TNS_ADMIN=$ORACLE_HOME/network/admin


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

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

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/product/10.2.0/db_1/rdbms/log

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:18:57 2015

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

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

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

13 rows selected.

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


R201010=0.1


A: ADMINISTER RESOURCE MANAGER


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

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

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

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

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


R201031=0.2



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

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

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

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


R201131=0.2




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

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

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

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

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


R201032=0.2



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

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

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

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


R201132=0.2




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

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

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

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

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


R201133=0.2




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

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

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

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

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


R201034=0




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

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

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

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

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


R201035=0.2



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

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

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

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


R201135=0.2



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

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

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

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


R201235=0.2




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

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


R201041=0


A: 0

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

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

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

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


R201042=0


A: 0


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

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


R201051=0


A: 0

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

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

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

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


R201052=0


A: 0


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

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

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

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

SYS
DBMS_DATAPUMP
								 BODY			      PACKAGE BODY			 147141 	 1	  587	       1	  0 NO		  1		0

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

SYS
DBMS_SYS_SQL
								 BODY			      PACKAGE BODY			  67196 	 1	27836	       1	  0 NO		  1		0

SYS
KUPM$MCP

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

SYS
DBMS_STATS
								 TABLE/PROCEDURE	      PACKAGE				 132494 	 3	    0	       0	  0 YES 	  1		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			 243731 	 1	   27	       0	  0 NO		  1		0


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

SYS
DBMS_METADATA_UTIL
								 BODY			      PACKAGE BODY			  71138 	 1	  637	       0	  0 NO		  1		0

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

PERFSTAT
STATSPACK
								 BODY			      PACKAGE BODY			  64690 	 1	   30	       0	  0 YES 	  1		0

SYS
DBMS_XPLAN

OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
								 BODY			      PACKAGE BODY			 116902 	 1	    1	       0	  0 NO		  1		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			  97663 	 2	    0	       1	  0 NO		  1		0

SYS
DBMS_STATS
								 BODY			      PACKAGE BODY			 463682 	 1	  183	       0	  0 YES 	  1		0


OWNER
----------------------------------------------------------------
NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB_LINK 							 NAMESPACE		      TYPE			   SHARABLE_MEM      LOADS EXECUTIONS	   LOCKS       PINS KEP CHILD_LATCH INVALIDATIONS
---------------------------------------------------------------- ---------------------------- ---------------------------- ------------ ---------- ---------- ---------- ---------- --- ----------- -------------
SYS
DBMS_PRVTAQIM
								 BODY			      PACKAGE BODY			 104805 	 2	   44	       0	  0 NO		  1		0

SYS
DBMS_METADATA_INT
								 BODY			      PACKAGE BODY			 222957 	 1	 2040	       0	  0 NO		  1		0

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

SYS
KUPF$FILE
								 BODY			      PACKAGE BODY			  87441 	 1	 1564	       0	  0 NO		  1		0

SYS
DBMS_STATS_INTERNAL

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

SYS
DBMS_PRVTAQIS
								 BODY			      PACKAGE BODY			 108005 	 2	 1685	       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			 106702 	 2	   25	       1	  0 NO		  1		0

SYS
PRVT_ADVISOR
								 BODY			      PACKAGE BODY			  75288 	 1	   74	       0	  0 NO		  1		0


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

SYS
DBMS_SPACE
								 BODY			      PACKAGE BODY			 107410 	 1	15652	       0	  0 NO		  1		0

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

SYS
DBMS_SNAPSHOT_UTL
								 BODY			      PACKAGE BODY			  53905 	 1	   22	       0	  0 NO		  1		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	      15	  0 NO		  1		0

SYS

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

SYS
DBMS_RCVMAN
								 BODY			      PACKAGE BODY			 383735 	 2	  272	       1	  0 NO		  1		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:19:00 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:19:00 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


R302001=0.15



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


R302003=0.15



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:19:01 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:19:01 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:19:01 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:19:01 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:19:01 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:19:01 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:19:01 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:19:01 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:19:01 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:19:01 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:19:02 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:19:02 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:19:02 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:19:02 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:19:02 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:19:02 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:19:02 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:19:02 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:19:02 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:19:02 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:19:02 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:19:02 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:19:03 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:19:03 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:19:03 2015

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

SQL> Connected.
SQL> SQL>   2  
 ANALYZEDT
----------
2193.26638

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:19:03 2015

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

SQL> Connected.
SQL> SQL>   2  
 ANALYZEDT
----------
2193.26638

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

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

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

SQL> Connected.
SQL> SQL> SQL> SQL> 
SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT last_name, salary FROM hr.employees
INSERT INTO STATS$FILESTATXS ( SNAP_ID , DBID , INSTANCE_NUMBER , TSNAME , FILENAME , PHYRDS , PHYWRTS , SINGLEBLKRDS , READTIM , WRITETIM , SINGLEBLKRDTIM , PHYBLKRD , PHYBLKWRT , WAIT_COUNT , TIME , FILE# ) SELECT :B3 , :B2 , :B1 , TSNAME , FILENAME , PHYRDS , PHYWRTS , SINGLEBLKRDS , READTIM , WRITETIM , SINGLEBLKRDTIM , PHYBLKRD , PHYBLKWRT , WAIT_COUNT , TIME , FILE# FROM STATS$V$FILESTATXS
 select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*)  from "PERFSTAT"."STATS$LEVEL_DESCRIPTION" t
select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*),sum(sys_op_opnsize("SNAP_LEVEL")),substrb(dump(min("SNAP_LEVEL"),16,0,32),1,120),substrb(dump(max("SNAP_LEVEL"),16,0,32),1,120),count("DESCRIPTION"),count(distinct "DESCRIPTION"),sum(sys_op_opnsize("DESCRIPTION")),substrb(dump(min(substrb("DESCRIPTION",1,32)),16,0,32),1,120),substrb(dump(max(substrb("DESCRIPTION",1,32)),16,0,32),1,120) from "PERFSTAT"."STATS$LEVEL_DESCRIPTION" t
select /*+ no_parallel_index(t,"STATS$LEVEL_DESCRIPTION_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$LEVEL_DESCRIPTION_PK") */ count(*) as nrw,count(distinct sys_op_lbid(10711,'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(*),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_CA
LLS_TH")),substrb(dump(min("PARSE_CALLS_TH"),16,0,32),1,120),substrb(dump(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),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("P
IN_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_MODIFIED"),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,12
0),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) from "PERFSTAT"."STATS$STATSPACK_PARAMETER" t

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

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(10788,'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
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(10842,'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(*),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),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_N
AME")),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) 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(10709,'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

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(*),sum(sys_op_opnsize("SNAP_ID")),sum(sys_op_opnsize("DBID")),sum(sys_op_opnsize("INSTANCE_NUMBER")),count(distinct "SNAP_TIME"),substrb(dump(min("SNAP_TIME"),16,0,32),1,120),substrb(dump(max("SNAP_TIME"),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(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(distinc
t "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_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("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"),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("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(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),coun
t("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(10713,'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

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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(10715,'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$FILESTATXS" 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 "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$FILESTATXS" t

select /*+ no_parallel_index(t,"STATS$FILESTATXS_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"STATS$FILESTATXS_PK") */ count(*) as nrw,count(distinct sys_op_lbid(10717,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$FILESTATXS" 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

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$TEMPSTATXS" 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 "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(10719,'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

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

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(10721,'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(10727,'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

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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
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(10729,'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(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),count("SET_MSIZE"),count(distinct "SET_MSIZE"),sum(sys_op_opnsize("SET_MSIZE")),substrb(dump(min("SET_MSIZE"),16,0,32),1,120),subs
trb(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_GOT")),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("S
UM_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(distinct "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_IN
SPECTED")),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 "DBID"),sum(sys_op_opnsize("DBID")),substrb(dump(min("DBID"),16,0,32),1,120),substrb(dump(max("DBID"),16,0,32),1,120) from "PERFSTAT"."STATS$BUFFER_POOL_STATISTICS" t


SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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(10731,'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
 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(10733,'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_

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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
_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(10735,'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(10737,'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),

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

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(10739,'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(10741,'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(10745,'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(10749,'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


SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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(10751,'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
 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(10753,'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(*),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")),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("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(dump(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("EXECUTION
S"),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"),count(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")),s

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ubstrb(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"),count(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_WAI
T_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"),sum(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_LA
TCH"),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(dump(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),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) 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(10755,'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 "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),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("INSTAN
CE_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_MEM"),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) 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(10759,'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(10761,'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

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
),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(
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(10771,'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(10780,'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

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
,32),1,120) from "PERFSTAT"."STATS$PGASTAT" t

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(10782,'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(10784,'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

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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
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(10786,'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(10790,'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

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$SQL_WORKAREA_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 "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(10792,'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


SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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(10794,'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
 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(10796,'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("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),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_NUMBER"),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) 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(10798,'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(10800,'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


SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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(10802,'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
 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(10804,'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(10806,'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

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ATS$SYS_TIME_MODEL" t

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(10808,'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(10824,'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

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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(10826,'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
 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(10828,'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


SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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(10830,'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
 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(10832,'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


SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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(10834,'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
 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(10836,'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 "OLTP_USER"."SALES" 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("SALES_ID"),count(distinct "SALES_ID"),sum(sys_op_opnsize("SALES_ID")),substrb(dump(min("SALES_ID"),16,0,32),1,120),substrb(dump(max("SALES_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("PROD_ID"),count(distinct "PROD_ID"),sum(sys_op_opnsize("PROD_ID")),substrb(dump(min("PROD_ID"),16,0,32),1,120),substrb(dump(max("PROD_ID"),16,0,32),1,120),count("SDATE"),count(distinct "SDATE"),substrb(dump(min("SDATE"),16,0,32),1,120),substrb(dump(max("SDATE"),16,0,32),1,120) from "OLTP_USER"."SALES" t
select /*+ no_parallel_index(t,"SALES_ID_IDX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"SALES_ID_IDX") */ count(*) as nrw,count(distinct sys_op_lbid(9752,'L',t.rowid)) as nlb,count(distinct "SALES_ID") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "OLTP_USER"."SALES" t where "SALES_ID" is not null
select /*+ no_parallel_index(t,"NAME_IDX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"NAME_IDX") */ count(*) as nrw,count(distinct sys_op_lbid(9753,'L',t.rowid)) as nlb,count(distinct "NAME") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "OLTP_USER"."SALES" t where "NAME" is not null

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select /*+ no_parallel_index(t,"PROD_ID_IDX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"PROD_ID_IDX") */ count(*) as nrw,count(distinct sys_op_lbid(9754,'L',t.rowid)) as nlb,count(distinct "PROD_ID") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "OLTP_USER"."SALES" t where "PROD_ID" is not null
select /*+ no_parallel_index(t,"SDATE_IDX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"SDATE_IDX") */ count(*) as nrw,count(distinct sys_op_lbid(9755,'L',t.rowid)) as nlb,count(distinct "SDATE") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "OLTP_USER"."SALES" t where "SDATE" 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" 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(10778,'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

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

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(10757,'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(10773,'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(10774,'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(*),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(s

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ys_op_opnsize("OBJECT#")),substrb(dump(min("OBJECT#"),16,0,32),1,120),substrb(dump(max("OBJECT#"),16,0,32),1,120),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,32),1,120),count("OPTIMIZER"),c
ount(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("COS
T")),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 "PARTITION_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(distinct "IO_COST"),sum(sys_op_opnsi
ze("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("PROJECTION",1,32)),16,0,32),1,1
20),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) 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(10776,'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 "DBSNMP"."MGMT_BASELINE" 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("INSTANCE_NUMBER")),count(distinct "CAPTURE_TIME"),substrb(dump(min("CAPTURE_TIME"),16,0,32),1,120),substrb(dump(max("CAPTURE_TIME"),16,0,32),1,120),count(distinct "PREV_CAPTURE_TIME"),substrb(dump(min("PREV_CAPTURE_TIME"),16,0,32),1,120),substrb(dump(max("PREV_CAPTURE_TIME"),16,0,32),1,120),count("DB_TIME"),count(distinct "DB_TIME"),sum(sys_op_opnsize("DB_TIME")),substrb(dump(min("DB_TIME"),16,0,32),1,120),substrb(dump(max("DB_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("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("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"),sum(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("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) from "DBSNMP"."MGMT_BASELINE" 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(*)  from "DBSNMP"."MGMT_RESPONSE_CONFIG" 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("INSTANCE_NUMBER")),count("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) from "DBSNMP"."MGMT_RESPONSE_CONFIG" 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 "DBSNMP"."MGMT_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(*)  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(*),count(UPPER("CUST_LAST_NAME")),count(distinct UPPER("CUST_LAST_NAME")),sum(sys_op_opnsize(UPPER("CUST_LAST_NAME"))),substrb(dump(min(substrb(UPPER("CUST_LAST_NAME"),1,32)),16,0,32),1,120),substrb(dump(max(substrb(UPPER("CUST_LAST_NAME"),1,32)),16,0,32),1,120),sum(sys_op_opnsize("CUST_ID")),sum(sys_op_opnsize("CUST_FIRST_NAME")),sum(sys_op_opnsize("CUST_LAST_NAME")),sum(sys_op_opnsize("CUST_YEAR_OF_BIRTH")),count("CUST_MARITAL_STATUS"),sum(sys_op_opnsize("CUST_MARITAL_STATUS")),sum(sys_op_opnsize("CUST_STREET_ADDRESS")),sum(sys_op_opnsize("CUST_POSTAL_CODE")),sum(sys_op_opnsize("CUST_CITY")),sum(sys_op_opnsize("CUST_CITY_ID")),sum(sys_op_opnsize("CUST_STATE_PROVINCE")),sum(sys_op_opnsize("CUST_STATE_PROVINCE_ID")),sum(sys_op_opnsize("COUNTRY_ID"))
,sum(sys_op_opnsize("CUST_MAIN_PHONE_NUMBER")),count("CUST_INCOME_LEVEL"),sum(sys_op_opnsize("CUST_INCOME_LEVEL")),count("CUST_CREDIT_LIMIT"),sum(sys_op_opnsize("CUST_CREDIT_LIMIT")),count("CUST_EMAIL"),sum(sys_op_opnsize("CUST_EMAIL")),sum(sys_op_opnsize("CUST_TOTAL")),sum(sys_op_opnsize("CUST_TOTAL_ID")),count("CUST_SRC_ID"),sum(sys_op_opnsize("CUST_SRC_ID")),count("CUST_EFF_FROM"),count("CUST_EFF_TO"),count("CUST_VALID"),sum(sys_op_opnsize("CUST_VALID")) from "SH"."CUSTOMERS" sample (  9.9099099099) t

INSERT INTO STATS$SGA ( SNAP_ID , DBID , INSTANCE_NUMBER , NAME , VALUE ) SELECT :B3 , :B2 , :B1 , NAME , VALUE FROM V$SGA
INSERT INTO STATS$ENQUEUE_STATISTICS ( SNAP_ID , DBID , INSTANCE_NUMBER , EQ_TYPE , REQ_REASON , TOTAL_REQ# , TOTAL_WAIT# , SUCC_REQ# , FAILED_REQ# , CUM_WAIT_TIME , EVENT# ) SELECT :B3 , :B2 , :B1 , EQ_TYPE , REQ_REASON , TOTAL_REQ# , TOTAL_WAIT# , SUCC_REQ# , FAILED_REQ# , CUM_WAIT_TIME , EVENT# FROM V$ENQUEUE_STATISTICS WHERE TOTAL_REQ# != 0

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
INSERT INTO STATS$ROWCACHE_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER , PARAMETER , TOTAL_USAGE , USAGE , GETS , GETMISSES , SCANS , SCANMISSES , SCANCOMPLETES , MODIFICATIONS , FLUSHES , DLM_REQUESTS , DLM_CONFLICTS , DLM_RELEASES ) SELECT :B3 , :B2 , :B1 , PARAMETER , SUM("COUNT") , SUM(USAGE) , SUM(GETS) , SUM(GETMISSES) , SUM(SCANS) , SUM(SCANMISSES) , SUM(SCANCOMPLETES) , SUM(MODIFICATIONS) , SUM(FLUSHES) , SUM(DLM_REQUESTS) , SUM(DLM_CONFLICTS) , SUM(DLM_RELEASES) FROM V$ROWCACHE GROUP BY :B3 , :B2 , :B1 , PARAMETER
INSERT INTO STATS$PROCESS_ROLLUP ( SNAP_ID , DBID , INSTANCE_NUMBER , PID , SERIAL# , SPID , PROGRAM , BACKGROUND , PGA_USED_MEM , PGA_ALLOC_MEM , PGA_FREEABLE_MEM , MAX_PGA_ALLOC_MEM , MAX_PGA_MAX_MEM , AVG_PGA_ALLOC_MEM , STDDEV_PGA_ALLOC_MEM , NUM_PROCESSES ) SELECT * FROM (SELECT * FROM (SELECT :B3 AS L_SNAP_ID , :B2 AS P_DBID , :B1 AS P_INSTANCE_NUMBER , NVL(PID, -9) PID , NVL(SERIAL#, -9) SERIAL# , DECODE(PID, NULL, NULL, MAX(SPID)) SPID , DECODE(PID, NULL, NULL, MAX(PROGRAM)) PROGRAM , DECODE(PID, NULL, NULL, MAX(BACKGROUND)) BACKGROUND , SUM(PGA_USED_MEM) PGA_USED_MEM , SUM(PGA_ALLOC_MEM) PGA_ALLOC_MEM , SUM(PGA_FREEABLE_MEM) PGA_FREEABLE_MEM , MAX(PGA_ALLOC_MEM) MAX_PGA_ALLOC_MEM , MAX(PGA_MAX_MEM) MAX_PGA_MAX_MEM , DECODE(PID, NULL, AVG(PGA_ALLOC_MEM), NULL) AVG_PGA_ALLOC_MEM , DECODE(PID, NULL, STDDEV(PGA_ALLOC_MEM), NULL) STDDEV_PGA_ALLOC_MEM , DECODE(PID, NULL, COUNT(PID), N
ULL) NUM_PROCESSES FROM V$PROCESS WHERE PROGRAM != 'PSEUDO' GROUP BY GROUPING SETS ( (PID, SERIAL#), () ) ) WHERE PID = -9 OR PGA_ALLOC_MEM >= (:B4 *1024*1024) ORDER BY PGA_ALLOC_MEM DESC ) WHERE ROWNUM <= (:B5 + 1)

INSERT INTO STATS$SQL_WORKAREA_HISTOGRAM ( SNAP_ID , DBID , INSTANCE_NUMBER , LOW_OPTIMAL_SIZE , HIGH_OPTIMAL_SIZE , OPTIMAL_EXECUTIONS , ONEPASS_EXECUTIONS , MULTIPASSES_EXECUTIONS , TOTAL_EXECUTIONS ) SELECT :B3 , :B2 , :B1 , LOW_OPTIMAL_SIZE , HIGH_OPTIMAL_SIZE , OPTIMAL_EXECUTIONS , ONEPASS_EXECUTIONS , MULTIPASSES_EXECUTIONS , TOTAL_EXECUTIONS FROM V$SQL_WORKAREA_HISTOGRAM WHERE TOTAL_EXECUTIONS > 0
SELECT 1 FROM STATS$DATABASE_INSTANCE WHERE STARTUP_TIME = :B3 AND DBID = :B2 AND INSTANCE_NUMBER = :B1
INSERT INTO STATS$SYSTEM_EVENT ( SNAP_ID , DBID , INSTANCE_NUMBER , EVENT , TOTAL_WAITS , TOTAL_TIMEOUTS , TIME_WAITED_MICRO , EVENT_ID ) SELECT :B3 , :B2 , :B1 , EVENT , TOTAL_WAITS , TOTAL_TIMEOUTS , TIME_WAITED_MICRO , EVENT_ID FROM V$SYSTEM_EVENT
INSERT INTO STATS$SQL_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER , TEXT_SUBSET , SQL_ID , SHARABLE_MEM , SORTS , MODULE , LOADED_VERSIONS , FETCHES , EXECUTIONS , PX_SERVERS_EXECUTIONS , END_OF_FETCH_COUNT , LOADS , INVALIDATIONS , PARSE_CALLS , DISK_READS , DIRECT_WRITES , BUFFER_GETS , APPLICATION_WAIT_TIME , CONCURRENCY_WAIT_TIME , CLUSTER_WAIT_TIME , USER_IO_WAIT_TIME , PLSQL_EXEC_TIME , JAVA_EXEC_TIME , ROWS_PROCESSED , COMMAND_TYPE , ADDRESS , HASH_VALUE , OLD_HASH_VALUE , VERSION_COUNT , CPU_TIME , ELAPSED_TIME , OUTLINE_SID , OUTLINE_CATEGORY , CHILD_LATCH , SQL_PROFILE , PROGRAM_ID , PROGRAM_LINE# , EXACT_MATCHING_SIGNATURE , FORCE_MATCHING_SIGNATURE , LAST_ACTIVE_TIME ) SELECT /*+ index (sql.GV$SQL.X$KGLOB) */ :B3 , :B2 , :B1 , MAX(SUBSTRB(SQL_TEXT,1,31)) TEXT_SUBSET , MAX(SQL_ID) SQL_ID , SUM(SHARABLE_MEM) SHARABLE_MEM , SUM(SORTS) SORTS , MAX(MODULE) MODULE , SUM(LOADED_VERSI
ONS) LOADED_VERSIONS , SUM(FETCHES) FETCHES , SUM(EXECUTIONS) EXECUTIONS , SUM(PX_SERVERS_EXECUTIONS) PX_SERVERS_EXECUTIONS , SUM(END_OF_FETCH_COUNT) END_OF_FETCH_COUNT , SUM(LOADS) LOADS , SUM(INVALIDATIONS) INVALIDATIONS , SUM(PARSE_CALLS) PARSE_CALLS , SUM(DISK_READS) DISK_READS , SUM(DIRECT_WRITES) DIRECT_WRITES , SUM(BUFFER_GETS) BUFFER_GERS , SUM(APPLICATION_WAIT_TIME) APPLICATION_WAIT_TIME , SUM(CONCURRENCY_WAIT_TIME) CONCURRENCY_WAIT_TIME , SUM(CLUSTER_WAIT_TIME) CLUSTER_WAIT_TIME , SUM(USER_IO_WAIT_TIME) USER_IO_WAIT_TIME , SUM(PLSQL_EXEC_TIME) PLSQL_EXEC_TIME , SUM(JAVA_EXEC_TIME) JAVA_EXEC_TIME , SUM(ROWS_PROCESSED) ROWS_PROCESSED , MAX(COMMAND_TYPE) COMMAND_TYPE , ADDRESS , MAX(HASH_VALUE) HASH_VALUE , OLD_HASH_VALUE , COUNT(1) VERSION_COUNT , SUM(CPU_TIME) CPU_TIME , SUM(ELAPSED_TIME) ELAPSED_TIME , MAX(OUTLINE_SID) OUTLINE_SID , MAX(OUTLINE_CATEGORY) OUTLINE_CATEGORY , MAX(
CHILD_LATCH) CHILD_LATCH , MAX(SQL_PROFILE) SQL_PROFILE , MAX(PROGRAM_ID) PROGRAM_ID , MAX(PROGRAM_LINE#) PROGRAM_LINE# , MAX(EXACT_MATCHING_SIGNATURE) EXACT_MATCHING_SIGNATURE , MAX(FORCE_MATCHING_SIGNATURE) FORCE_MATCHING_SIGNATURE , MAX(LAST_ACTIVE_TIME) LAST_ACTIVE_TIME FROM V$SQL SQL WHERE IS_OBSOLETE = 'N' AND SQL_ID IN (SELECT /*+ unnest full (sqlstats) */ SQL_ID FROM STATS$V$SQLSTATS_SUMMARY SQLSTATS WHERE ( BUFFER_GETS > :B9 OR DISK_READS > :B8 OR PARSE_CALLS > :B7 OR EXECUTIONS > :B6 OR SHARABLE_MEM > :B5 OR VERSION_COUNT > :B4 ) ) GROUP BY OLD_HASH_VALUE, ADDRESS


SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
INSERT INTO STATS$SGA_TARGET_ADVICE ( SNAP_ID , DBID , INSTANCE_NUMBER , SGA_SIZE , SGA_SIZE_FACTOR , ESTD_DB_TIME , ESTD_DB_TIME_FACTOR , ESTD_PHYSICAL_READS ) SELECT :B3 , :B2 , :B1 , SGA_SIZE , SGA_SIZE_FACTOR , ESTD_DB_TIME , ESTD_DB_TIME_FACTOR , ESTD_PHYSICAL_READS FROM V$SGA_TARGET_ADVICE
INSERT INTO STATS$SQL_STATISTICS ( SNAP_ID , DBID , INSTANCE_NUMBER , TOTAL_SQL , TOTAL_SQL_MEM , SINGLE_USE_SQL , SINGLE_USE_SQL_MEM , TOTAL_CURSORS ) SELECT :B3 , :B2 , :B1 , COUNT(1) , SUM(SHARABLE_MEM) , SUM(DECODE(EXECUTIONS, 1, 1, 0)) , SUM(DECODE(EXECUTIONS, 1, SHARABLE_MEM, 0)) , SUM(VERSION_COUNT) FROM STATS$V$SQLSTATS_SUMMARY WHERE SHARABLE_MEM > 0
INSERT INTO STATS$ROLLSTAT ( SNAP_ID , DBID , INSTANCE_NUMBER , USN , EXTENTS , RSSIZE , WRITES , XACTS , GETS , WAITS , OPTSIZE , HWMSIZE , SHRINKS , WRAPS , EXTENDS , AVESHRINK , AVEACTIVE ) SELECT :B3 , :B2 , :B1 , USN , EXTENTS , RSSIZE , WRITES , XACTS , GETS , WAITS , OPTSIZE , HWMSIZE , SHRINKS , WRAPS , EXTENDS , AVESHRINK , AVEACTIVE FROM V$ROLLSTAT
INSERT INTO STATS$FILE_HISTOGRAM ( SNAP_ID , DBID , INSTANCE_NUMBER , FILE# , SINGLEBLKRDTIM_MILLI , SINGLEBLKRDS ) SELECT :B3 , :B2 , :B1 , FILE# , SINGLEBLKRDTIM_MILLI , SINGLEBLKRDS FROM V$FILE_HISTOGRAM WHERE SINGLEBLKRDS > 0
INSERT INTO STATS$BUFFERED_SUBSCRIBERS ( SNAP_ID , DBID , INSTANCE_NUMBER , QUEUE_SCHEMA , QUEUE_NAME , SUBSCRIBER_ID , SUBSCRIBER_NAME , SUBSCRIBER_ADDRESS , SUBSCRIBER_TYPE , STARTUP_TIME , NUM_MSGS , CNUM_MSGS , TOTAL_SPILLED_MSG ) SELECT :B3 , :B2 , :B1 , V.QUEUE_SCHEMA , V.QUEUE_NAME , V.SUBSCRIBER_ID , V.SUBSCRIBER_NAME , V.SUBSCRIBER_ADDRESS , V.SUBSCRIBER_TYPE , V.STARTUP_TIME , V.NUM_MSGS , V.CNUM_MSGS , V.TOTAL_SPILLED_MSG FROM V$BUFFERED_SUBSCRIBERS V
INSERT INTO STATS$SHARED_POOL_ADVICE ( SNAP_ID , DBID , INSTANCE_NUMBER , SHARED_POOL_SIZE_FOR_ESTIMATE , SHARED_POOL_SIZE_FACTOR , ESTD_LC_SIZE , ESTD_LC_MEMORY_OBJECTS , ESTD_LC_TIME_SAVED , ESTD_LC_TIME_SAVED_FACTOR , ESTD_LC_LOAD_TIME , ESTD_LC_LOAD_TIME_FACTOR , ESTD_LC_MEMORY_OBJECT_HITS ) SELECT :B3 , :B2 , :B1 , SHARED_POOL_SIZE_FOR_ESTIMATE , SHARED_POOL_SIZE_FACTOR , ESTD_LC_SIZE , ESTD_LC_MEMORY_OBJECTS , ESTD_LC_TIME_SAVED , ESTD_LC_TIME_SAVED_FACTOR , ESTD_LC_LOAD_TIME , ESTD_LC_LOAD_TIME_FACTOR , ESTD_LC_MEMORY_OBJECT_HITS FROM V$SHARED_POOL_ADVICE
INSERT INTO STATS$BUFFER_POOL_STATISTICS ( SNAP_ID , DBID , INSTANCE_NUMBER , ID , NAME , BLOCK_SIZE , SET_MSIZE , CNUM_REPL , CNUM_WRITE , CNUM_SET , BUF_GOT , SUM_WRITE , SUM_SCAN , FREE_BUFFER_WAIT , WRITE_COMPLETE_WAIT , BUFFER_BUSY_WAIT , FREE_BUFFER_INSPECTED , DIRTY_BUFFERS_INSPECTED , DB_BLOCK_CHANGE , DB_BLOCK_GETS , CONSISTENT_GETS , PHYSICAL_READS , PHYSICAL_WRITES ) SELECT :B3 , :B2 , :B1 , ID , NAME , BLOCK_SIZE , SET_MSIZE , CNUM_REPL , CNUM_WRITE , CNUM_SET , BUF_GOT , SUM_WRITE , SUM_SCAN , FREE_BUFFER_WAIT , WRITE_COMPLETE_WAIT , BUFFER_BUSY_WAIT , FREE_BUFFER_INSPECTED , DIRTY_BUFFERS_INSPECTED , DB_BLOCK_CHANGE , DB_BLOCK_GETS , CONSISTENT_GETS , PHYSICAL_READS , PHYSICAL_WRITES FROM V$BUFFER_POOL_STATISTICS
INSERT INTO STATS$OSSTAT ( SNAP_ID , DBID , INSTANCE_NUMBER , OSSTAT_ID , VALUE ) SELECT :B3 , :B2 , :B1 , OSSTAT_ID , VALUE FROM V$OSSTAT
INSERT INTO STATS$JAVA_POOL_ADVICE ( SNAP_ID , DBID , INSTANCE_NUMBER , JAVA_POOL_SIZE_FOR_ESTIMATE , JAVA_POOL_SIZE_FACTOR , ESTD_LC_SIZE , ESTD_LC_MEMORY_OBJECTS , ESTD_LC_TIME_SAVED , ESTD_LC_TIME_SAVED_FACTOR , ESTD_LC_LOAD_TIME , ESTD_LC_LOAD_TIME_FACTOR , ESTD_LC_MEMORY_OBJECT_HITS ) SELECT :B3 , :B2 , :B1 , JAVA_POOL_SIZE_FOR_ESTIMATE , JAVA_POOL_SIZE_FACTOR , ESTD_LC_SIZE , ESTD_LC_MEMORY_OBJECTS , ESTD_LC_TIME_SAVED , ESTD_LC_TIME_SAVED_FACTOR , ESTD_LC_LOAD_TIME , ESTD_LC_LOAD_TIME_FACTOR , ESTD_LC_MEMORY_OBJECT_HITS FROM V$JAVA_POOL_ADVICE
INSERT INTO STATS$EVENT_HISTOGRAM ( SNAP_ID , DBID , INSTANCE_NUMBER , EVENT_ID , WAIT_TIME_MILLI , WAIT_COUNT ) SELECT :B3 , :B2 , :B1 , EN.EVENT_ID , WAIT_TIME_MILLI , WAIT_COUNT FROM V$EVENT_HISTOGRAM EH , V$EVENT_NAME EN WHERE EH.EVENT = EN.NAME AND EH.EVENT# = EN.EVENT#
INSERT INTO STATS$RESOURCE_LIMIT ( SNAP_ID , DBID , INSTANCE_NUMBER , RESOURCE_NAME , CURRENT_UTILIZATION , MAX_UTILIZATION , INITIAL_ALLOCATION , LIMIT_VALUE ) SELECT :B3 , :B2 , :B1 , RESOURCE_NAME , CURRENT_UTILIZATION , MAX_UTILIZATION , INITIAL_ALLOCATION , LIMIT_VALUE FROM V$RESOURCE_LIMIT WHERE LIMIT_VALUE != ' UNLIMITED' AND MAX_UTILIZATION > 0

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
INSERT INTO STATS$PGA_TARGET_ADVICE ( SNAP_ID , DBID , INSTANCE_NUMBER , PGA_TARGET_FOR_ESTIMATE , PGA_TARGET_FACTOR , ADVICE_STATUS , BYTES_PROCESSED , ESTD_EXTRA_BYTES_RW , ESTD_PGA_CACHE_HIT_PERCENTAGE , ESTD_OVERALLOC_COUNT ) SELECT :B3 , :B2 , :B1 , PGA_TARGET_FOR_ESTIMATE , PGA_TARGET_FACTOR , ADVICE_STATUS , BYTES_PROCESSED , ESTD_EXTRA_BYTES_RW , ESTD_PGA_CACHE_HIT_PERCENTAGE , ESTD_OVERALLOC_COUNT FROM V$PGA_TARGET_ADVICE WHERE ADVICE_STATUS = 'ON'
INSERT INTO STATS$SGASTAT ( SNAP_ID , DBID , INSTANCE_NUMBER , POOL , NAME , BYTES ) SELECT :B4 , :B3 , :B2 , POOL , NAME , BYTES FROM ( SELECT POOL , NAME , BYTES , 100*(BYTES) /(SUM(BYTES) OVER (PARTITION BY POOL)) PART_PCT FROM V$SGASTAT ) WHERE PART_PCT >= :B1 OR POOL IS NULL OR NAME = 'free memory'
INSERT INTO STATS$MUTEX_SLEEP ( SNAP_ID , DBID , INSTANCE_NUMBER , MUTEX_TYPE , LOCATION , SLEEPS , WAIT_TIME ) SELECT :B3 , :B2 , :B1 , MUTEX_TYPE , LOCATION , SLEEPS , WAIT_TIME FROM V$MUTEX_SLEEP WHERE MUTEX_TYPE IS NOT NULL AND SLEEPS > 0
INSERT INTO STATS$RULE_SET ( SNAP_ID , DBID , INSTANCE_NUMBER , OWNER , NAME , STARTUP_TIME , CPU_TIME , ELAPSED_TIME , EVALUATIONS , SQL_FREE_EVALUATIONS , SQL_EXECUTIONS , RELOADS ) SELECT :B3 , :B2 , :B1 , OWNER , NAME , FIRST_LOAD_TIME , CPU_TIME , ELAPSED_TIME , EVALUATIONS , SQL_FREE_EVALUATIONS , SQL_EXECUTIONS , RELOADS FROM V$RULE_SET
INSERT INTO STATS$TEMPSTATXS ( SNAP_ID , DBID , INSTANCE_NUMBER , TSNAME , FILENAME , PHYRDS , PHYWRTS , SINGLEBLKRDS , READTIM , WRITETIM , SINGLEBLKRDTIM , PHYBLKRD , PHYBLKWRT , WAIT_COUNT , TIME , FILE# ) SELECT :B3 , :B2 , :B1 , TSNAME , FILENAME , PHYRDS , PHYWRTS , SINGLEBLKRDS , READTIM , WRITETIM , SINGLEBLKRDTIM , PHYBLKRD , PHYBLKWRT , WAIT_COUNT , TIME , FILE# FROM STATS$V$TEMPSTATXS
select a.snap_level   value  from perfstat.stats$snapshot a where a.ucomment=:"SYS_B_0"
select	count(*) from perfstat.stats$snapshot
INSERT INTO STATS$DB_CACHE_ADVICE ( SNAP_ID , DBID , INSTANCE_NUMBER , ID , NAME , BLOCK_SIZE , BUFFERS_FOR_ESTIMATE , ADVICE_STATUS , SIZE_FOR_ESTIMATE , SIZE_FACTOR , ESTD_PHYSICAL_READ_FACTOR , ESTD_PHYSICAL_READS , ESTD_PHYSICAL_READ_TIME , ESTD_PCT_OF_DB_TIME_FOR_READS ) SELECT :B3 , :B2 , :B1 , ID , NAME , BLOCK_SIZE , BUFFERS_FOR_ESTIMATE , ADVICE_STATUS , SIZE_FOR_ESTIMATE , SIZE_FACTOR , ESTD_PHYSICAL_READ_FACTOR , ESTD_PHYSICAL_READS , ESTD_PHYSICAL_READ_TIME , ESTD_PCT_OF_DB_TIME_FOR_READS FROM V$DB_CACHE_ADVICE WHERE ADVICE_STATUS = 'ON'
INSERT INTO STATS$LIBRARYCACHE ( SNAP_ID , DBID , INSTANCE_NUMBER , NAMESPACE , GETS , GETHITS , PINS , PINHITS , RELOADS , INVALIDATIONS , DLM_LOCK_REQUESTS , DLM_PIN_REQUESTS , DLM_PIN_RELEASES , DLM_INVALIDATION_REQUESTS , DLM_INVALIDATIONS ) SELECT :B3 , :B2 , :B1 , NAMESPACE , GETS , GETHITS , PINS , PINHITS , RELOADS , INVALIDATIONS , DLM_LOCK_REQUESTS , DLM_PIN_REQUESTS , DLM_PIN_RELEASES , DLM_INVALIDATION_REQUESTS , DLM_INVALIDATIONS FROM V$LIBRARYCACHE
INSERT INTO STATS$STREAMS_APPLY_SUM ( SNAP_ID , DBID , INSTANCE_NUMBER , APPLY_NAME , STARTUP_TIME , READER_TOTAL_MESSAGES_DEQUEUED , READER_ELAPSED_DEQUEUE_TIME , READER_ELAPSED_SCHEDULE_TIME , COORD_TOTAL_RECEIVED , COORD_TOTAL_APPLIED , COORD_TOTAL_WAIT_DEPS , COORD_TOTAL_WAIT_COMMITS , COORD_ELAPSED_SCHEDULE_TIME , SERVER_TOTAL_MESSAGES_APPLIED , SERVER_ELAPSED_DEQUEUE_TIME , SERVER_ELAPSED_APPLY_TIME ) SELECT :B3 , :B2 , :B1 , MAX(C.APPLY_NAME) , MAX(C.STARTUP_TIME) , MAX(R.TOTAL_MESSAGES_DEQUEUED) , MAX(R.ELAPSED_DEQUEUE_TIME) , MAX(R.ELAPSED_SCHEDULE_TIME) , MAX(C.TOTAL_RECEIVED) , MAX(C.TOTAL_APPLIED) , MAX(C.TOTAL_WAIT_DEPS) , MAX(C.TOTAL_WAIT_COMMITS) , MAX(C.ELAPSED_SCHEDULE_TIME) , SUM(S.TOTAL_MESSAGES_APPLIED) , SUM(S.ELAPSED_DEQUEUE_TIME) , SUM(S.ELAPSED_APPLY_TIME) FROM V$STREAMS_APPLY_COORDINATOR C , V$STREAMS_APPLY_READER R , V$STREAMS_APPLY_SERVER S WHERE C.APPLY_NAME =
 R.APPLY_NAME AND C.APPLY_NAME = S.APPLY_NAME GROUP BY C.APPLY_NAME

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


196 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:19:04 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:19:04 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:19:05 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:19:05 2015

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

SQL> Connected.
SQL> SQL> 
no rows selected

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


R502000=0




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

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

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

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

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


R503001=0



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

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

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

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:19:05 2015

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

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

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


A: 104131944


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

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

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

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

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:19:05 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:19:05 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:19:05 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:19:05 2015

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

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

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


R600004=0


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


R101000: 0.1 full is 0.1 0.1
R102001: 0 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 full is 0.2 1.56
R201035: 0.2 full is 0.2 1.76
R201036: 0.2 full is 0.2 1.96
R201037: 0.2 full is 0.2 2.16
R201041: 0 full is 0.2 2.36
R201042: 0 full is 0.2 2.56
R201051: 0 full is 0.2 2.76
R201052: 0 full is 0.2 2.96
R201060: 0.44 full is 0.44 3.4
R201131: 0.2 full is 0.2 3.6
R201132: 0.2 full is 0.2 3.8
R201133: 0.2 full is 0.2 4.0
R201135: 0.2 full is 0.2 4.2
R201235: 0.2 full is 0.2 4.4
R301001: .8 full is 0.8 5.2
R301002: .2 full is 0.2 5.4
R302001: 0.15 full is 0.15 5.55
R302002: 0.15 full is 0.15 5.7
R302003: 0.15 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: 0 full is 2 18.0
R503001: 0 full is 0.3 18.3
R503002: 0.8 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:
13.50


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