

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** 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_SID=PROD
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export OMS_HOME=$ORACLE_BASE/OracleHomes/oms10g
export AGENT_HOME=$ORACLE_BASE/OracleHomes/agent10g
export PATH=$ORACLE_HOME/bin:$PATH
export LANG=en_US
export JAVA_HOME=$ORACLE_HOME/jdk
export PATH=$JAVA_HOME/bin:$ORACLE_HOME/bin:$PATH


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

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

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

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

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


R101000=0.1


A: TRUE


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

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

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

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

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


R102001=0.1


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


R102002=0.2




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


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


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 17 00:20:55 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
CREATE CLUSTER
CREATE DIMENSION
CREATE VIEW
QUERY REWRITE

PRIVILEGE
----------------------------------------
CREATE MATERIALIZED VIEW

12 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


A: 0


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

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

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

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

7 rows selected.

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


R201021=0.1


A: OLTP

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

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

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

7 rows selected.

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


R201022=0.1


A: DSS

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

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

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

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


R201023=0.03


A: OLTP

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

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

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

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


R201024=0.03


A: DSS


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


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

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

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

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

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


R201031=0.2



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

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

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

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


R201131=0.2




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

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

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

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

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


R201032=0.2



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

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

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

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


R201132=0.2




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

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

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

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


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


R201133=0




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

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

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

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

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


R201034=0.2




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

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

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

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

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


R201235=0.2




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

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

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

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

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


R201036=0.2




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

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

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

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

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


R201037=0.2




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

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

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

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

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


R201041=0.2


A: OLTP_USER

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

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

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

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


R201042=0.2


A: YES


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

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

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

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

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


R201051=0.2


A: SH

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

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

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

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


R201052=0.2


A: YES


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

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

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

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

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


R201060=0.44


A: WEEKDAYS


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


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

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

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

SQL> Connected.
SQL> SQL> SQL> SQL> 
TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select "OWNER","NAME","DB_LINK","NAMESPACE","TYPE","SHARABLE_MEM","LOADS","EXECUTIONS","LOCKS","PINS","KEPT","CHILD_LATCH","INVALIDATIONS" from  v$db_object_cache where TYPE in ('PACKAGES','PROCEDURES','TRIGGERS','FUNCTIONS') AND SHARABLE_MEM > 51200

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


A: 0
R301002=0


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

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

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

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

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


R302002=0.15



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

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

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

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


R302004=0.15




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

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

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

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

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


R303001=0



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

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

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

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


R303002=0




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

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

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

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

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


R304001=0.1



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

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

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

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


R304002=0.1




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


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

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

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

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

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


R401001=0.5


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

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

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

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

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

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

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

SQL> Connected.
SQL> SQL> 
Explained.

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

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


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

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

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

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


R402001=0


A: 0

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

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

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


R402002=0


A: 0

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

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

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


R402003=0


A: 0

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

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

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


R402004=0


A: 0


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

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

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

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

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


R403001=0.03


A:  STUD_ID																																																																									   NOT NULL NUMBER

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

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

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

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


R403001=.06


B:  FNAME																																																																											    VARCHAR2(20)

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

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

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

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


R403001=.09


C:  LNAME																																																																											    VARCHAR2(20)

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

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

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

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


R403002=0.03


A:  STUD_ID																																																																									   NOT NULL NUMBER

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

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

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

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


R403002=.06


B:  CLASS_ID																																																																									   NOT NULL NUMBER

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

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

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

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


R403003=0.03


A: P

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

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

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

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


R403004=0.03


A: P

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

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

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

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


R403005=0.03


A: R

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

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

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

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


R403006=0.03


A: P

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

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

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

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


R403007=0.03


A: R

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

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

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

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


R403008=0.6


A: IOT - TOP

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

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

SQL> Connected.
SQL> SQL> 
COLUMN_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CLASS_ID
STUD_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 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CLASS_ID STUD_ID  SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, OLAP and Data Mining options 


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

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

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

SQL> Connected.
SQL> SQL>   2  
 ANALYZEDT
----------
.101898148

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


R404001=0.5



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

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

SQL> Connected.
SQL> SQL>   2  
 ANALYZEDT
----------
.101898148

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


A: 101898148

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

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

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

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


R404002=0.2



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

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

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

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


R404003=0.3




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

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

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

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

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


R405000=0.8


A: BITMAP


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

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

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

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

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


R406001=0.7



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

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

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

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


R406002=0.3


A: ENABLED

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

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

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

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


R406003=0.1




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

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

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

SQL> Connected.
SQL> SQL> 
KEP
---
YES

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


A: YES

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

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

SQL> Connected.
SQL> SQL> 
KEP
---
YES

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


A: YES


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

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

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

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

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


R408000=0.5


A: SIMILAR


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

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

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

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

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


R409001=1


A: AUTO

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

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

SQL> Connected.
SQL> SQL> 
SEGMENT_NAME
---------------------------------------------------------------------------------
T1
T2
T1_ID

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


R409002=0.2


A: T1

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

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

SQL> Connected.
SQL> SQL> 
SEGMENT_NAME
---------------------------------------------------------------------------------
T1
T2
T1_ID

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


R409002=.4


B: T2

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

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

SQL> Connected.
SQL> SQL> 
SEGMENT_NAME
---------------------------------------------------------------------------------
T1
T2
T1_ID

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


R409002=.6


C: T1_ID


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

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

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

SQL> Connected.
SQL> SQL> SQL> SQL> 
SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT c.cust_id, SUM(amount_sold) FROM  sh.sales s, sh.customers c  WHERE s.cust_id = c.cust_id GROUP BY c.cust_id
 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

 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_BSLN_METRICS" 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("METRIC_UID")),substrb(dump(min("METRIC_UID"),16,0,32),1,120),substrb(dump(max("METRIC_UID"),16,0,32),1,120),count(distinct "TAIL_ESTIMATOR"),sum(sys_op_opnsize("TAIL_ESTIMATOR")),substrb(dump(min("TAIL_ESTIMATOR"),16,0,32),1,120),substrb(dump(max("TAIL_ESTIMATOR"),16,0,32),1,120),count(distinct "THRESHOLD_METHOD_DEFAULT"),sum(sys_op_opnsize("THRESHOLD_METHOD_DEFAULT")),substrb(dump(min("THRESHOLD_METHOD_DEFAULT"),16,0,32),1,120),substrb(dump(max("THRESHOLD_METHOD_DEFAULT"),16,0,32),1,120),count(distinct "NUM_OCCURRENCES_DEFAULT"),sum(sys_op_opnsize("NUM_OCCURRENCES_DEFAULT")),substrb(dump(min("NUM_OCCURRENCES_DEFAULT"),16,0,32),1,120),substrb(dump(max("NUM_OCCURRENCES_DEFAULT"),16,0,32),1,120),count(distinct "WARNING_PARAM_DEF
AULT"),sum(sys_op_opnsize("WARNING_PARAM_DEFAULT")),substrb(dump(min("WARNING_PARAM_DEFAULT"),16,0,32),1,120),substrb(dump(max("WARNING_PARAM_DEFAULT"),16,0,32),1,120),count(distinct "CRITICAL_PARAM_DEFAULT"),sum(sys_op_opnsize("CRITICAL_PARAM_DEFAULT")),substrb(dump(min("CRITICAL_PARAM_DEFAULT"),16,0,32),1,120),substrb(dump(max("CRITICAL_PARAM_DEFAULT"),16,0,32),1,120) from "DBSNMP"."MGMT_BSLN_METRICS" t

select /*+ no_parallel_index(t,"BSLN_METRICS_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"BSLN_METRICS_PK") */ count(*) as nrw,count(distinct sys_op_lbid(9651,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "DBSNMP"."MGMT_BSLN_METRICS" t where "METRIC_UID" 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_RESPONSE_CONFIG" 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("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 "HR"."COUNTRIES" t
select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*),substrb(dump(min("COUNTRY_ID"),16,0,32),1,120),substrb(dump(max("COUNTRY_ID"),16,0,32),1,120),count("COUNTRY_NAME"),count(distinct "COUNTRY_NAME"),sum(sys_op_opnsize("COUNTRY_NAME")),substrb(dump(min(substrb("COUNTRY_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("COUNTRY_NAME",1,32)),16,0,32),1,120),count("REGION_ID"),sum(sys_op_opnsize("REGION_ID")) from "HR"."COUNTRIES" t
select /*+ no_parallel_index(t,"COUNTRY_C_ID_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index_ffs(t,"COUNTRY_C_ID_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11701,'L',t.rowid)) as nlb,null as ndk,null as clf from "HR"."COUNTRIES" t where "COUNTRY_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 "HR"."DEPARTMENTS" 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("DEPARTMENT_ID")),substrb(dump(min("DEPARTMENT_ID"),16,0,32),1,120),substrb(dump(max("DEPARTMENT_ID"),16,0,32),1,120),count(distinct "DEPARTMENT_NAME"),sum(sys_op_opnsize("DEPARTMENT_NAME")),substrb(dump(min("DEPARTMENT_NAME"),16,0,32),1,120),substrb(dump(max("DEPARTMENT_NAME"),16,0,32),1,120),count("MANAGER_ID"),sum(sys_op_opnsize("MANAGER_ID")),count("LOCATION_ID"),sum(sys_op_opnsize("LOCATION_ID")) from "HR"."DEPARTMENTS" t
select /*+ no_parallel_index(t,"DEPT_LOCATION_IX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"DEPT_LOCATION_IX") */ count(*) as nrw,count(distinct sys_op_lbid(11714,'L',t.rowid)) as nlb,count(distinct "LOCATION_ID") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."DEPARTMENTS" t where "LOCATION_ID" is not null
select /*+ no_parallel_index(t,"DEPT_ID_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"DEPT_ID_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11713,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."DEPARTMENTS" t where "DEPARTMENT_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 "HR"."EMPLOYEES" 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("EMPLOYEE_ID")),substrb(dump(min("EMPLOYEE_ID"),16,0,32),1,120),substrb(dump(max("EMPLOYEE_ID"),16,0,32),1,120),count("FIRST_NAME"),count(distinct "FIRST_NAME"),sum(sys_op_opnsize("FIRST_NAME")),substrb(dump(min("FIRST_NAME"),16,0,32),1,120),substrb(dump(max("FIRST_NAME"),16,0,32),1,120),count(distinct "LAST_NAME"),sum(sys_op_opnsize("LAST_NAME")),substrb(dump(min("LAST_NAME"),16,0,32),1,120),substrb(dump(max("LAST_NAME"),16,0,32),1,120),sum(sys_op_opnsize("EMAIL")),substrb(dump(min("EMAIL"),16,0,32),1,120),substrb(dump(max("EMAIL"),16,0,32),1,120),count("PHONE_NUMBER"),count(distinct "PHONE_NUMBER"),sum(sys_op_opnsize("PHONE_NUMBER")),substrb(dump(min("PHONE_NUMBER"),16,0,32),1,120),substrb(dump(max("PHONE_NUMBER"),16,0,32),1,

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
120),count(distinct "HIRE_DATE"),substrb(dump(min("HIRE_DATE"),16,0,32),1,120),substrb(dump(max("HIRE_DATE"),16,0,32),1,120),sum(sys_op_opnsize("JOB_ID")),count("SALARY"),sum(sys_op_opnsize("SALARY")),count("COMMISSION_PCT"),count(distinct "COMMISSION_PCT"),sum(sys_op_opnsize("COMMISSION_PCT")),substrb(dump(min("COMMISSION_PCT"),16,0,32),1,120),substrb(dump(max("COMMISSION_PCT"),16,0,32),1,120),count("MANAGER_ID"),sum(sys_op_opnsize("MANAGER_ID")),count("DEPARTMENT_ID"),sum(sys_op_opnsize("DEPARTMENT_ID")) from "HR"."EMPLOYEES" t

select /*+ no_parallel_index(t,"EMP_EMAIL_UK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"EMP_EMAIL_UK") */ count(*) as nrw,count(distinct sys_op_lbid(11716,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."EMPLOYEES" t where "EMAIL" is not null
select /*+ no_parallel_index(t,"EMP_EMP_ID_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"EMP_EMP_ID_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11717,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."EMPLOYEES" t where "EMPLOYEE_ID" is not null
select /*+ no_parallel_index(t,"EMP_DEPARTMENT_IX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"EMP_DEPARTMENT_IX") */ count(*) as nrw,count(distinct sys_op_lbid(11718,'L',t.rowid)) as nlb,count(distinct "DEPARTMENT_ID") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."EMPLOYEES" t where "DEPARTMENT_ID" is not null
select /*+ no_parallel_index(t,"EMP_JOB_IX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"EMP_JOB_IX") */ count(*) as nrw,count(distinct sys_op_lbid(11719,'L',t.rowid)) as nlb,count(distinct "JOB_ID") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."EMPLOYEES" t where "JOB_ID" is not null
select /*+ no_parallel_index(t,"EMP_MANAGER_IX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"EMP_MANAGER_IX") */ count(*) as nrw,count(distinct sys_op_lbid(11720,'L',t.rowid)) as nlb,count(distinct "MANAGER_ID") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."EMPLOYEES" t where "MANAGER_ID" is not null
select /*+ no_parallel_index(t,"EMP_NAME_IX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"EMP_NAME_IX") */ count(*) as nrw,count(distinct sys_op_lbid(11721,'L',t.rowid)) as nlb,count(distinct hextoraw(sys_op_descend("LAST_NAME")||sys_op_descend("FIRST_NAME"))) as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."EMPLOYEES" t where "LAST_NAME" is not null or "FIRST_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 "HR"."JOBS" 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("JOB_ID")),substrb(dump(min("JOB_ID"),16,0,32),1,120),substrb(dump(max("JOB_ID"),16,0,32),1,120),count(distinct "JOB_TITLE"),sum(sys_op_opnsize("JOB_TITLE")),substrb(dump(min(substrb("JOB_TITLE",1,32)),16,0,32),1,120),substrb(dump(max(substrb("JOB_TITLE",1,32)),16,0,32),1,120),count("MIN_SALARY"),count(distinct "MIN_SALARY"),sum(sys_op_opnsize("MIN_SALARY")),substrb(dump(min("MIN_SALARY"),16,0,32),1,120),substrb(dump(max("MIN_SALARY"),16,0,32),1,120),count("MAX_SALARY"),count(distinct "MAX_SALARY"),sum(sys_op_opnsize("MAX_SALARY")),substrb(dump(min("MAX_SALARY"),16,0,32),1,120),substrb(dump(max("MAX_SALARY"),16,0,32),1,120) from "HR"."JOBS" t
select /*+ no_parallel_index(t,"JOB_ID_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"JOB_ID_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11715,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."JOBS" t where "JOB_ID" is not null

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*)  from "HR"."JOB_HISTORY" 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("EMPLOYEE_ID")),count(distinct "START_DATE"),substrb(dump(min("START_DATE"),16,0,32),1,120),substrb(dump(max("START_DATE"),16,0,32),1,120),count(distinct "END_DATE"),substrb(dump(min("END_DATE"),16,0,32),1,120),substrb(dump(max("END_DATE"),16,0,32),1,120),sum(sys_op_opnsize("JOB_ID")),count("DEPARTMENT_ID"),sum(sys_op_opnsize("DEPARTMENT_ID")) from "HR"."JOB_HISTORY" t
select /*+ no_parallel_index(t,"JHIST_EMP_ID_ST_DATE_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"JHIST_EMP_ID_ST_DATE_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11722,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."JOB_HISTORY" t where "EMPLOYEE_ID" is not null or "START_DATE" is not null
select /*+ no_parallel_index(t,"JHIST_JOB_IX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"JHIST_JOB_IX") */ count(*) as nrw,count(distinct sys_op_lbid(11723,'L',t.rowid)) as nlb,count(distinct "JOB_ID") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."JOB_HISTORY" t where "JOB_ID" is not null
select /*+ no_parallel_index(t,"JHIST_EMPLOYEE_IX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"JHIST_EMPLOYEE_IX") */ count(*) as nrw,count(distinct sys_op_lbid(11724,'L',t.rowid)) as nlb,count(distinct "EMPLOYEE_ID") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."JOB_HISTORY" t where "EMPLOYEE_ID" is not null
select /*+ no_parallel_index(t,"JHIST_DEPARTMENT_IX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"JHIST_DEPARTMENT_IX") */ count(*) as nrw,count(distinct sys_op_lbid(11725,'L',t.rowid)) as nlb,count(distinct "DEPARTMENT_ID") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."JOB_HISTORY" t where "DEPARTMENT_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 "HR"."LOCATIONS" 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("LOCATION_ID")),substrb(dump(min("LOCATION_ID"),16,0,32),1,120),substrb(dump(max("LOCATION_ID"),16,0,32),1,120),count("STREET_ADDRESS"),count(distinct "STREET_ADDRESS"),sum(sys_op_opnsize("STREET_ADDRESS")),substrb(dump(min(substrb("STREET_ADDRESS",1,32)),16,0,32),1,120),substrb(dump(max(substrb("STREET_ADDRESS",1,32)),16,0,32),1,120),count("POSTAL_CODE"),count(distinct "POSTAL_CODE"),sum(sys_op_opnsize("POSTAL_CODE")),substrb(dump(min("POSTAL_CODE"),16,0,32),1,120),substrb(dump(max("POSTAL_CODE"),16,0,32),1,120),count(distinct "CITY"),sum(sys_op_opnsize("CITY")),substrb(dump(min("CITY"),16,0,32),1,120),substrb(dump(max("CITY"),16,0,32),1,120),count("STATE_PROVINCE"),count(distinct "STATE_PROVINCE"),sum(sys_op_opnsize("STATE_PR
OVINCE")),substrb(dump(min("STATE_PROVINCE"),16,0,32),1,120),substrb(dump(max("STATE_PROVINCE"),16,0,32),1,120),count("COUNTRY_ID") from "HR"."LOCATIONS" t

select /*+ no_parallel_index(t,"LOC_ID_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"LOC_ID_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11709,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."LOCATIONS" t where "LOCATION_ID" is not null

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select /*+ no_parallel_index(t,"LOC_CITY_IX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"LOC_CITY_IX") */ count(*) as nrw,count(distinct sys_op_lbid(11710,'L',t.rowid)) as nlb,count(distinct "CITY") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."LOCATIONS" t where "CITY" is not null
select /*+ no_parallel_index(t,"LOC_STATE_PROVINCE_IX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"LOC_STATE_PROVINCE_IX") */ count(*) as nrw,count(distinct sys_op_lbid(11711,'L',t.rowid)) as nlb,count(distinct "STATE_PROVINCE") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."LOCATIONS" t where "STATE_PROVINCE" is not null
select /*+ no_parallel_index(t,"LOC_COUNTRY_IX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"LOC_COUNTRY_IX") */ count(*) as nrw,count(distinct sys_op_lbid(11712,'L',t.rowid)) as nlb,count(distinct "COUNTRY_ID") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."LOCATIONS" t where "COUNTRY_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 "HR"."REGIONS" 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("REGION_ID")),substrb(dump(min("REGION_ID"),16,0,32),1,120),substrb(dump(max("REGION_ID"),16,0,32),1,120),count("REGION_NAME"),count(distinct "REGION_NAME"),sum(sys_op_opnsize("REGION_NAME")),substrb(dump(min("REGION_NAME"),16,0,32),1,120),substrb(dump(max("REGION_NAME"),16,0,32),1,120) from "HR"."REGIONS" t
select /*+ no_parallel_index(t,"REG_ID_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"REG_ID_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11708,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HR"."REGIONS" t where "REGION_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 "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(12053,'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(12054,'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
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(12055,'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

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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(12056,'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$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(12360,'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$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(12164,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "PERFSTAT"."STATS$LEVEL_DESCRIPTION" t where "SNAP_LEVEL" is not null
 select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*)  from "SH"."CAL_MONTH_SALES_MV" 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 "CALENDAR_MONTH_DESC"),sum(sys_op_opnsize("CALENDAR_MONTH_DESC")),substrb(dump(min("CALENDAR_MONTH_DESC"),16,0,32),1,120),substrb(dump(max("CALENDAR_MONTH_DESC"),16,0,32),1,120),count("DOLLARS"),count(distinct "DOLLARS"),sum(sys_op_opnsize("DOLLARS")),substrb(dump(min("DOLLARS"),16,0,32),1,120),substrb(dump(max("DOLLARS"),16,0,32),1,120) from "SH"."CAL_MONTH_SALES_MV" 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"."CHANNELS" 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("CHANNEL_ID")),substrb(dump(min("CHANNEL_ID"),16,0,32),1,120),substrb(dump(max("CHANNEL_ID"),16,0,32),1,120),count(distinct "CHANNEL_DESC"),sum(sys_op_opnsize("CHANNEL_DESC")),substrb(dump(min("CHANNEL_DESC"),16,0,32),1,120),substrb(dump(max("CHANNEL_DESC"),16,0,32),1,120),count(distinct "CHANNEL_CLASS"),sum(sys_op_opnsize("CHANNEL_CLASS")),substrb(dump(min("CHANNEL_CLASS"),16,0,32),1,120),substrb(dump(max("CHANNEL_CLASS"),16,0,32),1,120),count(distinct "CHANNEL_CLASS_ID"),sum(sys_op_opnsize("CHANNEL_CLASS_ID")),substrb(dump(min("CHANNEL_CLASS_ID"),16,0,32),1,120),substrb(dump(max("CHANNEL_CLASS_ID"),16,0,32),1,120),count(distinct "CHANNEL_TOTAL"),sum(sys_op_opnsize("CHANNEL_TOTAL")),substrb(dump(min("CHANNEL_TOTAL"),16,0,32),1

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
,120),substrb(dump(max("CHANNEL_TOTAL"),16,0,32),1,120),count(distinct "CHANNEL_TOTAL_ID"),sum(sys_op_opnsize("CHANNEL_TOTAL_ID")),substrb(dump(min("CHANNEL_TOTAL_ID"),16,0,32),1,120),substrb(dump(max("CHANNEL_TOTAL_ID"),16,0,32),1,120) from "SH"."CHANNELS" t

select /*+ no_parallel_index(t,"CHANNELS_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"CHANNELS_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11825,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SH"."CHANNELS" t where "CHANNEL_ID" is not null
 select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*)  from "SH"."COSTS" t where TBL$OR$IDX$PART$NUM("SH"."COSTS",0,4,0,"ROWID") = :objn
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 "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(distinct "TIME_ID"),substrb(dump(min("TIME_ID"),16,0,32),1,120),substrb(dump(max("TIME_ID"),16,0,32),1,120),count(distinct "PROMO_ID"),sum(sys_op_opnsize("PROMO_ID")),substrb(dump(min("PROMO_ID"),16,0,32),1,120),substrb(dump(max("PROMO_ID"),16,0,32),1,120),count(distinct "CHANNEL_ID"),sum(sys_op_opnsize("CHANNEL_ID")),substrb(dump(min("CHANNEL_ID"),16,0,32),1,120),substrb(dump(max("CHANNEL_ID"),16,0,32),1,120),count(distinct "UNIT_COST"),sum(sys_op_opnsize("UNIT_COST")),substrb(dump(min("UNIT_COST"),16,0,32),1,120),substrb(dump(max("UNIT_COST"),16,0,32),1,120),count(distinct "UNIT_PRICE"),sum(sys_o
p_opnsize("UNIT_PRICE")),substrb(dump(min("UNIT_PRICE"),16,0,32),1,120),substrb(dump(max("UNIT_PRICE"),16,0,32),1,120) from "SH"."COSTS" t  where TBL$OR$IDX$PART$NUM("SH"."COSTS",0,4,0,"ROWID") = :objn

 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"."COSTS" 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 "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(distinct "TIME_ID"),substrb(dump(min("TIME_ID"),16,0,32),1,120),substrb(dump(max("TIME_ID"),16,0,32),1,120),count(distinct "PROMO_ID"),sum(sys_op_opnsize("PROMO_ID")),substrb(dump(min("PROMO_ID"),16,0,32),1,120),substrb(dump(max("PROMO_ID"),16,0,32),1,120),count(distinct "CHANNEL_ID"),sum(sys_op_opnsize("CHANNEL_ID")),substrb(dump(min("CHANNEL_ID"),16,0,32),1,120),substrb(dump(max("CHANNEL_ID"),16,0,32),1,120),count(distinct "UNIT_COST"),sum(sys_op_opnsize("UNIT_COST")),substrb(dump(min("UNIT_COST"),16,0,32),1,120),substrb(dump(max("UNIT_COST"),16,0,32),1,120),count(distinct "UNIT_PRICE"),sum(sys_o
p_opnsize("UNIT_PRICE")),substrb(dump(min("UNIT_PRICE"),16,0,32),1,120),substrb(dump(max("UNIT_PRICE"),16,0,32),1,120) from "SH"."COSTS" sample (  6.6981683554) t


SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select /*+ no_parallel_index(t,"COSTS_PROD_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"COSTS_PROD_BIX") */ count(distinct sys_op_lbid(11975,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(11975,'L',t.rowid)) as nlb,count(distinct "PROD_ID") as ndk,null as clf from "SH"."COSTS" t where TBL$OR$IDX$PART$NUM("SH"."COSTS",0,4,0,"ROWID") = :objn
select /*+ no_parallel_index(t,"COSTS_PROD_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"COSTS_PROD_BIX") */ count(distinct sys_op_lbid(11975,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(11975,'L',t.rowid)) as nlb,count(distinct "PROD_ID") as ndk,null as clf from "SH"."COSTS" t
select /*+ no_parallel_index(t,"COSTS_TIME_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"COSTS_TIME_BIX") */ count(distinct sys_op_lbid(12004,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(12004,'L',t.rowid)) as nlb,count(distinct "TIME_ID") as ndk,null as clf from "SH"."COSTS" t where TBL$OR$IDX$PART$NUM("SH"."COSTS",0,4,0,"ROWID") = :objn
select /*+ no_parallel_index(t,"COSTS_TIME_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"COSTS_TIME_BIX") */ count(distinct sys_op_lbid(12004,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(12004,'L',t.rowid)) as nlb,count(distinct "TIME_ID") as ndk,null as clf from "SH"."COSTS" 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"."COUNTRIES" 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("COUNTRY_ID")),substrb(dump(min("COUNTRY_ID"),16,0,32),1,120),substrb(dump(max("COUNTRY_ID"),16,0,32),1,120),count(distinct "COUNTRY_ISO_CODE"),substrb(dump(min("COUNTRY_ISO_CODE"),16,0,32),1,120),substrb(dump(max("COUNTRY_ISO_CODE"),16,0,32),1,120),count(distinct "COUNTRY_NAME"),sum(sys_op_opnsize("COUNTRY_NAME")),substrb(dump(min(substrb("COUNTRY_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("COUNTRY_NAME",1,32)),16,0,32),1,120),count(distinct "COUNTRY_SUBREGION"),sum(sys_op_opnsize("COUNTRY_SUBREGION")),substrb(dump(min("COUNTRY_SUBREGION"),16,0,32),1,120),substrb(dump(max("COUNTRY_SUBREGION"),16,0,32),1,120),count(distinct "COUNTRY_SUBREGION_ID"),sum(sys_op_opnsize("COUNTRY_SUBREGION_ID")),substrb(dump(min("COUNTRY_
SUBREGION_ID"),16,0,32),1,120),substrb(dump(max("COUNTRY_SUBREGION_ID"),16,0,32),1,120),count(distinct "COUNTRY_REGION"),sum(sys_op_opnsize("COUNTRY_REGION")),substrb(dump(min("COUNTRY_REGION"),16,0,32),1,120),substrb(dump(max("COUNTRY_REGION"),16,0,32),1,120),count(distinct "COUNTRY_REGION_ID"),sum(sys_op_opnsize("COUNTRY_REGION_ID")),substrb(dump(min("COUNTRY_REGION_ID"),16,0,32),1,120),substrb(dump(max("COUNTRY_REGION_ID"),16,0,32),1,120),count(distinct "COUNTRY_TOTAL"),sum(sys_op_opnsize("COUNTRY_TOTAL")),substrb(dump(min("COUNTRY_TOTAL"),16,0,32),1,120),substrb(dump(max("COUNTRY_TOTAL"),16,0,32),1,120),count(distinct "COUNTRY_TOTAL_ID"),sum(sys_op_opnsize("COUNTRY_TOTAL_ID")),substrb(dump(min("COUNTRY_TOTAL_ID"),16,0,32),1,120),substrb(dump(max("COUNTRY_TOTAL_ID"),16,0,32),1,120),count("COUNTRY_NAME_HIST"),count(distinct "COUNTRY_NAME_HIST"),sum(sys_op_opnsize("COUNTRY_NAME_HIST")),
substrb(dump(min(substrb("COUNTRY_NAME_HIST",1,32)),16,0,32),1,120),substrb(dump(max(substrb("COUNTRY_NAME_HIST",1,32)),16,0,32),1,120) from "SH"."COUNTRIES" t

select /*+ no_parallel_index(t,"COUNTRIES_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"COUNTRIES_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11828,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SH"."COUNTRIES" t where "COUNTRY_ID" is not null
 select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*)  from "SH"."CUSTOMERS" sample block (	6.7658998647,1) 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 "SH"."CUSTOMERS" t
select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*),sum(sys_op_opnsize("CUST_ID")),substrb(dump(min("CUST_ID"),16,0,32),1,120),substrb(dump(max("CUST_ID"),16,0,32),1,120),count(distinct "CUST_FIRST_NAME"),sum(sys_op_opnsize("CUST_FIRST_NAME")),substrb(dump(min("CUST_FIRST_NAME"),16,0,32),1,120),substrb(dump(max("CUST_FIRST_NAME"),16,0,32),1,120),count(distinct "CUST_LAST_NAME"),sum(sys_op_opnsize("CUST_LAST_NAME")),substrb(dump(min(substrb("CUST_LAST_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("CUST_LAST_NAME",1,32)),16,0,32),1,120),count(distinct "CUST_GENDER"),substrb(dump(min("CUST_GENDER"),16,0,32),1,120),substrb(dump(max("CUST_GENDER"),16,0,32),1,120),count(distinct "CUST_YEAR_OF_BIRTH"),sum(sys_op_opnsize("CUST_YEAR_OF_BIRTH")),substrb(dump(min("CUST_YEAR_OF_BIRTH"),16,0,32),1,120)
,substrb(dump(max("CUST_YEAR_OF_BIRTH"),16,0,32),1,120),count("CUST_MARITAL_STATUS"),count(distinct "CUST_MARITAL_STATUS"),sum(sys_op_opnsize("CUST_MARITAL_STATUS")),substrb(dump(min("CUST_MARITAL_STATUS"),16,0,32),1,120),substrb(dump(max("CUST_MARITAL_STATUS"),16,0,32),1,120),count(distinct "CUST_STREET_ADDRESS"),sum(sys_op_opnsize("CUST_STREET_ADDRESS")),substrb(dump(min(substrb("CUST_STREET_ADDRESS",1,32)),16,0,32),1,120),substrb(dump(max(substrb("CUST_STREET_ADDRESS",1,32)),16,0,32),1,120),count(distinct "CUST_POSTAL_CODE"),sum(sys_op_opnsize("CUST_POSTAL_CODE")),substrb(dump(min("CUST_POSTAL_CODE"),16,0,32),1,120),substrb(dump(max("CUST_POSTAL_CODE"),16,0,32),1,120),count(distinct "CUST_CITY"),sum(sys_op_opnsize("CUST_CITY")),substrb(dump(min("CUST_CITY"),16,0,32),1,120),substrb(dump(max("CUST_CITY"),16,0,32),1,120),count(distinct "CUST_CITY_ID"),sum(sys_op_opnsize("CUST_CITY_ID")),
substrb(dump(min("CUST_CITY_ID"),16,0,32),1,120),substrb(dump(max("CUST_CITY_ID"),16,0,32),1,120),count(distinct "CUST_STATE_PROVINCE"),sum(sys_op_opnsize("CUST_STATE_PROVINCE")),substrb(dump(min(substrb("CUST_STATE_PROVINCE",1,32)),16,0,32),1,120),substrb(dump(max(substrb("CUST_STATE_PROVINCE",1,32)),16,0,32),1,120),count(distinct "CUST_STATE_PROVINCE_ID"),sum(sys_op_opnsize("CUST_STATE_PROVINCE_ID")),substrb(dump(min("CUST_STATE_PROVINCE_ID"),16,0,32),1,120),substrb(dump(max("CUST_STATE_PROVINCE_ID"),16,0,32),1,120),count(distinct "COUNTRY_ID"),sum(sys_op_opnsize("COUNTRY_ID")),substrb(dump(min("COUNTRY_ID"),16,0,32),1,120),substrb(dump(max("COUNTRY_ID"),16,0,32),1,120),count(distinct "CUST_MAIN_PHONE_NUMBER"),sum(sys_op_opnsize("CUST_MAIN_PHONE_NUMBER")),substrb(dump(min("CUST_MAIN_PHONE_NUMBER"),16,0,32),1,120),substrb(dump(max("CUST_MAIN_PHONE_NUMBER"),16,0,32),1,120),count("CUST_IN
COME_LEVEL"),count(distinct "CUST_INCOME_LEVEL"),sum(sys_op_opnsize("CUST_INCOME_LEVEL")),substrb(dump(min("CUST_INCOME_LEVEL"),16,0,32),1,120),substrb(dump(max("CUST_INCOME_LEVEL"),16,0,32),1,120),count("CUST_CREDIT_LIMIT"),count(distinct "CUST_CREDIT_LIMIT"),sum(sys_op_opnsize("CUST_CREDIT_LIMIT")),substrb(dump(min("CUST_CREDIT_LIMIT"),16,0,32),1,120),substrb(dump(max("CUST_CREDIT_LIMIT"),16,0,32),1,120),count("CUST_EMAIL"),count(distinct "CUST_EMAIL"),sum(sys_op_opnsize("CUST_EMAIL")),substrb(dump(min("CUST_EMAIL"),16,0,32),1,120),substrb(dump(max("CUST_EMAIL"),16,0,32),1,120),count(distinct "CUST_TOTAL"),sum(sys_op_opnsize("CUST_TOTAL")),substrb(dump(min("CUST_TOTAL"),16,0,32),1,120),substrb(dump(max("CUST_TOTAL"),16,0,32),1,120),count(distinct "CUST_TOTAL_ID"),sum(sys_op_opnsize("CUST_TOTAL_ID")),substrb(dump(min("CUST_TOTAL_ID"),16,0,32),1,120),substrb(dump(max("CUST_TOTAL_ID"),16,
0,32),1,120),count("CUST_SRC_ID"),count(distinct "CUST_SRC_ID"),sum(sys_op_opnsize("CUST_SRC_ID")),substrb(dump(min("CUST_SRC_ID"),16,0,32),1,120),substrb(dump(max("CUST_SRC_ID"),16,0,32),1,120),count("CUST_EFF_FROM"),count(distinct "CUST_EFF_FROM"),substrb(dump(min("CUST_EFF_FROM"),16,0,32),1,120),substrb(dump(max("CUST_EFF_FROM"),16,0,32),1,120),count("CUST_EFF_TO"),count(distinct "CUST_EFF_TO"),substrb(dump(min("CUST_EFF_TO"),16,0,32),1,120),substrb(dump(max("CUST_EFF_TO"),16,0,32),1,120),count("CUST_VALID"),count(distinct "CUST_VALID"),sum(sys_op_opnsize("CUST_VALID")),substrb(dump(min("CUST_VALID"),16,0,32),1,120),substrb(dump(max("CUST_VALID"),16,0,32),1,120),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_L
AST_NAME"),1,32)),16,0,32),1,120) from "SH"."CUSTOMERS" sample (  9.9099099099) 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 "CUST_STREET_ADDRESS"),count(distinct "CUST_MAIN_PHONE_NUMBER"),count("CUST_SRC_ID"),count(distinct "CUST_SRC_ID"),sum(sys_op_opnsize("CUST_SRC_ID")),substrb(dump(min("CUST_SRC_ID"),16,0,32),1,120),substrb(dump(max("CUST_SRC_ID"),16,0,32),1,120),count("CUST_EFF_TO"),count(distinct "CUST_EFF_TO"),substrb(dump(min("CUST_EFF_TO"),16,0,32),1,120),substrb(dump(max("CUST_EFF_TO"),16,0,32),1,120) from "SH"."CUSTOMERS" t
select /*+ no_parallel_index(t,"CUSTOMERS_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"CUSTOMERS_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11827,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SH"."CUSTOMERS" t where "CUST_ID" is not null
select /*+ no_parallel_index(t,"CUSTOMERS_GENDER_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"CUSTOMERS_GENDER_BIX") */ count(distinct sys_op_lbid(12034,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(12034,'L',t.rowid)) as nlb,count(distinct "CUST_GENDER") as ndk,null as clf from "SH"."CUSTOMERS" t

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select /*+ no_parallel_index(t,"CUSTOMERS_MARITAL_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"CUSTOMERS_MARITAL_BIX") */ count(distinct sys_op_lbid(12035,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(12035,'L',t.rowid)) as nlb,count(distinct "CUST_MARITAL_STATUS") as ndk,null as clf from "SH"."CUSTOMERS" t
select /*+ no_parallel_index(t,"CUSTOMERS_YOB_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"CUSTOMERS_YOB_BIX") */ count(distinct sys_op_lbid(12036,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(12036,'L',t.rowid)) as nlb,count(distinct "CUST_YEAR_OF_BIRTH") as ndk,null as clf from "SH"."CUSTOMERS" t
select /*+ no_parallel_index(t,"IND_CUST_LAST_NAME") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"IND_CUST_LAST_NAME") */ count(*) as nrw,count(distinct sys_op_lbid(12116,'L',t.rowid)) as nlb,count(distinct UPPER("CUST_LAST_NAME")) as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SH"."CUSTOMERS" t where UPPER("CUST_LAST_NAME") is not null
select /*+ no_parallel_index(t,"IND_COUNTRY_CITY") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"IND_COUNTRY_CITY") */ count(*) as nrw,count(distinct sys_op_lbid(12121,'L',t.rowid)) as nlb,count(distinct hextoraw(sys_op_descend("COUNTRY_ID")||sys_op_descend("CUST_CITY"))) as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SH"."CUSTOMERS" t where "COUNTRY_ID" is not null or "CUST_CITY" is not null
select /*+ no_parallel_index(t,"IND_COUNTRY_ID_BIT") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"IND_COUNTRY_ID_BIT") */ count(distinct sys_op_lbid(12122,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(12122,'L',t.rowid)) as nlb,count(distinct "COUNTRY_ID") as ndk,null as clf 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(*)  from "SH"."FWEEK_PSCAT_SALES_MV" 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 "WEEK_ENDING_DAY"),substrb(dump(min("WEEK_ENDING_DAY"),16,0,32),1,120),substrb(dump(max("WEEK_ENDING_DAY"),16,0,32),1,120),count(distinct "PROD_SUBCATEGORY"),sum(sys_op_opnsize("PROD_SUBCATEGORY")),substrb(dump(min(substrb("PROD_SUBCATEGORY",1,32)),16,0,32),1,120),substrb(dump(max(substrb("PROD_SUBCATEGORY",1,32)),16,0,32),1,120),count("DOLLARS"),count(distinct "DOLLARS"),sum(sys_op_opnsize("DOLLARS")),substrb(dump(min("DOLLARS"),16,0,32),1,120),substrb(dump(max("DOLLARS"),16,0,32),1,120),count(distinct "CHANNEL_ID"),sum(sys_op_opnsize("CHANNEL_ID")),substrb(dump(min("CHANNEL_ID"),16,0,32),1,120),substrb(dump(max("CHANNEL_ID"),16,0,32),1,120),count(distinct "PROMO_ID"),sum(sys_op_opnsize("PROMO_ID")),substrb(dump(min("PROMO_ID"),16
,0,32),1,120),substrb(dump(max("PROMO_ID"),16,0,32),1,120) from "SH"."FWEEK_PSCAT_SALES_MV" t

select /*+ no_parallel_index(t,"FW_PSC_S_MV_SUBCAT_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"FW_PSC_S_MV_SUBCAT_BIX") */ count(distinct sys_op_lbid(12037,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(12037,'L',t.rowid)) as nlb,count(distinct "PROD_SUBCATEGORY") as ndk,null as clf from "SH"."FWEEK_PSCAT_SALES_MV" t
select /*+ no_parallel_index(t,"FW_PSC_S_MV_CHAN_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"FW_PSC_S_MV_CHAN_BIX") */ count(distinct sys_op_lbid(12038,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(12038,'L',t.rowid)) as nlb,count(distinct "CHANNEL_ID") as ndk,null as clf from "SH"."FWEEK_PSCAT_SALES_MV" t

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select /*+ no_parallel_index(t,"FW_PSC_S_MV_PROMO_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"FW_PSC_S_MV_PROMO_BIX") */ count(distinct sys_op_lbid(12039,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(12039,'L',t.rowid)) as nlb,count(distinct "PROMO_ID") as ndk,null as clf from "SH"."FWEEK_PSCAT_SALES_MV" t
select /*+ no_parallel_index(t,"FW_PSC_S_MV_WD_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"FW_PSC_S_MV_WD_BIX") */ count(distinct sys_op_lbid(12040,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(12040,'L',t.rowid)) as nlb,count(distinct "WEEK_ENDING_DAY") as ndk,null as clf from "SH"."FWEEK_PSCAT_SALES_MV" 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"."PRODUCTS" 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("PROD_ID")),substrb(dump(min("PROD_ID"),16,0,32),1,120),substrb(dump(max("PROD_ID"),16,0,32),1,120),count(distinct "PROD_NAME"),sum(sys_op_opnsize("PROD_NAME")),substrb(dump(min(substrb("PROD_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("PROD_NAME",1,32)),16,0,32),1,120),count(distinct "PROD_DESC"),sum(sys_op_opnsize("PROD_DESC")),substrb(dump(min(substrb("PROD_DESC",1,32)),16,0,32),1,120),substrb(dump(max(substrb("PROD_DESC",1,32)),16,0,32),1,120),count(distinct "PROD_SUBCATEGORY"),sum(sys_op_opnsize("PROD_SUBCATEGORY")),substrb(dump(min(substrb("PROD_SUBCATEGORY",1,32)),16,0,32),1,120),substrb(dump(max(substrb("PROD_SUBCATEGORY",1,32)),16,0,32),1,120),count(distinct "PROD_SUBCATEGORY_ID"),sum(sys_op_opnsize("PROD_SUB
CATEGORY_ID")),substrb(dump(min("PROD_SUBCATEGORY_ID"),16,0,32),1,120),substrb(dump(max("PROD_SUBCATEGORY_ID"),16,0,32),1,120),count(distinct "PROD_SUBCATEGORY_DESC"),sum(sys_op_opnsize("PROD_SUBCATEGORY_DESC")),substrb(dump(min(substrb("PROD_SUBCATEGORY_DESC",1,32)),16,0,32),1,120),substrb(dump(max(substrb("PROD_SUBCATEGORY_DESC",1,32)),16,0,32),1,120),count(distinct "PROD_CATEGORY"),sum(sys_op_opnsize("PROD_CATEGORY")),substrb(dump(min(substrb("PROD_CATEGORY",1,32)),16,0,32),1,120),substrb(dump(max(substrb("PROD_CATEGORY",1,32)),16,0,32),1,120),count(distinct "PROD_CATEGORY_ID"),sum(sys_op_opnsize("PROD_CATEGORY_ID")),substrb(dump(min("PROD_CATEGORY_ID"),16,0,32),1,120),substrb(dump(max("PROD_CATEGORY_ID"),16,0,32),1,120),count(distinct "PROD_CATEGORY_DESC"),sum(sys_op_opnsize("PROD_CATEGORY_DESC")),substrb(dump(min(substrb("PROD_CATEGORY_DESC",1,32)),16,0,32),1,120),substrb(dump(max(s
ubstrb("PROD_CATEGORY_DESC",1,32)),16,0,32),1,120),count(distinct "PROD_WEIGHT_CLASS"),sum(sys_op_opnsize("PROD_WEIGHT_CLASS")),substrb(dump(min("PROD_WEIGHT_CLASS"),16,0,32),1,120),substrb(dump(max("PROD_WEIGHT_CLASS"),16,0,32),1,120),count("PROD_UNIT_OF_MEASURE"),count(distinct "PROD_UNIT_OF_MEASURE"),sum(sys_op_opnsize("PROD_UNIT_OF_MEASURE")),substrb(dump(min("PROD_UNIT_OF_MEASURE"),16,0,32),1,120),substrb(dump(max("PROD_UNIT_OF_MEASURE"),16,0,32),1,120),count(distinct "PROD_PACK_SIZE"),sum(sys_op_opnsize("PROD_PACK_SIZE")),substrb(dump(min("PROD_PACK_SIZE"),16,0,32),1,120),substrb(dump(max("PROD_PACK_SIZE"),16,0,32),1,120),count(distinct "SUPPLIER_ID"),sum(sys_op_opnsize("SUPPLIER_ID")),substrb(dump(min("SUPPLIER_ID"),16,0,32),1,120),substrb(dump(max("SUPPLIER_ID"),16,0,32),1,120),count(distinct "PROD_STATUS"),sum(sys_op_opnsize("PROD_STATUS")),substrb(dump(min("PROD_STATUS"),16,0,3
2),1,120),substrb(dump(max("PROD_STATUS"),16,0,32),1,120),count(distinct "PROD_LIST_PRICE"),sum(sys_op_opnsize("PROD_LIST_PRICE")),substrb(dump(min("PROD_LIST_PRICE"),16,0,32),1,120),substrb(dump(max("PROD_LIST_PRICE"),16,0,32),1,120),count(distinct "PROD_MIN_PRICE"),sum(sys_op_opnsize("PROD_MIN_PRICE")),substrb(dump(min("PROD_MIN_PRICE"),16,0,32),1,120),substrb(dump(max("PROD_MIN_PRICE"),16,0,32),1,120),count(distinct "PROD_TOTAL"),sum(sys_op_opnsize("PROD_TOTAL")),substrb(dump(min("PROD_TOTAL"),16,0,32),1,120),substrb(dump(max("PROD_TOTAL"),16,0,32),1,120),count(distinct "PROD_TOTAL_ID"),sum(sys_op_opnsize("PROD_TOTAL_ID")),substrb(dump(min("PROD_TOTAL_ID"),16,0,32),1,120),substrb(dump(max("PROD_TOTAL_ID"),16,0,32),1,120),count("PROD_SRC_ID"),count(distinct "PROD_SRC_ID"),sum(sys_op_opnsize("PROD_SRC_ID")),substrb(dump(min("PROD_SRC_ID"),16,0,32),1,120),substrb(dump(max("PROD_SRC_ID"),
16,0,32),1,120),count("PROD_EFF_FROM"),count(distinct "PROD_EFF_FROM"),substrb(dump(min("PROD_EFF_FROM"),16,0,32),1,120),substrb(dump(max("PROD_EFF_FROM"),16,0,32),1,120),count("PROD_EFF_TO"),count(distinct "PROD_EFF_TO"),substrb(dump(min("PROD_EFF_TO"),16,0,32),1,120),substrb(dump(max("PROD_EFF_TO"),16,0,32),1,120),count("PROD_VALID"),count(distinct "PROD_VALID"),sum(sys_op_opnsize("PROD_VALID")),substrb(dump(min("PROD_VALID"),16,0,32),1,120),substrb(dump(max("PROD_VALID"),16,0,32),1,120) from "SH"."PRODUCTS" t

select /*+ no_parallel_index(t,"PRODUCTS_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"PRODUCTS_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11822,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SH"."PRODUCTS" t where "PROD_ID" is not null
select /*+ no_parallel_index(t,"PRODUCTS_PROD_SUBCAT_IX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"PRODUCTS_PROD_SUBCAT_IX") */ count(*) as nrw,count(distinct sys_op_lbid(11823,'L',t.rowid)) as nlb,count(distinct "PROD_SUBCATEGORY") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SH"."PRODUCTS" t where "PROD_SUBCATEGORY" is not null

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select /*+ no_parallel_index(t,"PRODUCTS_PROD_CAT_IX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"PRODUCTS_PROD_CAT_IX") */ count(*) as nrw,count(distinct sys_op_lbid(11824,'L',t.rowid)) as nlb,count(distinct "PROD_CATEGORY") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SH"."PRODUCTS" t where "PROD_CATEGORY" is not null
select /*+ no_parallel_index(t,"PRODUCTS_PROD_STATUS_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"PRODUCTS_PROD_STATUS_BIX") */ count(distinct sys_op_lbid(12033,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(12033,'L',t.rowid)) as nlb,count(distinct "PROD_STATUS") as ndk,null as clf from "SH"."PRODUCTS" 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"."PROMOTIONS" 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("PROMO_ID")),substrb(dump(min("PROMO_ID"),16,0,32),1,120),substrb(dump(max("PROMO_ID"),16,0,32),1,120),count(distinct "PROMO_NAME"),sum(sys_op_opnsize("PROMO_NAME")),substrb(dump(min("PROMO_NAME"),16,0,32),1,120),substrb(dump(max("PROMO_NAME"),16,0,32),1,120),count(distinct "PROMO_SUBCATEGORY"),sum(sys_op_opnsize("PROMO_SUBCATEGORY")),substrb(dump(min("PROMO_SUBCATEGORY"),16,0,32),1,120),substrb(dump(max("PROMO_SUBCATEGORY"),16,0,32),1,120),count(distinct "PROMO_SUBCATEGORY_ID"),sum(sys_op_opnsize("PROMO_SUBCATEGORY_ID")),substrb(dump(min("PROMO_SUBCATEGORY_ID"),16,0,32),1,120),substrb(dump(max("PROMO_SUBCATEGORY_ID"),16,0,32),1,120),count(distinct "PROMO_CATEGORY"),sum(sys_op_opnsize("PROMO_CATEGORY")),substrb(dump(min("PROMO_
CATEGORY"),16,0,32),1,120),substrb(dump(max("PROMO_CATEGORY"),16,0,32),1,120),count(distinct "PROMO_CATEGORY_ID"),sum(sys_op_opnsize("PROMO_CATEGORY_ID")),substrb(dump(min("PROMO_CATEGORY_ID"),16,0,32),1,120),substrb(dump(max("PROMO_CATEGORY_ID"),16,0,32),1,120),count(distinct "PROMO_COST"),sum(sys_op_opnsize("PROMO_COST")),substrb(dump(min("PROMO_COST"),16,0,32),1,120),substrb(dump(max("PROMO_COST"),16,0,32),1,120),count(distinct "PROMO_BEGIN_DATE"),substrb(dump(min("PROMO_BEGIN_DATE"),16,0,32),1,120),substrb(dump(max("PROMO_BEGIN_DATE"),16,0,32),1,120),count(distinct "PROMO_END_DATE"),substrb(dump(min("PROMO_END_DATE"),16,0,32),1,120),substrb(dump(max("PROMO_END_DATE"),16,0,32),1,120),count(distinct "PROMO_TOTAL"),sum(sys_op_opnsize("PROMO_TOTAL")),substrb(dump(min("PROMO_TOTAL"),16,0,32),1,120),substrb(dump(max("PROMO_TOTAL"),16,0,32),1,120),count(distinct "PROMO_TOTAL_ID"),sum(sys_op
_opnsize("PROMO_TOTAL_ID")),substrb(dump(min("PROMO_TOTAL_ID"),16,0,32),1,120),substrb(dump(max("PROMO_TOTAL_ID"),16,0,32),1,120) from "SH"."PROMOTIONS" t

select /*+ no_parallel_index(t,"PROMO_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"PROMO_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11826,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SH"."PROMOTIONS" t where "PROMO_ID" is not null
 select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*)  from "SH"."SALES" t where TBL$OR$IDX$PART$NUM("SH"."SALES",0,4,0,"ROWID") = :objn
create global temporary table sys.ora_temp_1_ds_9 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"PROD_ID","CUST_ID","TIME_ID","CHANNEL_ID","PROMO_ID","QUANTITY_SOLD","AMOUNT_SOLD" from "SH"."SALES" sample ( 12.5895575343) t  where 1 = 2
 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"."SALES" sample block (  6.3411540900,1) t

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select /*+ no_parallel_index(t,"SALES_PROD_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"SALES_PROD_BIX") */ count(distinct sys_op_lbid(11830,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(11830,'L',t.rowid)) as nlb,count(distinct "PROD_ID") as ndk,null as clf from "SH"."SALES" t where TBL$OR$IDX$PART$NUM("SH"."SALES",0,4,0,"ROWID") = :objn
select /*+ no_parallel_index(t,"SALES_PROD_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"SALES_PROD_BIX") */ count(distinct sys_op_lbid(11830,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(11830,'L',t.rowid)) as nlb,count(distinct "PROD_ID") as ndk,null as clf from "SH"."SALES" t
select /*+ no_parallel_index(t,"SALES_CUST_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"SALES_CUST_BIX") */ count(distinct sys_op_lbid(11859,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(11859,'L',t.rowid)) as nlb,count(distinct "CUST_ID") as ndk,null as clf from "SH"."SALES" t where TBL$OR$IDX$PART$NUM("SH"."SALES",0,4,0,"ROWID") = :objn
select /*+ no_parallel_index(t,"SALES_CUST_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"SALES_CUST_BIX") */ count(distinct sys_op_lbid(11859,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(11859,'L',t.rowid)) as nlb,count(distinct "CUST_ID") as ndk,null as clf from "SH"."SALES" t
select /*+ no_parallel_index(t,"SALES_TIME_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"SALES_TIME_BIX") */ count(distinct sys_op_lbid(11888,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(11888,'L',t.rowid)) as nlb,count(distinct "TIME_ID") as ndk,null as clf from "SH"."SALES" t where TBL$OR$IDX$PART$NUM("SH"."SALES",0,4,0,"ROWID") = :objn
select /*+ no_parallel_index(t,"SALES_TIME_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"SALES_TIME_BIX") */ count(distinct sys_op_lbid(11888,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(11888,'L',t.rowid)) as nlb,count(distinct "TIME_ID") as ndk,null as clf from "SH"."SALES" t
select /*+ no_parallel_index(t,"SALES_CHANNEL_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"SALES_CHANNEL_BIX") */ count(distinct sys_op_lbid(11917,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(11917,'L',t.rowid)) as nlb,count(distinct "CHANNEL_ID") as ndk,null as clf from "SH"."SALES" t where TBL$OR$IDX$PART$NUM("SH"."SALES",0,4,0,"ROWID") = :objn
select /*+ no_parallel_index(t,"SALES_CHANNEL_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"SALES_CHANNEL_BIX") */ count(distinct sys_op_lbid(11917,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(11917,'L',t.rowid)) as nlb,count(distinct "CHANNEL_ID") as ndk,null as clf from "SH"."SALES" t
select /*+ no_parallel_index(t,"SALES_PROMO_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"SALES_PROMO_BIX") */ count(distinct sys_op_lbid(11946,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(11946,'L',t.rowid)) as nlb,count(distinct "PROMO_ID") as ndk,null as clf from "SH"."SALES" t where TBL$OR$IDX$PART$NUM("SH"."SALES",0,4,0,"ROWID") = :objn
select /*+ no_parallel_index(t,"SALES_PROMO_BIX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"SALES_PROMO_BIX") */ count(distinct sys_op_lbid(11946,'R',t.rowid)) as nrw,count(distinct sys_op_lbid(11946,'L',t.rowid)) as nlb,count(distinct "PROMO_ID") as ndk,null as clf from "SH"."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(*)  from "SH"."SUPPLEMENTARY_DEMOGRAPHICS" t

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*),count(distinct "CUST_ID"),sum(sys_op_opnsize("CUST_ID")),substrb(dump(min("CUST_ID"),16,0,32),1,120),substrb(dump(max("CUST_ID"),16,0,32),1,120),count("EDUCATION"),count(distinct "EDUCATION"),sum(sys_op_opnsize("EDUCATION")),substrb(dump(min("EDUCATION"),16,0,32),1,120),substrb(dump(max("EDUCATION"),16,0,32),1,120),count("OCCUPATION"),count(distinct "OCCUPATION"),sum(sys_op_opnsize("OCCUPATION")),substrb(dump(min("OCCUPATION"),16,0,32),1,120),substrb(dump(max("OCCUPATION"),16,0,32),1,120),count("HOUSEHOLD_SIZE"),count(distinct "HOUSEHOLD_SIZE"),sum(sys_op_opnsize("HOUSEHOLD_SIZE")),substrb(dump(min("HOUSEHOLD_SIZE"),16,0,32),1,120),substrb(dump(max("HOUSEHOLD_SIZE"),16,0,32),1,120),count("YRS_RESIDENCE"),count(distinct "YRS_RESIDENCE"),sum(sys_op
_opnsize("YRS_RESIDENCE")),substrb(dump(min("YRS_RESIDENCE"),16,0,32),1,120),substrb(dump(max("YRS_RESIDENCE"),16,0,32),1,120),count("AFFINITY_CARD"),count(distinct "AFFINITY_CARD"),sum(sys_op_opnsize("AFFINITY_CARD")),substrb(dump(min("AFFINITY_CARD"),16,0,32),1,120),substrb(dump(max("AFFINITY_CARD"),16,0,32),1,120),count("BULK_PACK_DISKETTES"),count(distinct "BULK_PACK_DISKETTES"),sum(sys_op_opnsize("BULK_PACK_DISKETTES")),substrb(dump(min("BULK_PACK_DISKETTES"),16,0,32),1,120),substrb(dump(max("BULK_PACK_DISKETTES"),16,0,32),1,120),count("FLAT_PANEL_MONITOR"),count(distinct "FLAT_PANEL_MONITOR"),sum(sys_op_opnsize("FLAT_PANEL_MONITOR")),substrb(dump(min("FLAT_PANEL_MONITOR"),16,0,32),1,120),substrb(dump(max("FLAT_PANEL_MONITOR"),16,0,32),1,120),count("HOME_THEATER_PACKAGE"),count(distinct "HOME_THEATER_PACKAGE"),sum(sys_op_opnsize("HOME_THEATER_PACKAGE")),substrb(dump(min("HOME_THEATE
R_PACKAGE"),16,0,32),1,120),substrb(dump(max("HOME_THEATER_PACKAGE"),16,0,32),1,120),count("BOOKKEEPING_APPLICATION"),count(distinct "BOOKKEEPING_APPLICATION"),sum(sys_op_opnsize("BOOKKEEPING_APPLICATION")),substrb(dump(min("BOOKKEEPING_APPLICATION"),16,0,32),1,120),substrb(dump(max("BOOKKEEPING_APPLICATION"),16,0,32),1,120),count("PRINTER_SUPPLIES"),count(distinct "PRINTER_SUPPLIES"),sum(sys_op_opnsize("PRINTER_SUPPLIES")),substrb(dump(min("PRINTER_SUPPLIES"),16,0,32),1,120),substrb(dump(max("PRINTER_SUPPLIES"),16,0,32),1,120),count("Y_BOX_GAMES"),count(distinct "Y_BOX_GAMES"),sum(sys_op_opnsize("Y_BOX_GAMES")),substrb(dump(min("Y_BOX_GAMES"),16,0,32),1,120),substrb(dump(max("Y_BOX_GAMES"),16,0,32),1,120),count("OS_DOC_SET_KANJI"),count(distinct "OS_DOC_SET_KANJI"),sum(sys_op_opnsize("OS_DOC_SET_KANJI")),substrb(dump(min("OS_DOC_SET_KANJI"),16,0,32),1,120),substrb(dump(max("OS_DOC_SET_K
ANJI"),16,0,32),1,120),count("COMMENTS"),count(distinct "COMMENTS"),sum(sys_op_opnsize("COMMENTS")),substrb(dump(min(substrb("COMMENTS",1,32)),16,0,32),1,120),substrb(dump(max(substrb("COMMENTS",1,32)),16,0,32),1,120) from "SH"."SUPPLEMENTARY_DEMOGRAPHICS" 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"."TIMES" t
select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*),substrb(dump(min("TIME_ID"),16,0,32),1,120),substrb(dump(max("TIME_ID"),16,0,32),1,120),count(distinct "DAY_NAME"),sum(sys_op_opnsize("DAY_NAME")),substrb(dump(min("DAY_NAME"),16,0,32),1,120),substrb(dump(max("DAY_NAME"),16,0,32),1,120),count(distinct "DAY_NUMBER_IN_WEEK"),sum(sys_op_opnsize("DAY_NUMBER_IN_WEEK")),substrb(dump(min("DAY_NUMBER_IN_WEEK"),16,0,32),1,120),substrb(dump(max("DAY_NUMBER_IN_WEEK"),16,0,32),1,120),count(distinct "DAY_NUMBER_IN_MONTH"),sum(sys_op_opnsize("DAY_NUMBER_IN_MONTH")),substrb(dump(min("DAY_NUMBER_IN_MONTH"),16,0,32),1,120),substrb(dump(max("DAY_NUMBER_IN_MONTH"),16,0,32),1,120),count(distinct "CALENDAR_WEEK_NUMBER"),sum(sys_op_opnsize("CALENDAR_WEEK_NUMBER")),substrb(dump(min("CALENDAR_WEEK_NUMBER"),16,0,32),1,12
0),substrb(dump(max("CALENDAR_WEEK_NUMBER"),16,0,32),1,120),count(distinct "FISCAL_WEEK_NUMBER"),sum(sys_op_opnsize("FISCAL_WEEK_NUMBER")),substrb(dump(min("FISCAL_WEEK_NUMBER"),16,0,32),1,120),substrb(dump(max("FISCAL_WEEK_NUMBER"),16,0,32),1,120),count(distinct "WEEK_ENDING_DAY"),substrb(dump(min("WEEK_ENDING_DAY"),16,0,32),1,120),substrb(dump(max("WEEK_ENDING_DAY"),16,0,32),1,120),count(distinct "WEEK_ENDING_DAY_ID"),sum(sys_op_opnsize("WEEK_ENDING_DAY_ID")),substrb(dump(min("WEEK_ENDING_DAY_ID"),16,0,32),1,120),substrb(dump(max("WEEK_ENDING_DAY_ID"),16,0,32),1,120),count(distinct "CALENDAR_MONTH_NUMBER"),sum(sys_op_opnsize("CALENDAR_MONTH_NUMBER")),substrb(dump(min("CALENDAR_MONTH_NUMBER"),16,0,32),1,120),substrb(dump(max("CALENDAR_MONTH_NUMBER"),16,0,32),1,120),count(distinct "FISCAL_MONTH_NUMBER"),sum(sys_op_opnsize("FISCAL_MONTH_NUMBER")),substrb(dump(min("FISCAL_MONTH_NUMBER"),16
,0,32),1,120),substrb(dump(max("FISCAL_MONTH_NUMBER"),16,0,32),1,120),count(distinct "CALENDAR_MONTH_DESC"),sum(sys_op_opnsize("CALENDAR_MONTH_DESC")),substrb(dump(min("CALENDAR_MONTH_DESC"),16,0,32),1,120),substrb(dump(max("CALENDAR_MONTH_DESC"),16,0,32),1,120),count(distinct "CALENDAR_MONTH_ID"),sum(sys_op_opnsize("CALENDAR_MONTH_ID")),substrb(dump(min("CALENDAR_MONTH_ID"),16,0,32),1,120),substrb(dump(max("CALENDAR_MONTH_ID"),16,0,32),1,120),count(distinct "FISCAL_MONTH_DESC"),sum(sys_op_opnsize("FISCAL_MONTH_DESC")),substrb(dump(min("FISCAL_MONTH_DESC"),16,0,32),1,120),substrb(dump(max("FISCAL_MONTH_DESC"),16,0,32),1,120),count(distinct "FISCAL_MONTH_ID"),sum(sys_op_opnsize("FISCAL_MONTH_ID")),substrb(dump(min("FISCAL_MONTH_ID"),16,0,32),1,120),substrb(dump(max("FISCAL_MONTH_ID"),16,0,32),1,120),count(distinct "DAYS_IN_CAL_MONTH"),sum(sys_op_opnsize("DAYS_IN_CAL_MONTH")),substrb(dump(
min("DAYS_IN_CAL_MONTH"),16,0,32),1,120),substrb(dump(max("DAYS_IN_CAL_MONTH"),16,0,32),1,120),count(distinct "DAYS_IN_FIS_MONTH"),sum(sys_op_opnsize("DAYS_IN_FIS_MONTH")),substrb(dump(min("DAYS_IN_FIS_MONTH"),16,0,32),1,120),substrb(dump(max("DAYS_IN_FIS_MONTH"),16,0,32),1,120),count(distinct "END_OF_CAL_MONTH"),substrb(dump(min("END_OF_CAL_MONTH"),16,0,32),1,120),substrb(dump(max("END_OF_CAL_MONTH"),16,0,32),1,120),count(distinct "END_OF_FIS_MONTH"),substrb(dump(min("END_OF_FIS_MONTH"),16,0,32),1,120),substrb(dump(max("END_OF_FIS_MONTH"),16,0,32),1,120),count(distinct "CALENDAR_MONTH_NAME"),sum(sys_op_opnsize("CALENDAR_MONTH_NAME")),substrb(dump(min("CALENDAR_MONTH_NAME"),16,0,32),1,120),substrb(dump(max("CALENDAR_MONTH_NAME"),16,0,32),1,120),count(distinct "FISCAL_MONTH_NAME"),sum(sys_op_opnsize("FISCAL_MONTH_NAME")),substrb(dump(min("FISCAL_MONTH_NAME"),16,0,32),1,120),substrb(dump(m
ax("FISCAL_MONTH_NAME"),16,0,32),1,120),count(distinct "CALENDAR_QUARTER_DESC"),substrb(dump(min("CALENDAR_QUARTER_DESC"),16,0,32),1,120),substrb(dump(max("CALENDAR_QUARTER_DESC"),16,0,32),1,120),count(distinct "CALENDAR_QUARTER_ID"),sum(sys_op_opnsize("CALENDAR_QUARTER_ID")),substrb(dump(min("CALENDAR_QUARTER_ID"),16,0,32),1,120),substrb(dump(max("CALENDAR_QUARTER_ID"),16,0,32),1,120),count(distinct "FISCAL_QUARTER_DESC"),substrb(dump(min("FISCAL_QUARTER_DESC"),16,0,32),1,120),substrb(dump(max("FISCAL_QUARTER_DESC"),16,0,32),1,120),count(distinct "FISCAL_QUARTER_ID"),sum(sys_op_opnsize("FISCAL_QUARTER_ID")),substrb(dump(min("FISCAL_QUARTER_ID"),16,0,32),1,120),substrb(dump(max("FISCAL_QUARTER_ID"),16,0,32),1,120),count(distinct "DAYS_IN_CAL_QUARTER"),sum(sys_op_opnsize("DAYS_IN_CAL_QUARTER")),substrb(dump(min("DAYS_IN_CAL_QUARTER"),16,0,32),1,120),substrb(dump(max("DAYS_IN_CAL_QUARTER")

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
,16,0,32),1,120),count(distinct "DAYS_IN_FIS_QUARTER"),sum(sys_op_opnsize("DAYS_IN_FIS_QUARTER")),substrb(dump(min("DAYS_IN_FIS_QUARTER"),16,0,32),1,120),substrb(dump(max("DAYS_IN_FIS_QUARTER"),16,0,32),1,120),count(distinct "END_OF_CAL_QUARTER"),substrb(dump(min("END_OF_CAL_QUARTER"),16,0,32),1,120),substrb(dump(max("END_OF_CAL_QUARTER"),16,0,32),1,120),count(distinct "END_OF_FIS_QUARTER"),substrb(dump(min("END_OF_FIS_QUARTER"),16,0,32),1,120),substrb(dump(max("END_OF_FIS_QUARTER"),16,0,32),1,120),count(distinct "CALENDAR_QUARTER_NUMBER"),sum(sys_op_opnsize("CALENDAR_QUARTER_NUMBER")),substrb(dump(min("CALENDAR_QUARTER_NUMBER"),16,0,32),1,120),substrb(dump(max("CALENDAR_QUARTER_NUMBER"),16,0,32),1,120),count(distinct "FISCAL_QUARTER_NUMBER"),sum(sys_op_opnsize("FISCAL_QUARTER_NUMBER")),substrb(dump(min("FISCAL_QUARTER_NUMBER"),16,0,32),1,120),substrb(dump(max("FISCAL_QUARTER_NUMBER"),16
,0,32),1,120),count(distinct "CALENDAR_YEAR"),sum(sys_op_opnsize("CALENDAR_YEAR")),substrb(dump(min("CALENDAR_YEAR"),16,0,32),1,120),substrb(dump(max("CALENDAR_YEAR"),16,0,32),1,120),count(distinct "CALENDAR_YEAR_ID"),sum(sys_op_opnsize("CALENDAR_YEAR_ID")),substrb(dump(min("CALENDAR_YEAR_ID"),16,0,32),1,120),substrb(dump(max("CALENDAR_YEAR_ID"),16,0,32),1,120),count(distinct "FISCAL_YEAR"),sum(sys_op_opnsize("FISCAL_YEAR")),substrb(dump(min("FISCAL_YEAR"),16,0,32),1,120),substrb(dump(max("FISCAL_YEAR"),16,0,32),1,120),count(distinct "FISCAL_YEAR_ID"),sum(sys_op_opnsize("FISCAL_YEAR_ID")),substrb(dump(min("FISCAL_YEAR_ID"),16,0,32),1,120),substrb(dump(max("FISCAL_YEAR_ID"),16,0,32),1,120),count(distinct "DAYS_IN_CAL_YEAR"),sum(sys_op_opnsize("DAYS_IN_CAL_YEAR")),substrb(dump(min("DAYS_IN_CAL_YEAR"),16,0,32),1,120),substrb(dump(max("DAYS_IN_CAL_YEAR"),16,0,32),1,120),count(distinct "DAYS_
IN_FIS_YEAR"),sum(sys_op_opnsize("DAYS_IN_FIS_YEAR")),substrb(dump(min("DAYS_IN_FIS_YEAR"),16,0,32),1,120),substrb(dump(max("DAYS_IN_FIS_YEAR"),16,0,32),1,120),count(distinct "END_OF_CAL_YEAR"),substrb(dump(min("END_OF_CAL_YEAR"),16,0,32),1,120),substrb(dump(max("END_OF_CAL_YEAR"),16,0,32),1,120),count(distinct "END_OF_FIS_YEAR"),substrb(dump(min("END_OF_FIS_YEAR"),16,0,32),1,120),substrb(dump(max("END_OF_FIS_YEAR"),16,0,32),1,120) from "SH"."TIMES" t

select /*+ no_parallel_index(t,"TIMES_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"TIMES_PK") */ count(*) as nrw,count(distinct sys_op_lbid(11821,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SH"."TIMES" t where "TIME_ID" is not null
 select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*)  from "SH"."TRANSACTION" t
select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*),count(distinct "USERNAME"),sum(sys_op_opnsize("USERNAME")),substrb(dump(min("USERNAME"),16,0,32),1,120),substrb(dump(max("USERNAME"),16,0,32),1,120),count(distinct "USER_ID"),sum(sys_op_opnsize("USER_ID")),substrb(dump(min("USER_ID"),16,0,32),1,120),substrb(dump(max("USER_ID"),16,0,32),1,120),count("PASSWORD"),count(distinct "PASSWORD"),sum(sys_op_opnsize("PASSWORD")),substrb(dump(min("PASSWORD"),16,0,32),1,120),substrb(dump(max("PASSWORD"),16,0,32),1,120),count(distinct "ACCOUNT_STATUS"),sum(sys_op_opnsize("ACCOUNT_STATUS")),substrb(dump(min("ACCOUNT_STATUS"),16,0,32),1,120),substrb(dump(max("ACCOUNT_STATUS"),16,0,32),1,120),count("LOCK_DATE"),count(distinct "LOCK_DATE"),substrb(dump(min("LOCK_DATE"),16,0,32),1,120),substrb(dump(max("LOCK_DATE")
,16,0,32),1,120),count("EXPIRY_DATE"),count(distinct "EXPIRY_DATE"),substrb(dump(min("EXPIRY_DATE"),16,0,32),1,120),substrb(dump(max("EXPIRY_DATE"),16,0,32),1,120),count(distinct "DEFAULT_TABLESPACE"),sum(sys_op_opnsize("DEFAULT_TABLESPACE")),substrb(dump(min("DEFAULT_TABLESPACE"),16,0,32),1,120),substrb(dump(max("DEFAULT_TABLESPACE"),16,0,32),1,120),count(distinct "TEMPORARY_TABLESPACE"),sum(sys_op_opnsize("TEMPORARY_TABLESPACE")),substrb(dump(min("TEMPORARY_TABLESPACE"),16,0,32),1,120),substrb(dump(max("TEMPORARY_TABLESPACE"),16,0,32),1,120),count(distinct "CREATED"),substrb(dump(min("CREATED"),16,0,32),1,120),substrb(dump(max("CREATED"),16,0,32),1,120),count(distinct "PROFILE"),sum(sys_op_opnsize("PROFILE")),substrb(dump(min("PROFILE"),16,0,32),1,120),substrb(dump(max("PROFILE"),16,0,32),1,120),count("INITIAL_RSRC_CONSUMER_GROUP"),count(distinct "INITIAL_RSRC_CONSUMER_GROUP"),sum(sys_
op_opnsize("INITIAL_RSRC_CONSUMER_GROUP")),substrb(dump(min("INITIAL_RSRC_CONSUMER_GROUP"),16,0,32),1,120),substrb(dump(max("INITIAL_RSRC_CONSUMER_GROUP"),16,0,32),1,120),count("EXTERNAL_NAME"),count(distinct "EXTERNAL_NAME"),sum(sys_op_opnsize("EXTERNAL_NAME")),substrb(dump(min(substrb("EXTERNAL_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("EXTERNAL_NAME",1,32)),16,0,32),1,120) from "SH"."TRANSACTION" t

select /*+ no_parallel_index(t,"IND_USER_ID_HASH") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"IND_USER_ID_HASH") */ count(*) as nrw,count(distinct sys_op_lbid(12140,'L',t.rowid)) as nlb,count(distinct "USER_ID") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SH"."TRANSACTION" t where ("USER_ID" is not null) and (TBL$OR$IDX$PART$NUM("SH"."TRANSACTION",12140,4,0,"USER_ID") = :objn)

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select /*+ no_parallel_index(t,"IND_USER_ID_HASH") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"IND_USER_ID_HASH") */ count(*) as nrw,count(distinct sys_op_lbid(12140,'L',t.rowid)) as nlb,count(distinct "USER_ID") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SH"."TRANSACTION" t where "USER_ID" is not null
 select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*)  from "WMSYS"."AQ$_WM$EVENT_QUEUE_TABLE_S" 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("SUBSCRIBER_ID")),substrb(dump(min("SUBSCRIBER_ID"),16,0,32),1,120),substrb(dump(max("SUBSCRIBER_ID"),16,0,32),1,120),count(distinct "QUEUE_NAME"),sum(sys_op_opnsize("QUEUE_NAME")),substrb(dump(min("QUEUE_NAME"),16,0,32),1,120),substrb(dump(max("QUEUE_NAME"),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("ADDRESS"),count(distinct "ADDRESS"),sum(sys_op_opnsize("ADDRESS")),substrb(dump(min(substrb("ADDRESS",1,32)),16,0,32),1,120),substrb(dump(max(substrb("ADDRESS",1,32)),16,0,32),1,120),count("PROTOCOL"),count(distinct "PROTOCOL"),sum(sys_op_opnsize("PROTOCOL")),substrb(dump(min("PROTOCOL"),16,0,32),1,120),sub
strb(dump(max("PROTOCOL"),16,0,32),1,120),count("SUBSCRIBER_TYPE"),count(distinct "SUBSCRIBER_TYPE"),sum(sys_op_opnsize("SUBSCRIBER_TYPE")),substrb(dump(min("SUBSCRIBER_TYPE"),16,0,32),1,120),substrb(dump(max("SUBSCRIBER_TYPE"),16,0,32),1,120),count("RULE_NAME"),count(distinct "RULE_NAME"),sum(sys_op_opnsize("RULE_NAME")),substrb(dump(min("RULE_NAME"),16,0,32),1,120),substrb(dump(max("RULE_NAME"),16,0,32),1,120),count("TRANS_NAME"),count(distinct "TRANS_NAME"),sum(sys_op_opnsize("TRANS_NAME")),substrb(dump(min(substrb("TRANS_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("TRANS_NAME",1,32)),16,0,32),1,120),count("RULESET_NAME"),count(distinct "RULESET_NAME"),sum(sys_op_opnsize("RULESET_NAME")),substrb(dump(min(substrb("RULESET_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("RULESET_NAME",1,32)),16,0,32),1,120),count("NEGATIVE_RULESET_NAME"),count(distinct "NEGATIVE_RULESET_
NAME"),sum(sys_op_opnsize("NEGATIVE_RULESET_NAME")),substrb(dump(min(substrb("NEGATIVE_RULESET_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("NEGATIVE_RULESET_NAME",1,32)),16,0,32),1,120) from "WMSYS"."AQ$_WM$EVENT_QUEUE_TABLE_S" t

select /*+ no_parallel_index(t,"SYS_C002935") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"SYS_C002935") */ count(*) as nrw,count(distinct sys_op_lbid(10110,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "WMSYS"."AQ$_WM$EVENT_QUEUE_TABLE_S" t where "SUBSCRIBER_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 "WMSYS"."WM$ENV_VARS" 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("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) from "WMSYS"."WM$ENV_VARS" t
select /*+ no_parallel_index(t,"WM$ENV_VARS_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"WM$ENV_VARS_PK") */ count(*) as nrw,count(distinct sys_op_lbid(9794,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "WMSYS"."WM$ENV_VARS" t where "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 "WMSYS"."WM$EVENTS_INFO" 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("EVENT_NAME")),substrb(dump(min("EVENT_NAME"),16,0,32),1,120),substrb(dump(max("EVENT_NAME"),16,0,32),1,120),count("CAPTURE"),count(distinct "CAPTURE"),sum(sys_op_opnsize("CAPTURE")),substrb(dump(min("CAPTURE"),16,0,32),1,120),substrb(dump(max("CAPTURE"),16,0,32),1,120) from "WMSYS"."WM$EVENTS_INFO" t
select /*+ no_parallel_index(t,"SYS_C002944") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"SYS_C002944") */ count(*) as nrw,count(distinct sys_op_lbid(10133,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "WMSYS"."WM$EVENTS_INFO" t where "EVENT_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 "WMSYS"."WM$NEXTVER_TABLE" 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("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),count("NEXT_VERS"),count(distinct "NEXT_VERS"),sum(sys_op_opnsize("NEXT_VERS")),substrb(dump(min(substrb("NEXT_VERS",1,32)),16,0,32),1,120),substrb(dump(max(substrb("NEXT_VERS",1,32)),16,0,32),1,120),count("WORKSPACE"),count(distinct "WORKSPACE"),sum(sys_op_opnsize("WORKSPACE")),substrb(dump(min("WORKSPACE"),16,0,32),1,120),substrb(dump(max("WORKSPACE"),16,0,32),1,120),count("SPLIT"),count(distinct "SPLIT"),sum(sys_op_opnsize("SPLIT")),substrb(dump(min("SPLIT"),16,0,32),1,120),substrb(dump(max("SPLIT"),16,0,32),1,120) from "WMSYS"."WM$NEXTVER_TABLE" t
select /*+ no_parallel_index(t,"WM$NEXTVER_TABLE_INDX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"WM$NEXTVER_TABLE_INDX") */ count(*) as nrw,count(distinct sys_op_lbid(9809,'L',t.rowid)) as nlb,count(distinct hextoraw(sys_op_descend("VERSION")||sys_op_descend("NEXT_VERS"))) as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "WMSYS"."WM$NEXTVER_TABLE" t where "VERSION" is not null or "NEXT_VERS" is not null
select /*+ no_parallel_index(t,"WM$NEXTVER_TABLE_NV_INDX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"WM$NEXTVER_TABLE_NV_INDX") */ count(*) as nrw,count(distinct sys_op_lbid(10051,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "WMSYS"."WM$NEXTVER_TABLE" t where "NEXT_VERS" is not null or "VERSION" is not null or "WORKSPACE" 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 "WMSYS"."WM$SYSPARAM_ALL_VALUES" 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("NAME")),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"),sum(sys_op_opnsize("ISDEFAULT")) from "WMSYS"."WM$SYSPARAM_ALL_VALUES" t
select /*+ no_parallel_index(t,"WM$ENV_SYS_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"WM$ENV_SYS_PK") */ count(*) as nrw,count(distinct sys_op_lbid(10058,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "WMSYS"."WM$SYSPARAM_ALL_VALUES" t where "NAME" is not null or "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 "WMSYS"."WM$VERSION_HIERARCHY_TABLE" 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("VERSION")),count("PARENT_VERSION"),count(distinct "PARENT_VERSION"),sum(sys_op_opnsize("PARENT_VERSION")),substrb(dump(min("PARENT_VERSION"),16,0,32),1,120),substrb(dump(max("PARENT_VERSION"),16,0,32),1,120),count("WORKSPACE"),sum(sys_op_opnsize("WORKSPACE")) from "WMSYS"."WM$VERSION_HIERARCHY_TABLE" t

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select /*+ no_parallel_index(t,"WM$VERSION_HIERARCHY_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"WM$VERSION_HIERARCHY_PK") */ count(*) as nrw,count(distinct sys_op_lbid(9756,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "WMSYS"."WM$VERSION_HIERARCHY_TABLE" t where "VERSION" is not null
select /*+ no_parallel_index(t,"WM$VHT_IDX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"WM$VHT_IDX") */ count(*) as nrw,count(distinct sys_op_lbid(9795,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "WMSYS"."WM$VERSION_HIERARCHY_TABLE" t where "WORKSPACE" is not null or "VERSION" 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 "WMSYS"."WM$WORKSPACES_TABLE" 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("WORKSPACE")),substrb(dump(min("WORKSPACE"),16,0,32),1,120),substrb(dump(max("WORKSPACE"),16,0,32),1,120),count("PARENT_WORKSPACE"),sum(sys_op_opnsize("PARENT_WORKSPACE")),count("CURRENT_VERSION"),count(distinct "CURRENT_VERSION"),sum(sys_op_opnsize("CURRENT_VERSION")),substrb(dump(min("CURRENT_VERSION"),16,0,32),1,120),substrb(dump(max("CURRENT_VERSION"),16,0,32),1,120),count("PARENT_VERSION"),count(distinct "PARENT_VERSION"),sum(sys_op_opnsize("PARENT_VERSION")),substrb(dump(min("PARENT_VERSION"),16,0,32),1,120),substrb(dump(max("PARENT_VERSION"),16,0,32),1,120),count("POST_VERSION"),sum(sys_op_opnsize("POST_VERSION")),count("VERLIST"),count(distinct "VERLIST"),sum(sys_op_opnsize("VERLIST")),substrb(dump(min(substrb("VERLIST"
,1,32)),16,0,32),1,120),substrb(dump(max(substrb("VERLIST",1,32)),16,0,32),1,120),count("OWNER"),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("CREATETIME"),count(distinct "CREATETIME"),substrb(dump(min("CREATETIME"),16,0,32),1,120),substrb(dump(max("CREATETIME"),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),count("WORKSPACE_LOCK_ID"),sum(sys_op_opnsize("WORKSPACE_LOCK_ID")),substrb(dump(min("WORKSPACE_LOCK_ID"),16,0,32),1,120),substrb(dump(max("WORKSPACE_LOCK_ID"),16,0,32),1,120),count("FREEZE_STATUS"),count(distinct "FREEZE_STATUS"),sum(sys_op_opnsize("FREEZE_STATUS")),substrb(dump(min("FREEZE_STATUS"),16,0,32),1,
120),substrb(dump(max("FREEZE_STATUS"),16,0,32),1,120),count("FREEZE_MODE"),count(distinct "FREEZE_MODE"),sum(sys_op_opnsize("FREEZE_MODE")),substrb(dump(min("FREEZE_MODE"),16,0,32),1,120),substrb(dump(max("FREEZE_MODE"),16,0,32),1,120),count("FREEZE_WRITER"),count(distinct "FREEZE_WRITER"),sum(sys_op_opnsize("FREEZE_WRITER")),substrb(dump(min("FREEZE_WRITER"),16,0,32),1,120),substrb(dump(max("FREEZE_WRITER"),16,0,32),1,120),count("OPER_STATUS"),count(distinct "OPER_STATUS"),sum(sys_op_opnsize("OPER_STATUS")),substrb(dump(min("OPER_STATUS"),16,0,32),1,120),substrb(dump(max("OPER_STATUS"),16,0,32),1,120),count("WM_LOCKMODE"),count(distinct "WM_LOCKMODE"),sum(sys_op_opnsize("WM_LOCKMODE")),substrb(dump(min("WM_LOCKMODE"),16,0,32),1,120),substrb(dump(max("WM_LOCKMODE"),16,0,32),1,120),count("ISREFRESHED"),count(distinct "ISREFRESHED"),sum(sys_op_opnsize("ISREFRESHED")),substrb(dump(min("ISR
EFRESHED"),16,0,32),1,120),substrb(dump(max("ISREFRESHED"),16,0,32),1,120),count("FREEZE_OWNER"),count(distinct "FREEZE_OWNER"),sum(sys_op_opnsize("FREEZE_OWNER")),substrb(dump(min("FREEZE_OWNER"),16,0,32),1,120),substrb(dump(max("FREEZE_OWNER"),16,0,32),1,120),count("SESSION_DURATION"),count(distinct "SESSION_DURATION"),sum(sys_op_opnsize("SESSION_DURATION")),substrb(dump(min("SESSION_DURATION"),16,0,32),1,120),substrb(dump(max("SESSION_DURATION"),16,0,32),1,120),count("IMPLICIT_SP_CNT"),count(distinct "IMPLICIT_SP_CNT"),sum(sys_op_opnsize("IMPLICIT_SP_CNT")),substrb(dump(min("IMPLICIT_SP_CNT"),16,0,32),1,120),substrb(dump(max("IMPLICIT_SP_CNT"),16,0,32),1,120),count("CR_STATUS"),count(distinct "CR_STATUS"),sum(sys_op_opnsize("CR_STATUS")),substrb(dump(min("CR_STATUS"),16,0,32),1,120),substrb(dump(max("CR_STATUS"),16,0,32),1,120),count("SYNC_PARVER"),count(distinct "SYNC_PARVER"),sum(sy
s_op_opnsize("SYNC_PARVER")),substrb(dump(min("SYNC_PARVER"),16,0,32),1,120),substrb(dump(max("SYNC_PARVER"),16,0,32),1,120),count("LAST_CHANGE"),count(distinct "LAST_CHANGE"),substrb(dump(min("LAST_CHANGE"),16,0,32),1,120),substrb(dump(max("LAST_CHANGE"),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("MP_ROOT"),count(distinct "MP_ROOT"),sum(sys_op_opnsize("MP_ROOT")),substrb(dump(min("MP_ROOT"),16,0,32),1,120),substrb(dump(max("MP_ROOT"),16,0,32),1,120) from "WMSYS"."WM$WORKSPACES_TABLE" t

select /*+ no_parallel_index(t,"WM$WORKSPACES_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"WM$WORKSPACES_PK") */ count(*) as nrw,count(distinct sys_op_lbid(9749,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "WMSYS"."WM$WORKSPACES_TABLE" t where "WORKSPACE" is not null
select /*+ no_parallel_index(t,"WORKSPACE_LOCK_ID_UNQ") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"WORKSPACE_LOCK_ID_UNQ") */ count(*) as nrw,count(distinct sys_op_lbid(10075,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "WMSYS"."WM$WORKSPACES_TABLE" t where "WORKSPACE_LOCK_ID" is not null

SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*)  from "WMSYS"."WM$WORKSPACE_PRIV_TABLE" 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("GRANTEE"),sum(sys_op_opnsize("GRANTEE")),count("WORKSPACE"),sum(sys_op_opnsize("WORKSPACE")),count("GRANTOR"),sum(sys_op_opnsize("GRANTOR")),count("PRIV"),sum(sys_op_opnsize("PRIV")),count("ADMIN"),sum(sys_op_opnsize("ADMIN")) from "WMSYS"."WM$WORKSPACE_PRIV_TABLE" t
select /*+ no_parallel_index(t,"WM$WS_PRIV_TAB_WS_GRTE_IND") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"WM$WS_PRIV_TAB_WS_GRTE_IND") */ count(*) as nrw,count(distinct sys_op_lbid(9799,'L',t.rowid)) as nlb,count(distinct hextoraw(sys_op_descend("WORKSPACE")||sys_op_descend("GRANTEE"))) as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "WMSYS"."WM$WORKSPACE_PRIV_TABLE" t where "WORKSPACE" is not null or "GRANTEE" is not null
select /*+ no_parallel_index(t,"WM$WS_PRIV_TAB_GRTE_IND") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"WM$WS_PRIV_TAB_GRTE_IND") */ count(*) as nrw,count(distinct sys_op_lbid(9800,'L',t.rowid)) as nlb,count(distinct "GRANTEE") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "WMSYS"."WM$WORKSPACE_PRIV_TABLE" t where "GRANTEE" is not null
select /*+ no_parallel_index(t,"WM$WS_PRIV_TAB_GRTOR_IND") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"WM$WS_PRIV_TAB_GRTOR_IND") */ count(*) as nrw,count(distinct sys_op_lbid(9801,'L',t.rowid)) as nlb,count(distinct "GRANTOR") as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "WMSYS"."WM$WORKSPACE_PRIV_TABLE" t where "GRANTOR" is not null
select a.snap_level   value  from perfstat.stats$snapshot a where a.ucomment=:"SYS_B_0"
select	count(*) from perfstat.stats$snapshot

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


A: SQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------SELECTc.cust_id,SUM(amount_sold)FROMsh.saless,sh.customerscWHEREs.cust_id=c.cust_idGROUPBYc.cust_idselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"DBSNMP"."MGMT_BASELINE"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_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"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"DBSNMP"."MGMT_BSLN_METRICS"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),sum(sys_op_opnsize("METRIC_UID")),substrb(dump(min("METRIC_UID"),16,0,32),1,120),substrb(dump(max("METRIC_UID"),16,0,32),1,120),count(distinct"TAIL_ESTIMATOR"),sum(sys_op_opnsize("TAIL_ESTIMATOR")),substrb(dump(min("TAIL_ESTIMATOR"),16,0,32),1,120),substrb(dump(max("TAIL_ESTIMATOR"),16,0,32),1,120),count(distinct"THRESHOLD_METHOD_DEFAULT"),sum(sys_op_opnsize("THRESHOLD_METHOD_DEFAULT")),substrb(dump(min("THRESHOLD_METHOD_DEFAULT"),16,0,32),1,120),substrb(dump(max("THRESHOLD_METHOD_DEFAULT"),16,0,32),1,120),count(distinct"NUM_OCCURRENCES_DEFAULT"),sum(sys_op_opnsize("NUM_OCCURRENCES_DEFAULT")),substrb(dump(min("NUM_OCCURRENCES_DEFAULT"),16,0,32),1,120),substrb(dump(max("NUM_OCCURRENCES_DEFAULT"),16,0,32),1,120),count(distinct"WARNING_PARAM_DEFAULT"),sum(sys_op_opnsize("WARNING_PARAM_DEFAULT")),substrb(dump(min("WARNING_PARAM_DEFAULT"),16,0,32),1,120),substrb(dump(max("WARNING_PARAM_DEFAULT"),16,0,32),1,120),count(distinct"CRITICAL_PARAM_DEFAULT"),sum(sys_op_opnsize("CRITICAL_PARAM_DEFAULT")),substrb(dump(min("CRITICAL_PARAM_DEFAULT"),16,0,32),1,120),substrb(dump(max("CRITICAL_PARAM_DEFAULT"),16,0,32),1,120)from"DBSNMP"."MGMT_BSLN_METRICS"tselect/*+no_parallel_index(t,"BSLN_METRICS_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"BSLN_METRICS_PK")*/count(*)asnrw,count(distinctsys_op_lbid(9651,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"DBSNMP"."MGMT_BSLN_METRICS"twhere"METRIC_UID"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"DBSNMP"."MGMT_RESPONSE_CONFIG"tSQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------select/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_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"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"DBSNMP"."MGMT_SNAPSHOT"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"HR"."COUNTRIES"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),substrb(dump(min("COUNTRY_ID"),16,0,32),1,120),substrb(dump(max("COUNTRY_ID"),16,0,32),1,120),count("COUNTRY_NAME"),count(distinct"COUNTRY_NAME"),sum(sys_op_opnsize("COUNTRY_NAME")),substrb(dump(min(substrb("COUNTRY_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("COUNTRY_NAME",1,32)),16,0,32),1,120),count("REGION_ID"),sum(sys_op_opnsize("REGION_ID"))from"HR"."COUNTRIES"tselect/*+no_parallel_index(t,"COUNTRY_C_ID_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex_ffs(t,"COUNTRY_C_ID_PK")*/count(*)asnrw,count(distinctsys_op_lbid(11701,'L',t.rowid))asnlb,nullasndk,nullasclffrom"HR"."COUNTRIES"twhere"COUNTRY_ID"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"HR"."DEPARTMENTS"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),sum(sys_op_opnsize("DEPARTMENT_ID")),substrb(dump(min("DEPARTMENT_ID"),16,0,32),1,120),substrb(dump(max("DEPARTMENT_ID"),16,0,32),1,120),count(distinct"DEPARTMENT_NAME"),sum(sys_op_opnsize("DEPARTMENT_NAME")),substrb(dump(min("DEPARTMENT_NAME"),16,0,32),1,120),substrb(dump(max("DEPARTMENT_NAME"),16,0,32),1,120),count("MANAGER_ID"),sum(sys_op_opnsize("MANAGER_ID")),count("LOCATION_ID"),sum(sys_op_opnsize("LOCATION_ID"))from"HR"."DEPARTMENTS"tselect/*+no_parallel_index(t,"DEPT_LOCATION_IX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"DEPT_LOCATION_IX")*/count(*)asnrw,count(distinctsys_op_lbid(11714,'L',t.rowid))asnlb,count(distinct"LOCATION_ID")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."DEPARTMENTS"twhere"LOCATION_ID"isnotnullselect/*+no_parallel_index(t,"DEPT_ID_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"DEPT_ID_PK")*/count(*)asnrw,count(distinctsys_op_lbid(11713,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."DEPARTMENTS"twhere"DEPARTMENT_ID"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"HR"."EMPLOYEES"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),sum(sys_op_opnsize("EMPLOYEE_ID")),substrb(dump(min("EMPLOYEE_ID"),16,0,32),1,120),substrb(dump(max("EMPLOYEE_ID"),16,0,32),1,120),count("FIRST_NAME"),count(distinct"FIRST_NAME"),sum(sys_op_opnsize("FIRST_NAME")),substrb(dump(min("FIRST_NAME"),16,0,32),1,120),substrb(dump(max("FIRST_NAME"),16,0,32),1,120),count(distinct"LAST_NAME"),sum(sys_op_opnsize("LAST_NAME")),substrb(dump(min("LAST_NAME"),16,0,32),1,120),substrb(dump(max("LAST_NAME"),16,0,32),1,120),sum(sys_op_opnsize("EMAIL")),substrb(dump(min("EMAIL"),16,0,32),1,120),substrb(dump(max("EMAIL"),16,0,32),1,120),count("PHONE_NUMBER"),count(distinct"PHONE_NUMBER"),sum(sys_op_opnsize("PHONE_NUMBER")),substrb(dump(min("PHONE_NUMBER"),16,0,32),1,120),substrb(dump(max("PHONE_NUMBER"),16,0,32),1,SQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------120),count(distinct"HIRE_DATE"),substrb(dump(min("HIRE_DATE"),16,0,32),1,120),substrb(dump(max("HIRE_DATE"),16,0,32),1,120),sum(sys_op_opnsize("JOB_ID")),count("SALARY"),sum(sys_op_opnsize("SALARY")),count("COMMISSION_PCT"),count(distinct"COMMISSION_PCT"),sum(sys_op_opnsize("COMMISSION_PCT")),substrb(dump(min("COMMISSION_PCT"),16,0,32),1,120),substrb(dump(max("COMMISSION_PCT"),16,0,32),1,120),count("MANAGER_ID"),sum(sys_op_opnsize("MANAGER_ID")),count("DEPARTMENT_ID"),sum(sys_op_opnsize("DEPARTMENT_ID"))from"HR"."EMPLOYEES"tselect/*+no_parallel_index(t,"EMP_EMAIL_UK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"EMP_EMAIL_UK")*/count(*)asnrw,count(distinctsys_op_lbid(11716,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."EMPLOYEES"twhere"EMAIL"isnotnullselect/*+no_parallel_index(t,"EMP_EMP_ID_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"EMP_EMP_ID_PK")*/count(*)asnrw,count(distinctsys_op_lbid(11717,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."EMPLOYEES"twhere"EMPLOYEE_ID"isnotnullselect/*+no_parallel_index(t,"EMP_DEPARTMENT_IX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"EMP_DEPARTMENT_IX")*/count(*)asnrw,count(distinctsys_op_lbid(11718,'L',t.rowid))asnlb,count(distinct"DEPARTMENT_ID")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."EMPLOYEES"twhere"DEPARTMENT_ID"isnotnullselect/*+no_parallel_index(t,"EMP_JOB_IX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"EMP_JOB_IX")*/count(*)asnrw,count(distinctsys_op_lbid(11719,'L',t.rowid))asnlb,count(distinct"JOB_ID")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."EMPLOYEES"twhere"JOB_ID"isnotnullselect/*+no_parallel_index(t,"EMP_MANAGER_IX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"EMP_MANAGER_IX")*/count(*)asnrw,count(distinctsys_op_lbid(11720,'L',t.rowid))asnlb,count(distinct"MANAGER_ID")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."EMPLOYEES"twhere"MANAGER_ID"isnotnullselect/*+no_parallel_index(t,"EMP_NAME_IX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"EMP_NAME_IX")*/count(*)asnrw,count(distinctsys_op_lbid(11721,'L',t.rowid))asnlb,count(distincthextoraw(sys_op_descend("LAST_NAME")||sys_op_descend("FIRST_NAME")))asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."EMPLOYEES"twhere"LAST_NAME"isnotnullor"FIRST_NAME"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"HR"."JOBS"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),sum(sys_op_opnsize("JOB_ID")),substrb(dump(min("JOB_ID"),16,0,32),1,120),substrb(dump(max("JOB_ID"),16,0,32),1,120),count(distinct"JOB_TITLE"),sum(sys_op_opnsize("JOB_TITLE")),substrb(dump(min(substrb("JOB_TITLE",1,32)),16,0,32),1,120),substrb(dump(max(substrb("JOB_TITLE",1,32)),16,0,32),1,120),count("MIN_SALARY"),count(distinct"MIN_SALARY"),sum(sys_op_opnsize("MIN_SALARY")),substrb(dump(min("MIN_SALARY"),16,0,32),1,120),substrb(dump(max("MIN_SALARY"),16,0,32),1,120),count("MAX_SALARY"),count(distinct"MAX_SALARY"),sum(sys_op_opnsize("MAX_SALARY")),substrb(dump(min("MAX_SALARY"),16,0,32),1,120),substrb(dump(max("MAX_SALARY"),16,0,32),1,120)from"HR"."JOBS"tselect/*+no_parallel_index(t,"JOB_ID_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"JOB_ID_PK")*/count(*)asnrw,count(distinctsys_op_lbid(11715,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."JOBS"twhere"JOB_ID"isnotnullSQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------select/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"HR"."JOB_HISTORY"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),sum(sys_op_opnsize("EMPLOYEE_ID")),count(distinct"START_DATE"),substrb(dump(min("START_DATE"),16,0,32),1,120),substrb(dump(max("START_DATE"),16,0,32),1,120),count(distinct"END_DATE"),substrb(dump(min("END_DATE"),16,0,32),1,120),substrb(dump(max("END_DATE"),16,0,32),1,120),sum(sys_op_opnsize("JOB_ID")),count("DEPARTMENT_ID"),sum(sys_op_opnsize("DEPARTMENT_ID"))from"HR"."JOB_HISTORY"tselect/*+no_parallel_index(t,"JHIST_EMP_ID_ST_DATE_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"JHIST_EMP_ID_ST_DATE_PK")*/count(*)asnrw,count(distinctsys_op_lbid(11722,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."JOB_HISTORY"twhere"EMPLOYEE_ID"isnotnullor"START_DATE"isnotnullselect/*+no_parallel_index(t,"JHIST_JOB_IX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"JHIST_JOB_IX")*/count(*)asnrw,count(distinctsys_op_lbid(11723,'L',t.rowid))asnlb,count(distinct"JOB_ID")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."JOB_HISTORY"twhere"JOB_ID"isnotnullselect/*+no_parallel_index(t,"JHIST_EMPLOYEE_IX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"JHIST_EMPLOYEE_IX")*/count(*)asnrw,count(distinctsys_op_lbid(11724,'L',t.rowid))asnlb,count(distinct"EMPLOYEE_ID")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."JOB_HISTORY"twhere"EMPLOYEE_ID"isnotnullselect/*+no_parallel_index(t,"JHIST_DEPARTMENT_IX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"JHIST_DEPARTMENT_IX")*/count(*)asnrw,count(distinctsys_op_lbid(11725,'L',t.rowid))asnlb,count(distinct"DEPARTMENT_ID")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."JOB_HISTORY"twhere"DEPARTMENT_ID"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"HR"."LOCATIONS"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),sum(sys_op_opnsize("LOCATION_ID")),substrb(dump(min("LOCATION_ID"),16,0,32),1,120),substrb(dump(max("LOCATION_ID"),16,0,32),1,120),count("STREET_ADDRESS"),count(distinct"STREET_ADDRESS"),sum(sys_op_opnsize("STREET_ADDRESS")),substrb(dump(min(substrb("STREET_ADDRESS",1,32)),16,0,32),1,120),substrb(dump(max(substrb("STREET_ADDRESS",1,32)),16,0,32),1,120),count("POSTAL_CODE"),count(distinct"POSTAL_CODE"),sum(sys_op_opnsize("POSTAL_CODE")),substrb(dump(min("POSTAL_CODE"),16,0,32),1,120),substrb(dump(max("POSTAL_CODE"),16,0,32),1,120),count(distinct"CITY"),sum(sys_op_opnsize("CITY")),substrb(dump(min("CITY"),16,0,32),1,120),substrb(dump(max("CITY"),16,0,32),1,120),count("STATE_PROVINCE"),count(distinct"STATE_PROVINCE"),sum(sys_op_opnsize("STATE_PROVINCE")),substrb(dump(min("STATE_PROVINCE"),16,0,32),1,120),substrb(dump(max("STATE_PROVINCE"),16,0,32),1,120),count("COUNTRY_ID")from"HR"."LOCATIONS"tselect/*+no_parallel_index(t,"LOC_ID_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"LOC_ID_PK")*/count(*)asnrw,count(distinctsys_op_lbid(11709,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."LOCATIONS"twhere"LOCATION_ID"isnotnullSQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------select/*+no_parallel_index(t,"LOC_CITY_IX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"LOC_CITY_IX")*/count(*)asnrw,count(distinctsys_op_lbid(11710,'L',t.rowid))asnlb,count(distinct"CITY")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."LOCATIONS"twhere"CITY"isnotnullselect/*+no_parallel_index(t,"LOC_STATE_PROVINCE_IX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"LOC_STATE_PROVINCE_IX")*/count(*)asnrw,count(distinctsys_op_lbid(11711,'L',t.rowid))asnlb,count(distinct"STATE_PROVINCE")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."LOCATIONS"twhere"STATE_PROVINCE"isnotnullselect/*+no_parallel_index(t,"LOC_COUNTRY_IX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"LOC_COUNTRY_IX")*/count(*)asnrw,count(distinctsys_op_lbid(11712,'L',t.rowid))asnlb,count(distinct"COUNTRY_ID")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."LOCATIONS"twhere"COUNTRY_ID"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"HR"."REGIONS"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),sum(sys_op_opnsize("REGION_ID")),substrb(dump(min("REGION_ID"),16,0,32),1,120),substrb(dump(max("REGION_ID"),16,0,32),1,120),count("REGION_NAME"),count(distinct"REGION_NAME"),sum(sys_op_opnsize("REGION_NAME")),substrb(dump(min("REGION_NAME"),16,0,32),1,120),substrb(dump(max("REGION_NAME"),16,0,32),1,120)from"HR"."REGIONS"tselect/*+no_parallel_index(t,"REG_ID_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"REG_ID_PK")*/count(*)asnrw,count(distinctsys_op_lbid(11708,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"HR"."REGIONS"twhere"REGION_ID"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"OLTP_USER"."SALES"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_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"tselect/*+no_parallel_index(t,"SALES_ID_IDX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"SALES_ID_IDX")*/count(*)asnrw,count(distinctsys_op_lbid(12053,'L',t.rowid))asnlb,count(distinct"SALES_ID")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"OLTP_USER"."SALES"twhere"SALES_ID"isnotnullselect/*+no_parallel_index(t,"NAME_IDX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"NAME_IDX")*/count(*)asnrw,count(distinctsys_op_lbid(12054,'L',t.rowid))asnlb,count(distinct"NAME")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"OLTP_USER"."SALES"twhere"NAME"isnotnullselect/*+no_parallel_index(t,"PROD_ID_IDX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"PROD_ID_IDX")*/count(*)asnrw,count(distinctsys_op_lbid(12055,'L',t.rowid))asnlb,count(distinct"PROD_ID")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"OLTP_USER"."SALES"twhere"PROD_ID"isnotnullSQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------select/*+no_parallel_index(t,"SDATE_IDX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"SDATE_IDX")*/count(*)asnrw,count(distinctsys_op_lbid(12056,'L',t.rowid))asnlb,count(distinct"SDATE")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"OLTP_USER"."SALES"twhere"SDATE"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"PERFSTAT"."STATS$IDLE_EVENT"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_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"tselect/*+no_parallel_index(t,"STATS$IDLE_EVENT_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"STATS$IDLE_EVENT_PK")*/count(*)asnrw,count(distinctsys_op_lbid(12360,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"PERFSTAT"."STATS$IDLE_EVENT"twhere"EVENT"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"PERFSTAT"."STATS$LEVEL_DESCRIPTION"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_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"tselect/*+no_parallel_index(t,"STATS$LEVEL_DESCRIPTION_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"STATS$LEVEL_DESCRIPTION_PK")*/count(*)asnrw,count(distinctsys_op_lbid(12164,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"PERFSTAT"."STATS$LEVEL_DESCRIPTION"twhere"SNAP_LEVEL"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"SH"."CAL_MONTH_SALES_MV"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),count(distinct"CALENDAR_MONTH_DESC"),sum(sys_op_opnsize("CALENDAR_MONTH_DESC")),substrb(dump(min("CALENDAR_MONTH_DESC"),16,0,32),1,120),substrb(dump(max("CALENDAR_MONTH_DESC"),16,0,32),1,120),count("DOLLARS"),count(distinct"DOLLARS"),sum(sys_op_opnsize("DOLLARS")),substrb(dump(min("DOLLARS"),16,0,32),1,120),substrb(dump(max("DOLLARS"),16,0,32),1,120)from"SH"."CAL_MONTH_SALES_MV"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"SH"."CHANNELS"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),sum(sys_op_opnsize("CHANNEL_ID")),substrb(dump(min("CHANNEL_ID"),16,0,32),1,120),substrb(dump(max("CHANNEL_ID"),16,0,32),1,120),count(distinct"CHANNEL_DESC"),sum(sys_op_opnsize("CHANNEL_DESC")),substrb(dump(min("CHANNEL_DESC"),16,0,32),1,120),substrb(dump(max("CHANNEL_DESC"),16,0,32),1,120),count(distinct"CHANNEL_CLASS"),sum(sys_op_opnsize("CHANNEL_CLASS")),substrb(dump(min("CHANNEL_CLASS"),16,0,32),1,120),substrb(dump(max("CHANNEL_CLASS"),16,0,32),1,120),count(distinct"CHANNEL_CLASS_ID"),sum(sys_op_opnsize("CHANNEL_CLASS_ID")),substrb(dump(min("CHANNEL_CLASS_ID"),16,0,32),1,120),substrb(dump(max("CHANNEL_CLASS_ID"),16,0,32),1,120),count(distinct"CHANNEL_TOTAL"),sum(sys_op_opnsize("CHANNEL_TOTAL")),substrb(dump(min("CHANNEL_TOTAL"),16,0,32),1SQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------,120),substrb(dump(max("CHANNEL_TOTAL"),16,0,32),1,120),count(distinct"CHANNEL_TOTAL_ID"),sum(sys_op_opnsize("CHANNEL_TOTAL_ID")),substrb(dump(min("CHANNEL_TOTAL_ID"),16,0,32),1,120),substrb(dump(max("CHANNEL_TOTAL_ID"),16,0,32),1,120)from"SH"."CHANNELS"tselect/*+no_parallel_index(t,"CHANNELS_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"CHANNELS_PK")*/count(*)asnrw,count(distinctsys_op_lbid(11825,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"SH"."CHANNELS"twhere"CHANNEL_ID"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"SH"."COSTS"twhereTBL$OR$IDX$PART$NUM("SH"."COSTS",0,4,0,"ROWID")=:objnselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),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(distinct"TIME_ID"),substrb(dump(min("TIME_ID"),16,0,32),1,120),substrb(dump(max("TIME_ID"),16,0,32),1,120),count(distinct"PROMO_ID"),sum(sys_op_opnsize("PROMO_ID")),substrb(dump(min("PROMO_ID"),16,0,32),1,120),substrb(dump(max("PROMO_ID"),16,0,32),1,120),count(distinct"CHANNEL_ID"),sum(sys_op_opnsize("CHANNEL_ID")),substrb(dump(min("CHANNEL_ID"),16,0,32),1,120),substrb(dump(max("CHANNEL_ID"),16,0,32),1,120),count(distinct"UNIT_COST"),sum(sys_op_opnsize("UNIT_COST")),substrb(dump(min("UNIT_COST"),16,0,32),1,120),substrb(dump(max("UNIT_COST"),16,0,32),1,120),count(distinct"UNIT_PRICE"),sum(sys_op_opnsize("UNIT_PRICE")),substrb(dump(min("UNIT_PRICE"),16,0,32),1,120),substrb(dump(max("UNIT_PRICE"),16,0,32),1,120)from"SH"."COSTS"twhereTBL$OR$IDX$PART$NUM("SH"."COSTS",0,4,0,"ROWID")=:objnselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"SH"."COSTS"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),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(distinct"TIME_ID"),substrb(dump(min("TIME_ID"),16,0,32),1,120),substrb(dump(max("TIME_ID"),16,0,32),1,120),count(distinct"PROMO_ID"),sum(sys_op_opnsize("PROMO_ID")),substrb(dump(min("PROMO_ID"),16,0,32),1,120),substrb(dump(max("PROMO_ID"),16,0,32),1,120),count(distinct"CHANNEL_ID"),sum(sys_op_opnsize("CHANNEL_ID")),substrb(dump(min("CHANNEL_ID"),16,0,32),1,120),substrb(dump(max("CHANNEL_ID"),16,0,32),1,120),count(distinct"UNIT_COST"),sum(sys_op_opnsize("UNIT_COST")),substrb(dump(min("UNIT_COST"),16,0,32),1,120),substrb(dump(max("UNIT_COST"),16,0,32),1,120),count(distinct"UNIT_PRICE"),sum(sys_op_opnsize("UNIT_PRICE")),substrb(dump(min("UNIT_PRICE"),16,0,32),1,120),substrb(dump(max("UNIT_PRICE"),16,0,32),1,120)from"SH"."COSTS"sample(6.6981683554)tSQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------select/*+no_parallel_index(t,"COSTS_PROD_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"COSTS_PROD_BIX")*/count(distinctsys_op_lbid(11975,'R',t.rowid))asnrw,count(distinctsys_op_lbid(11975,'L',t.rowid))asnlb,count(distinct"PROD_ID")asndk,nullasclffrom"SH"."COSTS"twhereTBL$OR$IDX$PART$NUM("SH"."COSTS",0,4,0,"ROWID")=:objnselect/*+no_parallel_index(t,"COSTS_PROD_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"COSTS_PROD_BIX")*/count(distinctsys_op_lbid(11975,'R',t.rowid))asnrw,count(distinctsys_op_lbid(11975,'L',t.rowid))asnlb,count(distinct"PROD_ID")asndk,nullasclffrom"SH"."COSTS"tselect/*+no_parallel_index(t,"COSTS_TIME_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"COSTS_TIME_BIX")*/count(distinctsys_op_lbid(12004,'R',t.rowid))asnrw,count(distinctsys_op_lbid(12004,'L',t.rowid))asnlb,count(distinct"TIME_ID")asndk,nullasclffrom"SH"."COSTS"twhereTBL$OR$IDX$PART$NUM("SH"."COSTS",0,4,0,"ROWID")=:objnselect/*+no_parallel_index(t,"COSTS_TIME_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"COSTS_TIME_BIX")*/count(distinctsys_op_lbid(12004,'R',t.rowid))asnrw,count(distinctsys_op_lbid(12004,'L',t.rowid))asnlb,count(distinct"TIME_ID")asndk,nullasclffrom"SH"."COSTS"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"SH"."COUNTRIES"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),sum(sys_op_opnsize("COUNTRY_ID")),substrb(dump(min("COUNTRY_ID"),16,0,32),1,120),substrb(dump(max("COUNTRY_ID"),16,0,32),1,120),count(distinct"COUNTRY_ISO_CODE"),substrb(dump(min("COUNTRY_ISO_CODE"),16,0,32),1,120),substrb(dump(max("COUNTRY_ISO_CODE"),16,0,32),1,120),count(distinct"COUNTRY_NAME"),sum(sys_op_opnsize("COUNTRY_NAME")),substrb(dump(min(substrb("COUNTRY_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("COUNTRY_NAME",1,32)),16,0,32),1,120),count(distinct"COUNTRY_SUBREGION"),sum(sys_op_opnsize("COUNTRY_SUBREGION")),substrb(dump(min("COUNTRY_SUBREGION"),16,0,32),1,120),substrb(dump(max("COUNTRY_SUBREGION"),16,0,32),1,120),count(distinct"COUNTRY_SUBREGION_ID"),sum(sys_op_opnsize("COUNTRY_SUBREGION_ID")),substrb(dump(min("COUNTRY_SUBREGION_ID"),16,0,32),1,120),substrb(dump(max("COUNTRY_SUBREGION_ID"),16,0,32),1,120),count(distinct"COUNTRY_REGION"),sum(sys_op_opnsize("COUNTRY_REGION")),substrb(dump(min("COUNTRY_REGION"),16,0,32),1,120),substrb(dump(max("COUNTRY_REGION"),16,0,32),1,120),count(distinct"COUNTRY_REGION_ID"),sum(sys_op_opnsize("COUNTRY_REGION_ID")),substrb(dump(min("COUNTRY_REGION_ID"),16,0,32),1,120),substrb(dump(max("COUNTRY_REGION_ID"),16,0,32),1,120),count(distinct"COUNTRY_TOTAL"),sum(sys_op_opnsize("COUNTRY_TOTAL")),substrb(dump(min("COUNTRY_TOTAL"),16,0,32),1,120),substrb(dump(max("COUNTRY_TOTAL"),16,0,32),1,120),count(distinct"COUNTRY_TOTAL_ID"),sum(sys_op_opnsize("COUNTRY_TOTAL_ID")),substrb(dump(min("COUNTRY_TOTAL_ID"),16,0,32),1,120),substrb(dump(max("COUNTRY_TOTAL_ID"),16,0,32),1,120),count("COUNTRY_NAME_HIST"),count(distinct"COUNTRY_NAME_HIST"),sum(sys_op_opnsize("COUNTRY_NAME_HIST")),substrb(dump(min(substrb("COUNTRY_NAME_HIST",1,32)),16,0,32),1,120),substrb(dump(max(substrb("COUNTRY_NAME_HIST",1,32)),16,0,32),1,120)from"SH"."COUNTRIES"tselect/*+no_parallel_index(t,"COUNTRIES_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"COUNTRIES_PK")*/count(*)asnrw,count(distinctsys_op_lbid(11828,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"SH"."COUNTRIES"twhere"COUNTRY_ID"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"SH"."CUSTOMERS"sampleblock(6.7658998647,1)tSQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------select/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"SH"."CUSTOMERS"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),sum(sys_op_opnsize("CUST_ID")),substrb(dump(min("CUST_ID"),16,0,32),1,120),substrb(dump(max("CUST_ID"),16,0,32),1,120),count(distinct"CUST_FIRST_NAME"),sum(sys_op_opnsize("CUST_FIRST_NAME")),substrb(dump(min("CUST_FIRST_NAME"),16,0,32),1,120),substrb(dump(max("CUST_FIRST_NAME"),16,0,32),1,120),count(distinct"CUST_LAST_NAME"),sum(sys_op_opnsize("CUST_LAST_NAME")),substrb(dump(min(substrb("CUST_LAST_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("CUST_LAST_NAME",1,32)),16,0,32),1,120),count(distinct"CUST_GENDER"),substrb(dump(min("CUST_GENDER"),16,0,32),1,120),substrb(dump(max("CUST_GENDER"),16,0,32),1,120),count(distinct"CUST_YEAR_OF_BIRTH"),sum(sys_op_opnsize("CUST_YEAR_OF_BIRTH")),substrb(dump(min("CUST_YEAR_OF_BIRTH"),16,0,32),1,120),substrb(dump(max("CUST_YEAR_OF_BIRTH"),16,0,32),1,120),count("CUST_MARITAL_STATUS"),count(distinct"CUST_MARITAL_STATUS"),sum(sys_op_opnsize("CUST_MARITAL_STATUS")),substrb(dump(min("CUST_MARITAL_STATUS"),16,0,32),1,120),substrb(dump(max("CUST_MARITAL_STATUS"),16,0,32),1,120),count(distinct"CUST_STREET_ADDRESS"),sum(sys_op_opnsize("CUST_STREET_ADDRESS")),substrb(dump(min(substrb("CUST_STREET_ADDRESS",1,32)),16,0,32),1,120),substrb(dump(max(substrb("CUST_STREET_ADDRESS",1,32)),16,0,32),1,120),count(distinct"CUST_POSTAL_CODE"),sum(sys_op_opnsize("CUST_POSTAL_CODE")),substrb(dump(min("CUST_POSTAL_CODE"),16,0,32),1,120),substrb(dump(max("CUST_POSTAL_CODE"),16,0,32),1,120),count(distinct"CUST_CITY"),sum(sys_op_opnsize("CUST_CITY")),substrb(dump(min("CUST_CITY"),16,0,32),1,120),substrb(dump(max("CUST_CITY"),16,0,32),1,120),count(distinct"CUST_CITY_ID"),sum(sys_op_opnsize("CUST_CITY_ID")),substrb(dump(min("CUST_CITY_ID"),16,0,32),1,120),substrb(dump(max("CUST_CITY_ID"),16,0,32),1,120),count(distinct"CUST_STATE_PROVINCE"),sum(sys_op_opnsize("CUST_STATE_PROVINCE")),substrb(dump(min(substrb("CUST_STATE_PROVINCE",1,32)),16,0,32),1,120),substrb(dump(max(substrb("CUST_STATE_PROVINCE",1,32)),16,0,32),1,120),count(distinct"CUST_STATE_PROVINCE_ID"),sum(sys_op_opnsize("CUST_STATE_PROVINCE_ID")),substrb(dump(min("CUST_STATE_PROVINCE_ID"),16,0,32),1,120),substrb(dump(max("CUST_STATE_PROVINCE_ID"),16,0,32),1,120),count(distinct"COUNTRY_ID"),sum(sys_op_opnsize("COUNTRY_ID")),substrb(dump(min("COUNTRY_ID"),16,0,32),1,120),substrb(dump(max("COUNTRY_ID"),16,0,32),1,120),count(distinct"CUST_MAIN_PHONE_NUMBER"),sum(sys_op_opnsize("CUST_MAIN_PHONE_NUMBER")),substrb(dump(min("CUST_MAIN_PHONE_NUMBER"),16,0,32),1,120),substrb(dump(max("CUST_MAIN_PHONE_NUMBER"),16,0,32),1,120),count("CUST_INCOME_LEVEL"),count(distinct"CUST_INCOME_LEVEL"),sum(sys_op_opnsize("CUST_INCOME_LEVEL")),substrb(dump(min("CUST_INCOME_LEVEL"),16,0,32),1,120),substrb(dump(max("CUST_INCOME_LEVEL"),16,0,32),1,120),count("CUST_CREDIT_LIMIT"),count(distinct"CUST_CREDIT_LIMIT"),sum(sys_op_opnsize("CUST_CREDIT_LIMIT")),substrb(dump(min("CUST_CREDIT_LIMIT"),16,0,32),1,120),substrb(dump(max("CUST_CREDIT_LIMIT"),16,0,32),1,120),count("CUST_EMAIL"),count(distinct"CUST_EMAIL"),sum(sys_op_opnsize("CUST_EMAIL")),substrb(dump(min("CUST_EMAIL"),16,0,32),1,120),substrb(dump(max("CUST_EMAIL"),16,0,32),1,120),count(distinct"CUST_TOTAL"),sum(sys_op_opnsize("CUST_TOTAL")),substrb(dump(min("CUST_TOTAL"),16,0,32),1,120),substrb(dump(max("CUST_TOTAL"),16,0,32),1,120),count(distinct"CUST_TOTAL_ID"),sum(sys_op_opnsize("CUST_TOTAL_ID")),substrb(dump(min("CUST_TOTAL_ID"),16,0,32),1,120),substrb(dump(max("CUST_TOTAL_ID"),16,0,32),1,120),count("CUST_SRC_ID"),count(distinct"CUST_SRC_ID"),sum(sys_op_opnsize("CUST_SRC_ID")),substrb(dump(min("CUST_SRC_ID"),16,0,32),1,120),substrb(dump(max("CUST_SRC_ID"),16,0,32),1,120),count("CUST_EFF_FROM"),count(distinct"CUST_EFF_FROM"),substrb(dump(min("CUST_EFF_FROM"),16,0,32),1,120),substrb(dump(max("CUST_EFF_FROM"),16,0,32),1,120),count("CUST_EFF_TO"),count(distinct"CUST_EFF_TO"),substrb(dump(min("CUST_EFF_TO"),16,0,32),1,120),substrb(dump(max("CUST_EFF_TO"),16,0,32),1,120),count("CUST_VALID"),count(distinct"CUST_VALID"),sum(sys_op_opnsize("CUST_VALID")),substrb(dump(min("CUST_VALID"),16,0,32),1,120),substrb(dump(max("CUST_VALID"),16,0,32),1,120),count(UPPER("CUST_LAST_NAME")),count(distinctUPPER("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)from"SH"."CUSTOMERS"sample(9.9099099099)tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),count(distinct"CUST_STREET_ADDRESS"),count(distinct"CUST_MAIN_PHONE_NUMBER"),count("CUST_SRC_ID"),count(distinct"CUST_SRC_ID"),sum(sys_op_opnsize("CUST_SRC_ID")),substrb(dump(min("CUST_SRC_ID"),16,0,32),1,120),substrb(dump(max("CUST_SRC_ID"),16,0,32),1,120),count("CUST_EFF_TO"),count(distinct"CUST_EFF_TO"),substrb(dump(min("CUST_EFF_TO"),16,0,32),1,120),substrb(dump(max("CUST_EFF_TO"),16,0,32),1,120)from"SH"."CUSTOMERS"tselect/*+no_parallel_index(t,"CUSTOMERS_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"CUSTOMERS_PK")*/count(*)asnrw,count(distinctsys_op_lbid(11827,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"SH"."CUSTOMERS"twhere"CUST_ID"isnotnullselect/*+no_parallel_index(t,"CUSTOMERS_GENDER_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"CUSTOMERS_GENDER_BIX")*/count(distinctsys_op_lbid(12034,'R',t.rowid))asnrw,count(distinctsys_op_lbid(12034,'L',t.rowid))asnlb,count(distinct"CUST_GENDER")asndk,nullasclffrom"SH"."CUSTOMERS"tSQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------select/*+no_parallel_index(t,"CUSTOMERS_MARITAL_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"CUSTOMERS_MARITAL_BIX")*/count(distinctsys_op_lbid(12035,'R',t.rowid))asnrw,count(distinctsys_op_lbid(12035,'L',t.rowid))asnlb,count(distinct"CUST_MARITAL_STATUS")asndk,nullasclffrom"SH"."CUSTOMERS"tselect/*+no_parallel_index(t,"CUSTOMERS_YOB_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"CUSTOMERS_YOB_BIX")*/count(distinctsys_op_lbid(12036,'R',t.rowid))asnrw,count(distinctsys_op_lbid(12036,'L',t.rowid))asnlb,count(distinct"CUST_YEAR_OF_BIRTH")asndk,nullasclffrom"SH"."CUSTOMERS"tselect/*+no_parallel_index(t,"IND_CUST_LAST_NAME")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"IND_CUST_LAST_NAME")*/count(*)asnrw,count(distinctsys_op_lbid(12116,'L',t.rowid))asnlb,count(distinctUPPER("CUST_LAST_NAME"))asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"SH"."CUSTOMERS"twhereUPPER("CUST_LAST_NAME")isnotnullselect/*+no_parallel_index(t,"IND_COUNTRY_CITY")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"IND_COUNTRY_CITY")*/count(*)asnrw,count(distinctsys_op_lbid(12121,'L',t.rowid))asnlb,count(distincthextoraw(sys_op_descend("COUNTRY_ID")||sys_op_descend("CUST_CITY")))asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"SH"."CUSTOMERS"twhere"COUNTRY_ID"isnotnullor"CUST_CITY"isnotnullselect/*+no_parallel_index(t,"IND_COUNTRY_ID_BIT")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"IND_COUNTRY_ID_BIT")*/count(distinctsys_op_lbid(12122,'R',t.rowid))asnrw,count(distinctsys_op_lbid(12122,'L',t.rowid))asnlb,count(distinct"COUNTRY_ID")asndk,nullasclffrom"SH"."CUSTOMERS"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"SH"."FWEEK_PSCAT_SALES_MV"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),count(distinct"WEEK_ENDING_DAY"),substrb(dump(min("WEEK_ENDING_DAY"),16,0,32),1,120),substrb(dump(max("WEEK_ENDING_DAY"),16,0,32),1,120),count(distinct"PROD_SUBCATEGORY"),sum(sys_op_opnsize("PROD_SUBCATEGORY")),substrb(dump(min(substrb("PROD_SUBCATEGORY",1,32)),16,0,32),1,120),substrb(dump(max(substrb("PROD_SUBCATEGORY",1,32)),16,0,32),1,120),count("DOLLARS"),count(distinct"DOLLARS"),sum(sys_op_opnsize("DOLLARS")),substrb(dump(min("DOLLARS"),16,0,32),1,120),substrb(dump(max("DOLLARS"),16,0,32),1,120),count(distinct"CHANNEL_ID"),sum(sys_op_opnsize("CHANNEL_ID")),substrb(dump(min("CHANNEL_ID"),16,0,32),1,120),substrb(dump(max("CHANNEL_ID"),16,0,32),1,120),count(distinct"PROMO_ID"),sum(sys_op_opnsize("PROMO_ID")),substrb(dump(min("PROMO_ID"),16,0,32),1,120),substrb(dump(max("PROMO_ID"),16,0,32),1,120)from"SH"."FWEEK_PSCAT_SALES_MV"tselect/*+no_parallel_index(t,"FW_PSC_S_MV_SUBCAT_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"FW_PSC_S_MV_SUBCAT_BIX")*/count(distinctsys_op_lbid(12037,'R',t.rowid))asnrw,count(distinctsys_op_lbid(12037,'L',t.rowid))asnlb,count(distinct"PROD_SUBCATEGORY")asndk,nullasclffrom"SH"."FWEEK_PSCAT_SALES_MV"tselect/*+no_parallel_index(t,"FW_PSC_S_MV_CHAN_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"FW_PSC_S_MV_CHAN_BIX")*/count(distinctsys_op_lbid(12038,'R',t.rowid))asnrw,count(distinctsys_op_lbid(12038,'L',t.rowid))asnlb,count(distinct"CHANNEL_ID")asndk,nullasclffrom"SH"."FWEEK_PSCAT_SALES_MV"tSQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------select/*+no_parallel_index(t,"FW_PSC_S_MV_PROMO_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"FW_PSC_S_MV_PROMO_BIX")*/count(distinctsys_op_lbid(12039,'R',t.rowid))asnrw,count(distinctsys_op_lbid(12039,'L',t.rowid))asnlb,count(distinct"PROMO_ID")asndk,nullasclffrom"SH"."FWEEK_PSCAT_SALES_MV"tselect/*+no_parallel_index(t,"FW_PSC_S_MV_WD_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"FW_PSC_S_MV_WD_BIX")*/count(distinctsys_op_lbid(12040,'R',t.rowid))asnrw,count(distinctsys_op_lbid(12040,'L',t.rowid))asnlb,count(distinct"WEEK_ENDING_DAY")asndk,nullasclffrom"SH"."FWEEK_PSCAT_SALES_MV"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"SH"."PRODUCTS"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),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(distinct"PROD_NAME"),sum(sys_op_opnsize("PROD_NAME")),substrb(dump(min(substrb("PROD_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("PROD_NAME",1,32)),16,0,32),1,120),count(distinct"PROD_DESC"),sum(sys_op_opnsize("PROD_DESC")),substrb(dump(min(substrb("PROD_DESC",1,32)),16,0,32),1,120),substrb(dump(max(substrb("PROD_DESC",1,32)),16,0,32),1,120),count(distinct"PROD_SUBCATEGORY"),sum(sys_op_opnsize("PROD_SUBCATEGORY")),substrb(dump(min(substrb("PROD_SUBCATEGORY",1,32)),16,0,32),1,120),substrb(dump(max(substrb("PROD_SUBCATEGORY",1,32)),16,0,32),1,120),count(distinct"PROD_SUBCATEGORY_ID"),sum(sys_op_opnsize("PROD_SUBCATEGORY_ID")),substrb(dump(min("PROD_SUBCATEGORY_ID"),16,0,32),1,120),substrb(dump(max("PROD_SUBCATEGORY_ID"),16,0,32),1,120),count(distinct"PROD_SUBCATEGORY_DESC"),sum(sys_op_opnsize("PROD_SUBCATEGORY_DESC")),substrb(dump(min(substrb("PROD_SUBCATEGORY_DESC",1,32)),16,0,32),1,120),substrb(dump(max(substrb("PROD_SUBCATEGORY_DESC",1,32)),16,0,32),1,120),count(distinct"PROD_CATEGORY"),sum(sys_op_opnsize("PROD_CATEGORY")),substrb(dump(min(substrb("PROD_CATEGORY",1,32)),16,0,32),1,120),substrb(dump(max(substrb("PROD_CATEGORY",1,32)),16,0,32),1,120),count(distinct"PROD_CATEGORY_ID"),sum(sys_op_opnsize("PROD_CATEGORY_ID")),substrb(dump(min("PROD_CATEGORY_ID"),16,0,32),1,120),substrb(dump(max("PROD_CATEGORY_ID"),16,0,32),1,120),count(distinct"PROD_CATEGORY_DESC"),sum(sys_op_opnsize("PROD_CATEGORY_DESC")),substrb(dump(min(substrb("PROD_CATEGORY_DESC",1,32)),16,0,32),1,120),substrb(dump(max(substrb("PROD_CATEGORY_DESC",1,32)),16,0,32),1,120),count(distinct"PROD_WEIGHT_CLASS"),sum(sys_op_opnsize("PROD_WEIGHT_CLASS")),substrb(dump(min("PROD_WEIGHT_CLASS"),16,0,32),1,120),substrb(dump(max("PROD_WEIGHT_CLASS"),16,0,32),1,120),count("PROD_UNIT_OF_MEASURE"),count(distinct"PROD_UNIT_OF_MEASURE"),sum(sys_op_opnsize("PROD_UNIT_OF_MEASURE")),substrb(dump(min("PROD_UNIT_OF_MEASURE"),16,0,32),1,120),substrb(dump(max("PROD_UNIT_OF_MEASURE"),16,0,32),1,120),count(distinct"PROD_PACK_SIZE"),sum(sys_op_opnsize("PROD_PACK_SIZE")),substrb(dump(min("PROD_PACK_SIZE"),16,0,32),1,120),substrb(dump(max("PROD_PACK_SIZE"),16,0,32),1,120),count(distinct"SUPPLIER_ID"),sum(sys_op_opnsize("SUPPLIER_ID")),substrb(dump(min("SUPPLIER_ID"),16,0,32),1,120),substrb(dump(max("SUPPLIER_ID"),16,0,32),1,120),count(distinct"PROD_STATUS"),sum(sys_op_opnsize("PROD_STATUS")),substrb(dump(min("PROD_STATUS"),16,0,32),1,120),substrb(dump(max("PROD_STATUS"),16,0,32),1,120),count(distinct"PROD_LIST_PRICE"),sum(sys_op_opnsize("PROD_LIST_PRICE")),substrb(dump(min("PROD_LIST_PRICE"),16,0,32),1,120),substrb(dump(max("PROD_LIST_PRICE"),16,0,32),1,120),count(distinct"PROD_MIN_PRICE"),sum(sys_op_opnsize("PROD_MIN_PRICE")),substrb(dump(min("PROD_MIN_PRICE"),16,0,32),1,120),substrb(dump(max("PROD_MIN_PRICE"),16,0,32),1,120),count(distinct"PROD_TOTAL"),sum(sys_op_opnsize("PROD_TOTAL")),substrb(dump(min("PROD_TOTAL"),16,0,32),1,120),substrb(dump(max("PROD_TOTAL"),16,0,32),1,120),count(distinct"PROD_TOTAL_ID"),sum(sys_op_opnsize("PROD_TOTAL_ID")),substrb(dump(min("PROD_TOTAL_ID"),16,0,32),1,120),substrb(dump(max("PROD_TOTAL_ID"),16,0,32),1,120),count("PROD_SRC_ID"),count(distinct"PROD_SRC_ID"),sum(sys_op_opnsize("PROD_SRC_ID")),substrb(dump(min("PROD_SRC_ID"),16,0,32),1,120),substrb(dump(max("PROD_SRC_ID"),16,0,32),1,120),count("PROD_EFF_FROM"),count(distinct"PROD_EFF_FROM"),substrb(dump(min("PROD_EFF_FROM"),16,0,32),1,120),substrb(dump(max("PROD_EFF_FROM"),16,0,32),1,120),count("PROD_EFF_TO"),count(distinct"PROD_EFF_TO"),substrb(dump(min("PROD_EFF_TO"),16,0,32),1,120),substrb(dump(max("PROD_EFF_TO"),16,0,32),1,120),count("PROD_VALID"),count(distinct"PROD_VALID"),sum(sys_op_opnsize("PROD_VALID")),substrb(dump(min("PROD_VALID"),16,0,32),1,120),substrb(dump(max("PROD_VALID"),16,0,32),1,120)from"SH"."PRODUCTS"tselect/*+no_parallel_index(t,"PRODUCTS_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"PRODUCTS_PK")*/count(*)asnrw,count(distinctsys_op_lbid(11822,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"SH"."PRODUCTS"twhere"PROD_ID"isnotnullselect/*+no_parallel_index(t,"PRODUCTS_PROD_SUBCAT_IX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"PRODUCTS_PROD_SUBCAT_IX")*/count(*)asnrw,count(distinctsys_op_lbid(11823,'L',t.rowid))asnlb,count(distinct"PROD_SUBCATEGORY")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"SH"."PRODUCTS"twhere"PROD_SUBCATEGORY"isnotnullSQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------select/*+no_parallel_index(t,"PRODUCTS_PROD_CAT_IX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"PRODUCTS_PROD_CAT_IX")*/count(*)asnrw,count(distinctsys_op_lbid(11824,'L',t.rowid))asnlb,count(distinct"PROD_CATEGORY")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"SH"."PRODUCTS"twhere"PROD_CATEGORY"isnotnullselect/*+no_parallel_index(t,"PRODUCTS_PROD_STATUS_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"PRODUCTS_PROD_STATUS_BIX")*/count(distinctsys_op_lbid(12033,'R',t.rowid))asnrw,count(distinctsys_op_lbid(12033,'L',t.rowid))asnlb,count(distinct"PROD_STATUS")asndk,nullasclffrom"SH"."PRODUCTS"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"SH"."PROMOTIONS"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),sum(sys_op_opnsize("PROMO_ID")),substrb(dump(min("PROMO_ID"),16,0,32),1,120),substrb(dump(max("PROMO_ID"),16,0,32),1,120),count(distinct"PROMO_NAME"),sum(sys_op_opnsize("PROMO_NAME")),substrb(dump(min("PROMO_NAME"),16,0,32),1,120),substrb(dump(max("PROMO_NAME"),16,0,32),1,120),count(distinct"PROMO_SUBCATEGORY"),sum(sys_op_opnsize("PROMO_SUBCATEGORY")),substrb(dump(min("PROMO_SUBCATEGORY"),16,0,32),1,120),substrb(dump(max("PROMO_SUBCATEGORY"),16,0,32),1,120),count(distinct"PROMO_SUBCATEGORY_ID"),sum(sys_op_opnsize("PROMO_SUBCATEGORY_ID")),substrb(dump(min("PROMO_SUBCATEGORY_ID"),16,0,32),1,120),substrb(dump(max("PROMO_SUBCATEGORY_ID"),16,0,32),1,120),count(distinct"PROMO_CATEGORY"),sum(sys_op_opnsize("PROMO_CATEGORY")),substrb(dump(min("PROMO_CATEGORY"),16,0,32),1,120),substrb(dump(max("PROMO_CATEGORY"),16,0,32),1,120),count(distinct"PROMO_CATEGORY_ID"),sum(sys_op_opnsize("PROMO_CATEGORY_ID")),substrb(dump(min("PROMO_CATEGORY_ID"),16,0,32),1,120),substrb(dump(max("PROMO_CATEGORY_ID"),16,0,32),1,120),count(distinct"PROMO_COST"),sum(sys_op_opnsize("PROMO_COST")),substrb(dump(min("PROMO_COST"),16,0,32),1,120),substrb(dump(max("PROMO_COST"),16,0,32),1,120),count(distinct"PROMO_BEGIN_DATE"),substrb(dump(min("PROMO_BEGIN_DATE"),16,0,32),1,120),substrb(dump(max("PROMO_BEGIN_DATE"),16,0,32),1,120),count(distinct"PROMO_END_DATE"),substrb(dump(min("PROMO_END_DATE"),16,0,32),1,120),substrb(dump(max("PROMO_END_DATE"),16,0,32),1,120),count(distinct"PROMO_TOTAL"),sum(sys_op_opnsize("PROMO_TOTAL")),substrb(dump(min("PROMO_TOTAL"),16,0,32),1,120),substrb(dump(max("PROMO_TOTAL"),16,0,32),1,120),count(distinct"PROMO_TOTAL_ID"),sum(sys_op_opnsize("PROMO_TOTAL_ID")),substrb(dump(min("PROMO_TOTAL_ID"),16,0,32),1,120),substrb(dump(max("PROMO_TOTAL_ID"),16,0,32),1,120)from"SH"."PROMOTIONS"tselect/*+no_parallel_index(t,"PROMO_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"PROMO_PK")*/count(*)asnrw,count(distinctsys_op_lbid(11826,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"SH"."PROMOTIONS"twhere"PROMO_ID"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"SH"."SALES"twhereTBL$OR$IDX$PART$NUM("SH"."SALES",0,4,0,"ROWID")=:objncreateglobaltemporarytablesys.ora_temp_1_ds_9oncommitpreserverowscachenoparallelasselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/"PROD_ID","CUST_ID","TIME_ID","CHANNEL_ID","PROMO_ID","QUANTITY_SOLD","AMOUNT_SOLD"from"SH"."SALES"sample(12.5895575343)twhere1=2select/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"SH"."SALES"sampleblock(6.3411540900,1)tSQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------select/*+no_parallel_index(t,"SALES_PROD_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"SALES_PROD_BIX")*/count(distinctsys_op_lbid(11830,'R',t.rowid))asnrw,count(distinctsys_op_lbid(11830,'L',t.rowid))asnlb,count(distinct"PROD_ID")asndk,nullasclffrom"SH"."SALES"twhereTBL$OR$IDX$PART$NUM("SH"."SALES",0,4,0,"ROWID")=:objnselect/*+no_parallel_index(t,"SALES_PROD_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"SALES_PROD_BIX")*/count(distinctsys_op_lbid(11830,'R',t.rowid))asnrw,count(distinctsys_op_lbid(11830,'L',t.rowid))asnlb,count(distinct"PROD_ID")asndk,nullasclffrom"SH"."SALES"tselect/*+no_parallel_index(t,"SALES_CUST_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"SALES_CUST_BIX")*/count(distinctsys_op_lbid(11859,'R',t.rowid))asnrw,count(distinctsys_op_lbid(11859,'L',t.rowid))asnlb,count(distinct"CUST_ID")asndk,nullasclffrom"SH"."SALES"twhereTBL$OR$IDX$PART$NUM("SH"."SALES",0,4,0,"ROWID")=:objnselect/*+no_parallel_index(t,"SALES_CUST_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"SALES_CUST_BIX")*/count(distinctsys_op_lbid(11859,'R',t.rowid))asnrw,count(distinctsys_op_lbid(11859,'L',t.rowid))asnlb,count(distinct"CUST_ID")asndk,nullasclffrom"SH"."SALES"tselect/*+no_parallel_index(t,"SALES_TIME_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"SALES_TIME_BIX")*/count(distinctsys_op_lbid(11888,'R',t.rowid))asnrw,count(distinctsys_op_lbid(11888,'L',t.rowid))asnlb,count(distinct"TIME_ID")asndk,nullasclffrom"SH"."SALES"twhereTBL$OR$IDX$PART$NUM("SH"."SALES",0,4,0,"ROWID")=:objnselect/*+no_parallel_index(t,"SALES_TIME_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"SALES_TIME_BIX")*/count(distinctsys_op_lbid(11888,'R',t.rowid))asnrw,count(distinctsys_op_lbid(11888,'L',t.rowid))asnlb,count(distinct"TIME_ID")asndk,nullasclffrom"SH"."SALES"tselect/*+no_parallel_index(t,"SALES_CHANNEL_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"SALES_CHANNEL_BIX")*/count(distinctsys_op_lbid(11917,'R',t.rowid))asnrw,count(distinctsys_op_lbid(11917,'L',t.rowid))asnlb,count(distinct"CHANNEL_ID")asndk,nullasclffrom"SH"."SALES"twhereTBL$OR$IDX$PART$NUM("SH"."SALES",0,4,0,"ROWID")=:objnselect/*+no_parallel_index(t,"SALES_CHANNEL_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"SALES_CHANNEL_BIX")*/count(distinctsys_op_lbid(11917,'R',t.rowid))asnrw,count(distinctsys_op_lbid(11917,'L',t.rowid))asnlb,count(distinct"CHANNEL_ID")asndk,nullasclffrom"SH"."SALES"tselect/*+no_parallel_index(t,"SALES_PROMO_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"SALES_PROMO_BIX")*/count(distinctsys_op_lbid(11946,'R',t.rowid))asnrw,count(distinctsys_op_lbid(11946,'L',t.rowid))asnlb,count(distinct"PROMO_ID")asndk,nullasclffrom"SH"."SALES"twhereTBL$OR$IDX$PART$NUM("SH"."SALES",0,4,0,"ROWID")=:objnselect/*+no_parallel_index(t,"SALES_PROMO_BIX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"SALES_PROMO_BIX")*/count(distinctsys_op_lbid(11946,'R',t.rowid))asnrw,count(distinctsys_op_lbid(11946,'L',t.rowid))asnlb,count(distinct"PROMO_ID")asndk,nullasclffrom"SH"."SALES"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"SH"."SUPPLEMENTARY_DEMOGRAPHICS"tSQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------select/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),count(distinct"CUST_ID"),sum(sys_op_opnsize("CUST_ID")),substrb(dump(min("CUST_ID"),16,0,32),1,120),substrb(dump(max("CUST_ID"),16,0,32),1,120),count("EDUCATION"),count(distinct"EDUCATION"),sum(sys_op_opnsize("EDUCATION")),substrb(dump(min("EDUCATION"),16,0,32),1,120),substrb(dump(max("EDUCATION"),16,0,32),1,120),count("OCCUPATION"),count(distinct"OCCUPATION"),sum(sys_op_opnsize("OCCUPATION")),substrb(dump(min("OCCUPATION"),16,0,32),1,120),substrb(dump(max("OCCUPATION"),16,0,32),1,120),count("HOUSEHOLD_SIZE"),count(distinct"HOUSEHOLD_SIZE"),sum(sys_op_opnsize("HOUSEHOLD_SIZE")),substrb(dump(min("HOUSEHOLD_SIZE"),16,0,32),1,120),substrb(dump(max("HOUSEHOLD_SIZE"),16,0,32),1,120),count("YRS_RESIDENCE"),count(distinct"YRS_RESIDENCE"),sum(sys_op_opnsize("YRS_RESIDENCE")),substrb(dump(min("YRS_RESIDENCE"),16,0,32),1,120),substrb(dump(max("YRS_RESIDENCE"),16,0,32),1,120),count("AFFINITY_CARD"),count(distinct"AFFINITY_CARD"),sum(sys_op_opnsize("AFFINITY_CARD")),substrb(dump(min("AFFINITY_CARD"),16,0,32),1,120),substrb(dump(max("AFFINITY_CARD"),16,0,32),1,120),count("BULK_PACK_DISKETTES"),count(distinct"BULK_PACK_DISKETTES"),sum(sys_op_opnsize("BULK_PACK_DISKETTES")),substrb(dump(min("BULK_PACK_DISKETTES"),16,0,32),1,120),substrb(dump(max("BULK_PACK_DISKETTES"),16,0,32),1,120),count("FLAT_PANEL_MONITOR"),count(distinct"FLAT_PANEL_MONITOR"),sum(sys_op_opnsize("FLAT_PANEL_MONITOR")),substrb(dump(min("FLAT_PANEL_MONITOR"),16,0,32),1,120),substrb(dump(max("FLAT_PANEL_MONITOR"),16,0,32),1,120),count("HOME_THEATER_PACKAGE"),count(distinct"HOME_THEATER_PACKAGE"),sum(sys_op_opnsize("HOME_THEATER_PACKAGE")),substrb(dump(min("HOME_THEATER_PACKAGE"),16,0,32),1,120),substrb(dump(max("HOME_THEATER_PACKAGE"),16,0,32),1,120),count("BOOKKEEPING_APPLICATION"),count(distinct"BOOKKEEPING_APPLICATION"),sum(sys_op_opnsize("BOOKKEEPING_APPLICATION")),substrb(dump(min("BOOKKEEPING_APPLICATION"),16,0,32),1,120),substrb(dump(max("BOOKKEEPING_APPLICATION"),16,0,32),1,120),count("PRINTER_SUPPLIES"),count(distinct"PRINTER_SUPPLIES"),sum(sys_op_opnsize("PRINTER_SUPPLIES")),substrb(dump(min("PRINTER_SUPPLIES"),16,0,32),1,120),substrb(dump(max("PRINTER_SUPPLIES"),16,0,32),1,120),count("Y_BOX_GAMES"),count(distinct"Y_BOX_GAMES"),sum(sys_op_opnsize("Y_BOX_GAMES")),substrb(dump(min("Y_BOX_GAMES"),16,0,32),1,120),substrb(dump(max("Y_BOX_GAMES"),16,0,32),1,120),count("OS_DOC_SET_KANJI"),count(distinct"OS_DOC_SET_KANJI"),sum(sys_op_opnsize("OS_DOC_SET_KANJI")),substrb(dump(min("OS_DOC_SET_KANJI"),16,0,32),1,120),substrb(dump(max("OS_DOC_SET_KANJI"),16,0,32),1,120),count("COMMENTS"),count(distinct"COMMENTS"),sum(sys_op_opnsize("COMMENTS")),substrb(dump(min(substrb("COMMENTS",1,32)),16,0,32),1,120),substrb(dump(max(substrb("COMMENTS",1,32)),16,0,32),1,120)from"SH"."SUPPLEMENTARY_DEMOGRAPHICS"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"SH"."TIMES"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),substrb(dump(min("TIME_ID"),16,0,32),1,120),substrb(dump(max("TIME_ID"),16,0,32),1,120),count(distinct"DAY_NAME"),sum(sys_op_opnsize("DAY_NAME")),substrb(dump(min("DAY_NAME"),16,0,32),1,120),substrb(dump(max("DAY_NAME"),16,0,32),1,120),count(distinct"DAY_NUMBER_IN_WEEK"),sum(sys_op_opnsize("DAY_NUMBER_IN_WEEK")),substrb(dump(min("DAY_NUMBER_IN_WEEK"),16,0,32),1,120),substrb(dump(max("DAY_NUMBER_IN_WEEK"),16,0,32),1,120),count(distinct"DAY_NUMBER_IN_MONTH"),sum(sys_op_opnsize("DAY_NUMBER_IN_MONTH")),substrb(dump(min("DAY_NUMBER_IN_MONTH"),16,0,32),1,120),substrb(dump(max("DAY_NUMBER_IN_MONTH"),16,0,32),1,120),count(distinct"CALENDAR_WEEK_NUMBER"),sum(sys_op_opnsize("CALENDAR_WEEK_NUMBER")),substrb(dump(min("CALENDAR_WEEK_NUMBER"),16,0,32),1,120),substrb(dump(max("CALENDAR_WEEK_NUMBER"),16,0,32),1,120),count(distinct"FISCAL_WEEK_NUMBER"),sum(sys_op_opnsize("FISCAL_WEEK_NUMBER")),substrb(dump(min("FISCAL_WEEK_NUMBER"),16,0,32),1,120),substrb(dump(max("FISCAL_WEEK_NUMBER"),16,0,32),1,120),count(distinct"WEEK_ENDING_DAY"),substrb(dump(min("WEEK_ENDING_DAY"),16,0,32),1,120),substrb(dump(max("WEEK_ENDING_DAY"),16,0,32),1,120),count(distinct"WEEK_ENDING_DAY_ID"),sum(sys_op_opnsize("WEEK_ENDING_DAY_ID")),substrb(dump(min("WEEK_ENDING_DAY_ID"),16,0,32),1,120),substrb(dump(max("WEEK_ENDING_DAY_ID"),16,0,32),1,120),count(distinct"CALENDAR_MONTH_NUMBER"),sum(sys_op_opnsize("CALENDAR_MONTH_NUMBER")),substrb(dump(min("CALENDAR_MONTH_NUMBER"),16,0,32),1,120),substrb(dump(max("CALENDAR_MONTH_NUMBER"),16,0,32),1,120),count(distinct"FISCAL_MONTH_NUMBER"),sum(sys_op_opnsize("FISCAL_MONTH_NUMBER")),substrb(dump(min("FISCAL_MONTH_NUMBER"),16,0,32),1,120),substrb(dump(max("FISCAL_MONTH_NUMBER"),16,0,32),1,120),count(distinct"CALENDAR_MONTH_DESC"),sum(sys_op_opnsize("CALENDAR_MONTH_DESC")),substrb(dump(min("CALENDAR_MONTH_DESC"),16,0,32),1,120),substrb(dump(max("CALENDAR_MONTH_DESC"),16,0,32),1,120),count(distinct"CALENDAR_MONTH_ID"),sum(sys_op_opnsize("CALENDAR_MONTH_ID")),substrb(dump(min("CALENDAR_MONTH_ID"),16,0,32),1,120),substrb(dump(max("CALENDAR_MONTH_ID"),16,0,32),1,120),count(distinct"FISCAL_MONTH_DESC"),sum(sys_op_opnsize("FISCAL_MONTH_DESC")),substrb(dump(min("FISCAL_MONTH_DESC"),16,0,32),1,120),substrb(dump(max("FISCAL_MONTH_DESC"),16,0,32),1,120),count(distinct"FISCAL_MONTH_ID"),sum(sys_op_opnsize("FISCAL_MONTH_ID")),substrb(dump(min("FISCAL_MONTH_ID"),16,0,32),1,120),substrb(dump(max("FISCAL_MONTH_ID"),16,0,32),1,120),count(distinct"DAYS_IN_CAL_MONTH"),sum(sys_op_opnsize("DAYS_IN_CAL_MONTH")),substrb(dump(min("DAYS_IN_CAL_MONTH"),16,0,32),1,120),substrb(dump(max("DAYS_IN_CAL_MONTH"),16,0,32),1,120),count(distinct"DAYS_IN_FIS_MONTH"),sum(sys_op_opnsize("DAYS_IN_FIS_MONTH")),substrb(dump(min("DAYS_IN_FIS_MONTH"),16,0,32),1,120),substrb(dump(max("DAYS_IN_FIS_MONTH"),16,0,32),1,120),count(distinct"END_OF_CAL_MONTH"),substrb(dump(min("END_OF_CAL_MONTH"),16,0,32),1,120),substrb(dump(max("END_OF_CAL_MONTH"),16,0,32),1,120),count(distinct"END_OF_FIS_MONTH"),substrb(dump(min("END_OF_FIS_MONTH"),16,0,32),1,120),substrb(dump(max("END_OF_FIS_MONTH"),16,0,32),1,120),count(distinct"CALENDAR_MONTH_NAME"),sum(sys_op_opnsize("CALENDAR_MONTH_NAME")),substrb(dump(min("CALENDAR_MONTH_NAME"),16,0,32),1,120),substrb(dump(max("CALENDAR_MONTH_NAME"),16,0,32),1,120),count(distinct"FISCAL_MONTH_NAME"),sum(sys_op_opnsize("FISCAL_MONTH_NAME")),substrb(dump(min("FISCAL_MONTH_NAME"),16,0,32),1,120),substrb(dump(max("FISCAL_MONTH_NAME"),16,0,32),1,120),count(distinct"CALENDAR_QUARTER_DESC"),substrb(dump(min("CALENDAR_QUARTER_DESC"),16,0,32),1,120),substrb(dump(max("CALENDAR_QUARTER_DESC"),16,0,32),1,120),count(distinct"CALENDAR_QUARTER_ID"),sum(sys_op_opnsize("CALENDAR_QUARTER_ID")),substrb(dump(min("CALENDAR_QUARTER_ID"),16,0,32),1,120),substrb(dump(max("CALENDAR_QUARTER_ID"),16,0,32),1,120),count(distinct"FISCAL_QUARTER_DESC"),substrb(dump(min("FISCAL_QUARTER_DESC"),16,0,32),1,120),substrb(dump(max("FISCAL_QUARTER_DESC"),16,0,32),1,120),count(distinct"FISCAL_QUARTER_ID"),sum(sys_op_opnsize("FISCAL_QUARTER_ID")),substrb(dump(min("FISCAL_QUARTER_ID"),16,0,32),1,120),substrb(dump(max("FISCAL_QUARTER_ID"),16,0,32),1,120),count(distinct"DAYS_IN_CAL_QUARTER"),sum(sys_op_opnsize("DAYS_IN_CAL_QUARTER")),substrb(dump(min("DAYS_IN_CAL_QUARTER"),16,0,32),1,120),substrb(dump(max("DAYS_IN_CAL_QUARTER")SQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------,16,0,32),1,120),count(distinct"DAYS_IN_FIS_QUARTER"),sum(sys_op_opnsize("DAYS_IN_FIS_QUARTER")),substrb(dump(min("DAYS_IN_FIS_QUARTER"),16,0,32),1,120),substrb(dump(max("DAYS_IN_FIS_QUARTER"),16,0,32),1,120),count(distinct"END_OF_CAL_QUARTER"),substrb(dump(min("END_OF_CAL_QUARTER"),16,0,32),1,120),substrb(dump(max("END_OF_CAL_QUARTER"),16,0,32),1,120),count(distinct"END_OF_FIS_QUARTER"),substrb(dump(min("END_OF_FIS_QUARTER"),16,0,32),1,120),substrb(dump(max("END_OF_FIS_QUARTER"),16,0,32),1,120),count(distinct"CALENDAR_QUARTER_NUMBER"),sum(sys_op_opnsize("CALENDAR_QUARTER_NUMBER")),substrb(dump(min("CALENDAR_QUARTER_NUMBER"),16,0,32),1,120),substrb(dump(max("CALENDAR_QUARTER_NUMBER"),16,0,32),1,120),count(distinct"FISCAL_QUARTER_NUMBER"),sum(sys_op_opnsize("FISCAL_QUARTER_NUMBER")),substrb(dump(min("FISCAL_QUARTER_NUMBER"),16,0,32),1,120),substrb(dump(max("FISCAL_QUARTER_NUMBER"),16,0,32),1,120),count(distinct"CALENDAR_YEAR"),sum(sys_op_opnsize("CALENDAR_YEAR")),substrb(dump(min("CALENDAR_YEAR"),16,0,32),1,120),substrb(dump(max("CALENDAR_YEAR"),16,0,32),1,120),count(distinct"CALENDAR_YEAR_ID"),sum(sys_op_opnsize("CALENDAR_YEAR_ID")),substrb(dump(min("CALENDAR_YEAR_ID"),16,0,32),1,120),substrb(dump(max("CALENDAR_YEAR_ID"),16,0,32),1,120),count(distinct"FISCAL_YEAR"),sum(sys_op_opnsize("FISCAL_YEAR")),substrb(dump(min("FISCAL_YEAR"),16,0,32),1,120),substrb(dump(max("FISCAL_YEAR"),16,0,32),1,120),count(distinct"FISCAL_YEAR_ID"),sum(sys_op_opnsize("FISCAL_YEAR_ID")),substrb(dump(min("FISCAL_YEAR_ID"),16,0,32),1,120),substrb(dump(max("FISCAL_YEAR_ID"),16,0,32),1,120),count(distinct"DAYS_IN_CAL_YEAR"),sum(sys_op_opnsize("DAYS_IN_CAL_YEAR")),substrb(dump(min("DAYS_IN_CAL_YEAR"),16,0,32),1,120),substrb(dump(max("DAYS_IN_CAL_YEAR"),16,0,32),1,120),count(distinct"DAYS_IN_FIS_YEAR"),sum(sys_op_opnsize("DAYS_IN_FIS_YEAR")),substrb(dump(min("DAYS_IN_FIS_YEAR"),16,0,32),1,120),substrb(dump(max("DAYS_IN_FIS_YEAR"),16,0,32),1,120),count(distinct"END_OF_CAL_YEAR"),substrb(dump(min("END_OF_CAL_YEAR"),16,0,32),1,120),substrb(dump(max("END_OF_CAL_YEAR"),16,0,32),1,120),count(distinct"END_OF_FIS_YEAR"),substrb(dump(min("END_OF_FIS_YEAR"),16,0,32),1,120),substrb(dump(max("END_OF_FIS_YEAR"),16,0,32),1,120)from"SH"."TIMES"tselect/*+no_parallel_index(t,"TIMES_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"TIMES_PK")*/count(*)asnrw,count(distinctsys_op_lbid(11821,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"SH"."TIMES"twhere"TIME_ID"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"SH"."TRANSACTION"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),count(distinct"USERNAME"),sum(sys_op_opnsize("USERNAME")),substrb(dump(min("USERNAME"),16,0,32),1,120),substrb(dump(max("USERNAME"),16,0,32),1,120),count(distinct"USER_ID"),sum(sys_op_opnsize("USER_ID")),substrb(dump(min("USER_ID"),16,0,32),1,120),substrb(dump(max("USER_ID"),16,0,32),1,120),count("PASSWORD"),count(distinct"PASSWORD"),sum(sys_op_opnsize("PASSWORD")),substrb(dump(min("PASSWORD"),16,0,32),1,120),substrb(dump(max("PASSWORD"),16,0,32),1,120),count(distinct"ACCOUNT_STATUS"),sum(sys_op_opnsize("ACCOUNT_STATUS")),substrb(dump(min("ACCOUNT_STATUS"),16,0,32),1,120),substrb(dump(max("ACCOUNT_STATUS"),16,0,32),1,120),count("LOCK_DATE"),count(distinct"LOCK_DATE"),substrb(dump(min("LOCK_DATE"),16,0,32),1,120),substrb(dump(max("LOCK_DATE"),16,0,32),1,120),count("EXPIRY_DATE"),count(distinct"EXPIRY_DATE"),substrb(dump(min("EXPIRY_DATE"),16,0,32),1,120),substrb(dump(max("EXPIRY_DATE"),16,0,32),1,120),count(distinct"DEFAULT_TABLESPACE"),sum(sys_op_opnsize("DEFAULT_TABLESPACE")),substrb(dump(min("DEFAULT_TABLESPACE"),16,0,32),1,120),substrb(dump(max("DEFAULT_TABLESPACE"),16,0,32),1,120),count(distinct"TEMPORARY_TABLESPACE"),sum(sys_op_opnsize("TEMPORARY_TABLESPACE")),substrb(dump(min("TEMPORARY_TABLESPACE"),16,0,32),1,120),substrb(dump(max("TEMPORARY_TABLESPACE"),16,0,32),1,120),count(distinct"CREATED"),substrb(dump(min("CREATED"),16,0,32),1,120),substrb(dump(max("CREATED"),16,0,32),1,120),count(distinct"PROFILE"),sum(sys_op_opnsize("PROFILE")),substrb(dump(min("PROFILE"),16,0,32),1,120),substrb(dump(max("PROFILE"),16,0,32),1,120),count("INITIAL_RSRC_CONSUMER_GROUP"),count(distinct"INITIAL_RSRC_CONSUMER_GROUP"),sum(sys_op_opnsize("INITIAL_RSRC_CONSUMER_GROUP")),substrb(dump(min("INITIAL_RSRC_CONSUMER_GROUP"),16,0,32),1,120),substrb(dump(max("INITIAL_RSRC_CONSUMER_GROUP"),16,0,32),1,120),count("EXTERNAL_NAME"),count(distinct"EXTERNAL_NAME"),sum(sys_op_opnsize("EXTERNAL_NAME")),substrb(dump(min(substrb("EXTERNAL_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("EXTERNAL_NAME",1,32)),16,0,32),1,120)from"SH"."TRANSACTION"tselect/*+no_parallel_index(t,"IND_USER_ID_HASH")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"IND_USER_ID_HASH")*/count(*)asnrw,count(distinctsys_op_lbid(12140,'L',t.rowid))asnlb,count(distinct"USER_ID")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"SH"."TRANSACTION"twhere("USER_ID"isnotnull)and(TBL$OR$IDX$PART$NUM("SH"."TRANSACTION",12140,4,0,"USER_ID")=:objn)SQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------select/*+no_parallel_index(t,"IND_USER_ID_HASH")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"IND_USER_ID_HASH")*/count(*)asnrw,count(distinctsys_op_lbid(12140,'L',t.rowid))asnlb,count(distinct"USER_ID")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"SH"."TRANSACTION"twhere"USER_ID"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"WMSYS"."AQ$_WM$EVENT_QUEUE_TABLE_S"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),sum(sys_op_opnsize("SUBSCRIBER_ID")),substrb(dump(min("SUBSCRIBER_ID"),16,0,32),1,120),substrb(dump(max("SUBSCRIBER_ID"),16,0,32),1,120),count(distinct"QUEUE_NAME"),sum(sys_op_opnsize("QUEUE_NAME")),substrb(dump(min("QUEUE_NAME"),16,0,32),1,120),substrb(dump(max("QUEUE_NAME"),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("ADDRESS"),count(distinct"ADDRESS"),sum(sys_op_opnsize("ADDRESS")),substrb(dump(min(substrb("ADDRESS",1,32)),16,0,32),1,120),substrb(dump(max(substrb("ADDRESS",1,32)),16,0,32),1,120),count("PROTOCOL"),count(distinct"PROTOCOL"),sum(sys_op_opnsize("PROTOCOL")),substrb(dump(min("PROTOCOL"),16,0,32),1,120),substrb(dump(max("PROTOCOL"),16,0,32),1,120),count("SUBSCRIBER_TYPE"),count(distinct"SUBSCRIBER_TYPE"),sum(sys_op_opnsize("SUBSCRIBER_TYPE")),substrb(dump(min("SUBSCRIBER_TYPE"),16,0,32),1,120),substrb(dump(max("SUBSCRIBER_TYPE"),16,0,32),1,120),count("RULE_NAME"),count(distinct"RULE_NAME"),sum(sys_op_opnsize("RULE_NAME")),substrb(dump(min("RULE_NAME"),16,0,32),1,120),substrb(dump(max("RULE_NAME"),16,0,32),1,120),count("TRANS_NAME"),count(distinct"TRANS_NAME"),sum(sys_op_opnsize("TRANS_NAME")),substrb(dump(min(substrb("TRANS_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("TRANS_NAME",1,32)),16,0,32),1,120),count("RULESET_NAME"),count(distinct"RULESET_NAME"),sum(sys_op_opnsize("RULESET_NAME")),substrb(dump(min(substrb("RULESET_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("RULESET_NAME",1,32)),16,0,32),1,120),count("NEGATIVE_RULESET_NAME"),count(distinct"NEGATIVE_RULESET_NAME"),sum(sys_op_opnsize("NEGATIVE_RULESET_NAME")),substrb(dump(min(substrb("NEGATIVE_RULESET_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb("NEGATIVE_RULESET_NAME",1,32)),16,0,32),1,120)from"WMSYS"."AQ$_WM$EVENT_QUEUE_TABLE_S"tselect/*+no_parallel_index(t,"SYS_C002935")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"SYS_C002935")*/count(*)asnrw,count(distinctsys_op_lbid(10110,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"WMSYS"."AQ$_WM$EVENT_QUEUE_TABLE_S"twhere"SUBSCRIBER_ID"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"WMSYS"."WM$ENV_VARS"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),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)from"WMSYS"."WM$ENV_VARS"tselect/*+no_parallel_index(t,"WM$ENV_VARS_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"WM$ENV_VARS_PK")*/count(*)asnrw,count(distinctsys_op_lbid(9794,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"WMSYS"."WM$ENV_VARS"twhere"NAME"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"WMSYS"."WM$EVENTS_INFO"tSQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------select/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),sum(sys_op_opnsize("EVENT_NAME")),substrb(dump(min("EVENT_NAME"),16,0,32),1,120),substrb(dump(max("EVENT_NAME"),16,0,32),1,120),count("CAPTURE"),count(distinct"CAPTURE"),sum(sys_op_opnsize("CAPTURE")),substrb(dump(min("CAPTURE"),16,0,32),1,120),substrb(dump(max("CAPTURE"),16,0,32),1,120)from"WMSYS"."WM$EVENTS_INFO"tselect/*+no_parallel_index(t,"SYS_C002944")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"SYS_C002944")*/count(*)asnrw,count(distinctsys_op_lbid(10133,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"WMSYS"."WM$EVENTS_INFO"twhere"EVENT_NAME"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"WMSYS"."WM$NEXTVER_TABLE"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),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),count("NEXT_VERS"),count(distinct"NEXT_VERS"),sum(sys_op_opnsize("NEXT_VERS")),substrb(dump(min(substrb("NEXT_VERS",1,32)),16,0,32),1,120),substrb(dump(max(substrb("NEXT_VERS",1,32)),16,0,32),1,120),count("WORKSPACE"),count(distinct"WORKSPACE"),sum(sys_op_opnsize("WORKSPACE")),substrb(dump(min("WORKSPACE"),16,0,32),1,120),substrb(dump(max("WORKSPACE"),16,0,32),1,120),count("SPLIT"),count(distinct"SPLIT"),sum(sys_op_opnsize("SPLIT")),substrb(dump(min("SPLIT"),16,0,32),1,120),substrb(dump(max("SPLIT"),16,0,32),1,120)from"WMSYS"."WM$NEXTVER_TABLE"tselect/*+no_parallel_index(t,"WM$NEXTVER_TABLE_INDX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"WM$NEXTVER_TABLE_INDX")*/count(*)asnrw,count(distinctsys_op_lbid(9809,'L',t.rowid))asnlb,count(distincthextoraw(sys_op_descend("VERSION")||sys_op_descend("NEXT_VERS")))asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"WMSYS"."WM$NEXTVER_TABLE"twhere"VERSION"isnotnullor"NEXT_VERS"isnotnullselect/*+no_parallel_index(t,"WM$NEXTVER_TABLE_NV_INDX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"WM$NEXTVER_TABLE_NV_INDX")*/count(*)asnrw,count(distinctsys_op_lbid(10051,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"WMSYS"."WM$NEXTVER_TABLE"twhere"NEXT_VERS"isnotnullor"VERSION"isnotnullor"WORKSPACE"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"WMSYS"."WM$SYSPARAM_ALL_VALUES"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),sum(sys_op_opnsize("NAME")),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"),sum(sys_op_opnsize("ISDEFAULT"))from"WMSYS"."WM$SYSPARAM_ALL_VALUES"tselect/*+no_parallel_index(t,"WM$ENV_SYS_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"WM$ENV_SYS_PK")*/count(*)asnrw,count(distinctsys_op_lbid(10058,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"WMSYS"."WM$SYSPARAM_ALL_VALUES"twhere"NAME"isnotnullor"VALUE"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"WMSYS"."WM$VERSION_HIERARCHY_TABLE"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),sum(sys_op_opnsize("VERSION")),count("PARENT_VERSION"),count(distinct"PARENT_VERSION"),sum(sys_op_opnsize("PARENT_VERSION")),substrb(dump(min("PARENT_VERSION"),16,0,32),1,120),substrb(dump(max("PARENT_VERSION"),16,0,32),1,120),count("WORKSPACE"),sum(sys_op_opnsize("WORKSPACE"))from"WMSYS"."WM$VERSION_HIERARCHY_TABLE"tSQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------select/*+no_parallel_index(t,"WM$VERSION_HIERARCHY_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"WM$VERSION_HIERARCHY_PK")*/count(*)asnrw,count(distinctsys_op_lbid(9756,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"WMSYS"."WM$VERSION_HIERARCHY_TABLE"twhere"VERSION"isnotnullselect/*+no_parallel_index(t,"WM$VHT_IDX")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"WM$VHT_IDX")*/count(*)asnrw,count(distinctsys_op_lbid(9795,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"WMSYS"."WM$VERSION_HIERARCHY_TABLE"twhere"WORKSPACE"isnotnullor"VERSION"isnotnullselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"WMSYS"."WM$WORKSPACES_TABLE"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),sum(sys_op_opnsize("WORKSPACE")),substrb(dump(min("WORKSPACE"),16,0,32),1,120),substrb(dump(max("WORKSPACE"),16,0,32),1,120),count("PARENT_WORKSPACE"),sum(sys_op_opnsize("PARENT_WORKSPACE")),count("CURRENT_VERSION"),count(distinct"CURRENT_VERSION"),sum(sys_op_opnsize("CURRENT_VERSION")),substrb(dump(min("CURRENT_VERSION"),16,0,32),1,120),substrb(dump(max("CURRENT_VERSION"),16,0,32),1,120),count("PARENT_VERSION"),count(distinct"PARENT_VERSION"),sum(sys_op_opnsize("PARENT_VERSION")),substrb(dump(min("PARENT_VERSION"),16,0,32),1,120),substrb(dump(max("PARENT_VERSION"),16,0,32),1,120),count("POST_VERSION"),sum(sys_op_opnsize("POST_VERSION")),count("VERLIST"),count(distinct"VERLIST"),sum(sys_op_opnsize("VERLIST")),substrb(dump(min(substrb("VERLIST",1,32)),16,0,32),1,120),substrb(dump(max(substrb("VERLIST",1,32)),16,0,32),1,120),count("OWNER"),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("CREATETIME"),count(distinct"CREATETIME"),substrb(dump(min("CREATETIME"),16,0,32),1,120),substrb(dump(max("CREATETIME"),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),count("WORKSPACE_LOCK_ID"),sum(sys_op_opnsize("WORKSPACE_LOCK_ID")),substrb(dump(min("WORKSPACE_LOCK_ID"),16,0,32),1,120),substrb(dump(max("WORKSPACE_LOCK_ID"),16,0,32),1,120),count("FREEZE_STATUS"),count(distinct"FREEZE_STATUS"),sum(sys_op_opnsize("FREEZE_STATUS")),substrb(dump(min("FREEZE_STATUS"),16,0,32),1,120),substrb(dump(max("FREEZE_STATUS"),16,0,32),1,120),count("FREEZE_MODE"),count(distinct"FREEZE_MODE"),sum(sys_op_opnsize("FREEZE_MODE")),substrb(dump(min("FREEZE_MODE"),16,0,32),1,120),substrb(dump(max("FREEZE_MODE"),16,0,32),1,120),count("FREEZE_WRITER"),count(distinct"FREEZE_WRITER"),sum(sys_op_opnsize("FREEZE_WRITER")),substrb(dump(min("FREEZE_WRITER"),16,0,32),1,120),substrb(dump(max("FREEZE_WRITER"),16,0,32),1,120),count("OPER_STATUS"),count(distinct"OPER_STATUS"),sum(sys_op_opnsize("OPER_STATUS")),substrb(dump(min("OPER_STATUS"),16,0,32),1,120),substrb(dump(max("OPER_STATUS"),16,0,32),1,120),count("WM_LOCKMODE"),count(distinct"WM_LOCKMODE"),sum(sys_op_opnsize("WM_LOCKMODE")),substrb(dump(min("WM_LOCKMODE"),16,0,32),1,120),substrb(dump(max("WM_LOCKMODE"),16,0,32),1,120),count("ISREFRESHED"),count(distinct"ISREFRESHED"),sum(sys_op_opnsize("ISREFRESHED")),substrb(dump(min("ISREFRESHED"),16,0,32),1,120),substrb(dump(max("ISREFRESHED"),16,0,32),1,120),count("FREEZE_OWNER"),count(distinct"FREEZE_OWNER"),sum(sys_op_opnsize("FREEZE_OWNER")),substrb(dump(min("FREEZE_OWNER"),16,0,32),1,120),substrb(dump(max("FREEZE_OWNER"),16,0,32),1,120),count("SESSION_DURATION"),count(distinct"SESSION_DURATION"),sum(sys_op_opnsize("SESSION_DURATION")),substrb(dump(min("SESSION_DURATION"),16,0,32),1,120),substrb(dump(max("SESSION_DURATION"),16,0,32),1,120),count("IMPLICIT_SP_CNT"),count(distinct"IMPLICIT_SP_CNT"),sum(sys_op_opnsize("IMPLICIT_SP_CNT")),substrb(dump(min("IMPLICIT_SP_CNT"),16,0,32),1,120),substrb(dump(max("IMPLICIT_SP_CNT"),16,0,32),1,120),count("CR_STATUS"),count(distinct"CR_STATUS"),sum(sys_op_opnsize("CR_STATUS")),substrb(dump(min("CR_STATUS"),16,0,32),1,120),substrb(dump(max("CR_STATUS"),16,0,32),1,120),count("SYNC_PARVER"),count(distinct"SYNC_PARVER"),sum(sys_op_opnsize("SYNC_PARVER")),substrb(dump(min("SYNC_PARVER"),16,0,32),1,120),substrb(dump(max("SYNC_PARVER"),16,0,32),1,120),count("LAST_CHANGE"),count(distinct"LAST_CHANGE"),substrb(dump(min("LAST_CHANGE"),16,0,32),1,120),substrb(dump(max("LAST_CHANGE"),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("MP_ROOT"),count(distinct"MP_ROOT"),sum(sys_op_opnsize("MP_ROOT")),substrb(dump(min("MP_ROOT"),16,0,32),1,120),substrb(dump(max("MP_ROOT"),16,0,32),1,120)from"WMSYS"."WM$WORKSPACES_TABLE"tselect/*+no_parallel_index(t,"WM$WORKSPACES_PK")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"WM$WORKSPACES_PK")*/count(*)asnrw,count(distinctsys_op_lbid(9749,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"WMSYS"."WM$WORKSPACES_TABLE"twhere"WORKSPACE"isnotnullselect/*+no_parallel_index(t,"WORKSPACE_LOCK_ID_UNQ")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"WORKSPACE_LOCK_ID_UNQ")*/count(*)asnrw,count(distinctsys_op_lbid(10075,'L',t.rowid))asnlb,nullasndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"WMSYS"."WM$WORKSPACES_TABLE"twhere"WORKSPACE_LOCK_ID"isnotnullSQL_TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------select/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*)from"WMSYS"."WM$WORKSPACE_PRIV_TABLE"tselect/*+no_parallel(t)no_parallel_index(t)dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoring*/count(*),count("GRANTEE"),sum(sys_op_opnsize("GRANTEE")),count("WORKSPACE"),sum(sys_op_opnsize("WORKSPACE")),count("GRANTOR"),sum(sys_op_opnsize("GRANTOR")),count("PRIV"),sum(sys_op_opnsize("PRIV")),count("ADMIN"),sum(sys_op_opnsize("ADMIN"))from"WMSYS"."WM$WORKSPACE_PRIV_TABLE"tselect/*+no_parallel_index(t,"WM$WS_PRIV_TAB_WS_GRTE_IND")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"WM$WS_PRIV_TAB_WS_GRTE_IND")*/count(*)asnrw,count(distinctsys_op_lbid(9799,'L',t.rowid))asnlb,count(distincthextoraw(sys_op_descend("WORKSPACE")||sys_op_descend("GRANTEE")))asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"WMSYS"."WM$WORKSPACE_PRIV_TABLE"twhere"WORKSPACE"isnotnullor"GRANTEE"isnotnullselect/*+no_parallel_index(t,"WM$WS_PRIV_TAB_GRTE_IND")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"WM$WS_PRIV_TAB_GRTE_IND")*/count(*)asnrw,count(distinctsys_op_lbid(9800,'L',t.rowid))asnlb,count(distinct"GRANTEE")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"WMSYS"."WM$WORKSPACE_PRIV_TABLE"twhere"GRANTEE"isnotnullselect/*+no_parallel_index(t,"WM$WS_PRIV_TAB_GRTOR_IND")dbms_statscursor_sharing_exactuse_weak_name_resldynamic_sampling(0)no_monitoringno_expandindex(t,"WM$WS_PRIV_TAB_GRTOR_IND")*/count(*)asnrw,count(distinctsys_op_lbid(9801,'L',t.rowid))asnlb,count(distinct"GRANTOR")asndk,sys_op_countchg(substrb(t.rowid,1,15),1)asclffrom"WMSYS"."WM$WORKSPACE_PRIV_TABLE"twhere"GRANTOR"isnotnullselecta.snap_levelvaluefromperfstat.stats$snapshotawherea.ucomment=:"SYS_B_0"selectcount(*)fromperfstat.stats$snapshot149rowsselected.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


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

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

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

SQL> Connected.
SQL> SQL> 
PARTITI
-------
HASH

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


A: HASH


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


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


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

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

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

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

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


R501010=0.3


A: TOOLS


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

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

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

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

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


R501020=0.3


A: TEMP1


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

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

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

SQL> Connected.
SQL> SQL> 
no rows selected

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


R502000=0




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

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

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

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

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


R503001=0



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

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

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


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


R503002=0.8



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

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

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


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


R503002=0


A: 0


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

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

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

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


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


R504000=0


A: 0


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

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

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

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

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


R600001=0



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

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

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

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


R600002=0



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

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

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

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


R600003=0.2


A: KEEP

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

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

SQL> Connected.
SQL> SQL> 
BUFFER_
-------
RECYCLE

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


A: RECYCLE
****************************************************************************************************


R101000: 0.1 full is 0.1 0.1
R102001: 0.1 full is 0.1 0.2
R102002: 0.2 full is 0.2 0.4
R201010: 0 full is 0.1 0.5
R201021: 0.1 full is 0.1 0.6
R201022: 0.1 full is 0.1 0.7
R201023: 0.03 full is 0.03 0.73
R201024: 0.03 full is 0.03 0.76
R201031: 0.2 full is 0.2 0.96
R201032: 0.2 full is 0.2 1.16
R201033: 0.2 full is 0.2 1.36
R201034: 0.2 full is 0.2 1.56
R201035: 0.2 full is 0.2 1.76
R201036: 0.2 full is 0.2 1.96
R201037: 0.2 full is 0.2 2.16
R201041: 0.2 full is 0.2 2.36
R201042: 0.2 full is 0.2 2.56
R201051: 0.2 full is 0.2 2.76
R201052: 0.2 full is 0.2 2.96
R201060: 0.44 full is 0.44 3.4
R201131: 0.2 full is 0.2 3.6
R201132: 0.2 full is 0.2 3.8
R201133: 0 full is 0.2 4.0
R201135: 0.2 full is 0.2 4.2
R201235: 0.2 full is 0.2 4.4
R301001: 0 full is 0.8 5.2
R301002: 0 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 full is 0.15 7.55
R402002: 0 full is 0.15 7.7
R402003: 0 full is 0.15 7.85
R402004: 0 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.5 full is 0.5 9.9
R404002: 0.2 full is 0.2 10.1
R404003: 0.3 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.3 full is 0.3 12.6
R407002: 0.3 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.2 full is 0.2 15.2
R411000: 0.2 full is 0.2 15.4
R501010: 0.3 full is 0.3 15.7
R501020: 0.3 full is 0.3 16.0
R502000: 0 full is 2 18.0
R503001: 0 full is 0.3 18.3
R503002: 0 full is 0.8 19.1
R504000: 0 full is 0.3 19.4
R600001: 0 full is 0.1 19.5
R600002: 0 full is 0.1 19.6
R600003: 0.2 full is 0.2 19.8
R600004: 0.2 full is 0.2 20.0


full of this section:
RESULT:
14.30


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