select	OWNER,
	NAME,
	DB_LINK,
	NAMESPACE,
	TYPE,
        SHARABLE_MEM,
        LOADS,
        EXECUTIONS,
        LOCKS,
        PINS
from 	v$db_object_cache
order 	by OWNER, NAME


Connect time(ms): 203

Connected to jdbc:oracle:thin:@LarrySERVER:1521:wind
Driver       Oracle JDBC driver
Version      8.1.7.1.0

Query time & data xfer(ms): 16

OWNER|NAME|DB_LINK|NAMESPACE|TYPE|SHARABLE_MEM|LOADS|EXECUTIONS|LOCKS|PINS
PUBLIC|DBA_SEGMENTS||TABLE/PROCEDURE|SYNONYM|875|1|0|0|0
PUBLIC|DBMS_APPLICATION_INFO||TABLE/PROCEDURE|SYNONYM|7696|1|0|0|0
PUBLIC|DBMS_OUTPUT||TABLE/PROCEDURE|SYNONYM|7674|1|0|0|0
PUBLIC|DUAL||TABLE/PROCEDURE|SYNONYM|867|1|0|0|0
PUBLIC|GLOBAL_NAME||TABLE/PROCEDURE|SYNONYM|874|1|0|0|0
PUBLIC|NLS_INSTANCE_PARAMETERS||TABLE/PROCEDURE|SYNONYM|886|1|0|0|0
PUBLIC|POOL_SIZE||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
PUBLIC|SYS||TABLE/PROCEDURE|NON-EXISTENT|866|1|0|0|0
PUBLIC|TIME||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
PUBLIC|V$ACCESS||TABLE/PROCEDURE|SYNONYM|871|1|0|0|0
PUBLIC|V$DATABASE||TABLE/PROCEDURE|SYNONYM|7685|1|0|0|0
PUBLIC|V$DATAFILE||TABLE/PROCEDURE|SYNONYM|873|1|0|0|0
PUBLIC|V$DBFILE||TABLE/PROCEDURE|SYNONYM|7683|1|0|0|0
PUBLIC|V$DB_OBJECT_CACHE||TABLE/PROCEDURE|SYNONYM|880|1|0|0|0
PUBLIC|V$FILESTAT||TABLE/PROCEDURE|SYNONYM|873|1|0|0|0
PUBLIC|V$INSTANCE||TABLE/PROCEDURE|SYNONYM|873|1|0|0|0
PUBLIC|V$LIBRARYCACHE||TABLE/PROCEDURE|SYNONYM|877|1|0|0|0
PUBLIC|V$LOG||TABLE/PROCEDURE|SYNONYM|868|1|0|0|0
PUBLIC|V$LOGFILE||TABLE/PROCEDURE|SYNONYM|872|1|0|0|0
PUBLIC|V$LOGHIST||TABLE/PROCEDURE|SYNONYM|872|1|0|0|0
PUBLIC|V$ROLLNAME||TABLE/PROCEDURE|SYNONYM|873|1|0|0|0
PUBLIC|V$ROLLSTAT||TABLE/PROCEDURE|SYNONYM|873|1|0|0|0
PUBLIC|V$ROWCACHE||TABLE/PROCEDURE|SYNONYM|873|1|0|0|0
PUBLIC|V$SESSION||TABLE/PROCEDURE|SYNONYM|872|1|0|0|0
PUBLIC|V$SQLAREA||TABLE/PROCEDURE|SYNONYM|872|1|0|0|0
PUBLIC|V$SYSSTAT||TABLE/PROCEDURE|SYNONYM|872|1|0|0|0
PUBLIC|V$VERSION||TABLE/PROCEDURE|SYNONYM|872|1|0|0|0
PUBLIC|V$WAITSTAT||TABLE/PROCEDURE|SYNONYM|873|1|0|0|0
SYS|ACCESS$||TABLE/PROCEDURE|TABLE|1431|1|0|0|0
SYS|ALL_OBJECTS||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|AQ$_AGENT||TABLE/PROCEDURE|TYPE|869|1|0|0|0
SYS|AQ$_AQ_EVENT_TABLE_I||INDEX|INDEX|560|1|0|0|0
SYS|AQ$_AQ_SRVNTFN_TABLE_I||INDEX|INDEX|562|1|0|0|0
SYS|AQ$_EVENT_MESSAGE||TABLE/PROCEDURE|TYPE|1437|1|0|0|0
SYS|AQ$_MESSAGE_TYPES||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|AQ$_NOTIFY_MSG||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|AQ$_PENDING_MESSAGES||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|AQ$_PROPAGATION_STATUS||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|AQ$_QUEUE_TABLE_AFFINITIES||TABLE/PROCEDURE|TABLE|1134|1|0|0|0
SYS|AQ$_RECIPIENTS||TABLE/PROCEDURE|TYPE|1278|1|0|0|0
SYS|AQ$_SCHEDULES||TABLE/PROCEDURE|TABLE|1433|1|0|0|0
SYS|AQ$_SRVNTFN_MESSAGE||TABLE/PROCEDURE|TYPE|879|1|0|0|0
SYS|AQ$_SUBSCRIBERS||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|AQ_EVENT_TABLE||TABLE/PROCEDURE|TABLE|2554|1|0|0|0
SYS|AQ_SRVNTFN_TABLE||TABLE/PROCEDURE|TABLE|1996|1|0|0|0
SYS|ARGUMENT$||TABLE/PROCEDURE|TABLE|1429|1|0|0|0
SYS|ATTRCOL$||TABLE/PROCEDURE|TABLE|1428|1|0|0|0
SYS|ATTRIBUTE$||TABLE/PROCEDURE|TABLE|1266|1|0|0|0
SYS|AUDSES$||TABLE/PROCEDURE|SEQUENCE|867|1|0|0|0
SYS|AUX_STATS$||TABLE/PROCEDURE|TABLE|1430|1|0|0|0
SYS|BOOTSTRAP$||TABLE/PROCEDURE|TABLE|1430|1|0|0|0
SYS|CCOL$||TABLE/PROCEDURE|TABLE|1681|1|0|0|0
SYS|CDEF$||TABLE/PROCEDURE|TABLE|1653|1|0|0|0
SYS|CLU$||TABLE/PROCEDURE|TABLE|1336|1|0|0|0
SYS|COL$||TABLE/PROCEDURE|TABLE|1984|1|0|0|0
SYS|COLTYPE$||TABLE/PROCEDURE|TABLE|1428|1|0|0|0
SYS|COL_USAGE$||TABLE/PROCEDURE|TABLE|1430|1|0|0|0
SYS|CON$||TABLE/PROCEDURE|TABLE|1424|1|0|0|0
SYS|C_COBJ#||CLUSTER|CLUSTER|1391|1|0|0|0
SYS|C_FILE#_BLOCK#||CLUSTER|CLUSTER|1406|1|0|0|0
SYS|C_OBJ#||CLUSTER|CLUSTER|1426|1|0|0|0
SYS|C_OBJ#_INTCOL#||CLUSTER|CLUSTER|1434|1|0|0|0
SYS|C_TS#||CLUSTER|CLUSTER|1425|1|0|0|0
SYS|C_USER#||CLUSTER|CLUSTER|1235|1|0|0|0
SYS|DATABASE||PUB_SUB|PUB_SUB|1328|1|0|1|0
SYS|DBA_ANALYZE_OBJECTS||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBA_DATA_FILES||TABLE/PROCEDURE|VIEW|2718|1|0|0|0
SYS|DBA_FREE_SPACE||TABLE/PROCEDURE|VIEW|2718|1|0|0|0
SYS|DBA_IND_PARTITIONS||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBA_JOBS||TABLE/PROCEDURE|VIEW|1868|1|0|0|0
SYS|DBA_OBJECTS||TABLE/PROCEDURE|VIEW|2551|1|0|0|0
SYS|DBA_SEGMENTS||TABLE/PROCEDURE|VIEW|1696|1|0|0|0
SYS|DBA_TAB_PARTITIONS||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_APPLICATION_INFO||TABLE/PROCEDURE|PACKAGE|12465|1|0|0|0
SYS|DBMS_APPLICATION_INFO||BODY|PACKAGE BODY|3041|1|1|0|0
SYS|DBMS_AQ||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_AQADM||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_AQADM_LIB||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_AQADM_SYS||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_AQADM_SYSCALLS||TABLE/PROCEDURE|PACKAGE|31911|1|0|0|0
SYS|DBMS_AQADM_SYSCALLS||BODY|PACKAGE BODY|7259|1|9|0|0
SYS|DBMS_AQ_LIB||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_DDL||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_IJOB||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_JOB||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_LOB||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_LOCK||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_OUTPUT||TABLE/PROCEDURE|PACKAGE|13011|1|0|0|0
SYS|DBMS_OUTPUT||BODY|PACKAGE BODY|8091|1|76|0|0
SYS|DBMS_PRVTAQIP||TABLE/PROCEDURE|PACKAGE|39609|1|0|0|0
SYS|DBMS_PRVTAQIP||BODY|PACKAGE BODY|72285|1|1|0|0
SYS|DBMS_SPACE_ADMIN||TABLE/PROCEDURE|PACKAGE|31960|1|0|0|0
SYS|DBMS_SPACE_ADMIN||BODY|PACKAGE BODY|7564|1|20|0|0
SYS|DBMS_SPACE_ADMIN_LIB||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_SQL||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_STANDARD||TABLE/PROCEDURE|PACKAGE|23633|1|0|0|0
SYS|DBMS_SYSTEM||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_SYS_ERROR||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_SYS_SQL||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_TRANSACTION||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|DBMS_UTILITY||TABLE/PROCEDURE|PACKAGE|5580|1|0|0|0
SYS|DBMS_UTILITY||BODY|PACKAGE BODY|29648|1|1|0|0
SYS|DEPENDENCY$||TABLE/PROCEDURE|TABLE|1431|1|0|0|0
SYS|DUAL||TABLE/PROCEDURE|TABLE|1424|1|0|0|0
SYS|ERROR$||TABLE/PROCEDURE|TABLE|1426|1|0|0|0
SYS|FET$||TABLE/PROCEDURE|TABLE|9040|1|0|0|0
SYS|FILE$||TABLE/PROCEDURE|TABLE|10825|1|0|0|0
SYS|GET_DEP_DT1||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|GET_DEP_DT2||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|GLOBAL_NAME||TABLE/PROCEDURE|VIEW|1991|1|0|0|0
SYS|GV$ACCESS||TABLE/PROCEDURE|VIEW|549|1|0|0|0
SYS|GV$DATABASE||TABLE/PROCEDURE|VIEW|551|1|0|0|0
SYS|GV$DATAFILE||TABLE/PROCEDURE|VIEW|551|1|0|0|0
SYS|GV$DBFILE||TABLE/PROCEDURE|VIEW|549|1|0|0|0
SYS|GV$DB_OBJECT_CACHE||TABLE/PROCEDURE|VIEW|558|1|0|0|0
SYS|GV$FILESTAT||TABLE/PROCEDURE|VIEW|551|1|0|0|0
SYS|GV$INSTANCE||TABLE/PROCEDURE|VIEW|551|1|0|0|0
SYS|GV$LIBRARYCACHE||TABLE/PROCEDURE|VIEW|555|1|0|0|0
SYS|GV$LOG||TABLE/PROCEDURE|VIEW|546|1|0|0|0
SYS|GV$LOGFILE||TABLE/PROCEDURE|VIEW|550|1|0|0|0
SYS|GV$LOGHIST||TABLE/PROCEDURE|VIEW|550|1|0|0|0
SYS|GV$LOG_HISTORY||TABLE/PROCEDURE|VIEW|634|1|0|0|0
SYS|GV$PARAMETER||TABLE/PROCEDURE|VIEW|552|1|0|0|0
SYS|GV$ROLLSTAT||TABLE/PROCEDURE|VIEW|551|1|0|0|0
SYS|GV$ROWCACHE||TABLE/PROCEDURE|VIEW|551|1|0|0|0
SYS|GV$SESSION||TABLE/PROCEDURE|VIEW|550|1|0|0|0
SYS|GV$SQLAREA||TABLE/PROCEDURE|VIEW|550|1|0|0|0
SYS|GV$SYSSTAT||TABLE/PROCEDURE|VIEW|550|1|0|0|0
SYS|GV$VERSION||TABLE/PROCEDURE|VIEW|550|1|0|0|0
SYS|GV$WAITSTAT||TABLE/PROCEDURE|VIEW|551|1|0|0|0
SYS|HISTGRM$||TABLE/PROCEDURE|TABLE|1328|1|0|0|0
SYS|HIST_HEAD$||TABLE/PROCEDURE|TABLE|1430|1|0|0|0
SYS|ICOL$||TABLE/PROCEDURE|TABLE|1425|1|0|0|0
SYS|IDGEN1$||TABLE/PROCEDURE|SEQUENCE|867|1|0|0|0
SYS|IDL_CHAR$||TABLE/PROCEDURE|TABLE|1429|1|0|0|0
SYS|IDL_SB4$||TABLE/PROCEDURE|TABLE|1428|1|0|0|0
SYS|IDL_UB1$||TABLE/PROCEDURE|TABLE|1428|1|0|0|0
SYS|IDL_UB2$||TABLE/PROCEDURE|TABLE|1428|1|0|0|0
SYS|ID_GENS$||TABLE/PROCEDURE|TABLE|1216|1|0|0|0
SYS|IND$||TABLE/PROCEDURE|TABLE|1424|1|0|0|0
SYS|INDCOMPART$||TABLE/PROCEDURE|TABLE|1355|1|0|0|0
SYS|INDPART$||TABLE/PROCEDURE|TABLE|1352|1|0|0|0
SYS|INDSUBPART$||TABLE/PROCEDURE|TABLE|1435|1|0|0|0
SYS|IND_ONLINE$||TABLE/PROCEDURE|TABLE|1431|1|0|0|0
SYS|I_CCOL1||INDEX|INDEX|675|1|0|0|0
SYS|I_CCOL2||INDEX|INDEX|547|1|0|0|0
SYS|I_CDEF1||INDEX|INDEX|547|1|0|0|0
SYS|I_CDEF2||INDEX|INDEX|675|1|0|0|0
SYS|I_CDEF3||INDEX|INDEX|547|1|0|0|0
SYS|I_CDEF4||INDEX|INDEX|547|1|0|0|0
SYS|I_COBJ#||INDEX|INDEX|547|1|0|0|0
SYS|I_COL1||INDEX|INDEX|546|1|0|0|0
SYS|I_COL2||INDEX|INDEX|546|1|0|0|0
SYS|I_COL3||INDEX|INDEX|546|1|0|0|0
SYS|I_CON1||INDEX|INDEX|674|1|0|0|0
SYS|I_CON2||INDEX|INDEX|546|1|0|0|0
SYS|I_FILE#_BLOCK#||INDEX|INDEX|554|1|0|0|0
SYS|I_FILE1||INDEX|INDEX|675|1|0|0|0
SYS|I_FILE2||INDEX|INDEX|547|1|0|0|0
SYS|I_HH_OBJ#_COL#||INDEX|INDEX|698|1|0|0|0
SYS|I_HH_OBJ#_INTCOL#||INDEX|INDEX|721|1|0|0|0
SYS|I_H_OBJ#_COL#||INDEX|INDEX|873|1|0|0|0
SYS|I_ICOL1||INDEX|INDEX|547|1|0|0|0
SYS|I_IND1||INDEX|INDEX|546|1|0|0|0
SYS|I_OBJ#||INDEX|INDEX|546|1|0|0|0
SYS|I_OBJ#_INTCOL#||INDEX|INDEX|874|1|0|0|0
SYS|I_OBJ1||INDEX|INDEX|546|1|0|0|0
SYS|I_OBJ2||INDEX|INDEX|546|1|0|0|0
SYS|I_OBJ3||INDEX|INDEX|674|1|0|0|0
SYS|I_PROXY_DATA$||INDEX|INDEX|553|1|0|0|0
SYS|I_PROXY_ROLE_DATA$_1||INDEX|INDEX|560|1|0|0|0
SYS|I_PROXY_ROLE_DATA$_2||INDEX|INDEX|568|1|0|0|0
SYS|I_TAB1||INDEX|INDEX|546|1|0|0|0
SYS|I_TS#||INDEX|INDEX|545|1|0|0|0
SYS|I_TS1||INDEX|INDEX|545|1|0|0|0
SYS|I_UNDO1||INDEX|INDEX|547|1|0|0|0
SYS|I_UNDO2||INDEX|INDEX|675|1|0|0|0
SYS|I_USER#||INDEX|INDEX|547|1|0|0|0
SYS|I_USER1||INDEX|INDEX|675|1|0|0|0
SYS|JOB$||TABLE/PROCEDURE|TABLE|1120|1|0|0|0
SYS|KOPM$||TABLE/PROCEDURE|TABLE|1425|1|0|0|0
SYS|KOTTD$||TABLE/PROCEDURE|TABLE|2070|1|0|0|0
SYS|LINK$||TABLE/PROCEDURE|TABLE|1425|1|0|0|0
SYS|LOB$||TABLE/PROCEDURE|TABLE|1424|1|0|0|0
SYS|LOBFRAG$||TABLE/PROCEDURE|TABLE|1412|1|0|0|0
SYS|LOC$||TABLE/PROCEDURE|TABLE|1424|1|0|0|0
SYS|LOGOFF_PROC||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|LOGON_PROC||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|LT||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|MIGRATE$||TABLE/PROCEDURE|TABLE|1428|1|0|0|0
SYS|NLS_INSTANCE_PARAMETERS||TABLE/PROCEDURE|VIEW|1983|1|0|0|0
SYS|NTAB$||TABLE/PROCEDURE|TABLE|1425|1|0|0|0
SYS|OBJ$||TABLE/PROCEDURE|TABLE|1424|1|0|0|0
SYS|OBJAUTH$||TABLE/PROCEDURE|TABLE|1428|1|0|0|0
SYS|OBJECT_USAGE||TABLE/PROCEDURE|TABLE|1432|1|0|0|0
SYS|OID$||TABLE/PROCEDURE|TABLE|1424|1|0|0|0
SYS|OPQTYPE$||TABLE/PROCEDURE|TABLE|1428|1|0|0|0
SYS|PARTOBJ$||TABLE/PROCEDURE|TABLE|1428|1|0|0|0
SYS|PENDING_TRANS$||TABLE/PROCEDURE|TABLE|1434|1|0|0|0
SYS|PROCEDURE$||TABLE/PROCEDURE|TABLE|1390|1|0|0|0
SYS|PROCEDUREC$||TABLE/PROCEDURE|TABLE|1431|1|0|0|0
SYS|PROCEDUREINFO$||TABLE/PROCEDURE|TABLE|1434|1|0|0|0
SYS|PROCEDUREJAVA$||TABLE/PROCEDURE|TABLE|1434|1|0|0|0
SYS|PROFILE$||TABLE/PROCEDURE|TABLE|1428|1|0|0|0
SYS|PROPS$||TABLE/PROCEDURE|TABLE|1426|1|0|0|0
SYS|PROXY_DATA$||TABLE/PROCEDURE|TABLE|1431|1|0|0|0
SYS|PROXY_ROLE_DATA$||TABLE/PROCEDURE|TABLE|1620|1|0|0|0
SYS|REFCON$||TABLE/PROCEDURE|TABLE|1427|1|0|0|0
SYS|S$KCBWAIT||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KCCDI||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KCCFE||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KCCFN||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KCCLE||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KCCLH||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KCCRT||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KCFIO||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KCVFH||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KGLCURSOR||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KGLDP||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KGLLK||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KGLOB||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KGLST||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KQRST||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KSPPCV||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KSPPI||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KSUSE||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KSUSGSTA||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KSUXSINST||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KTFBFE||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KTFBHC||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KTURD||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$KVIT||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$QUIESCE||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|S$VERSION||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYS|SEG$||TABLE/PROCEDURE|TABLE|1424|1|0|0|0
SYS|SEQ$||TABLE/PROCEDURE|TABLE|1424|1|0|0|0
SYS|SMON_SCN_TIME||TABLE/PROCEDURE|TABLE|1433|1|0|0|0
SYS|SMON_SCN_TO_TIME||CLUSTER|CLUSTER|1436|1|0|0|0
SYS|STANDARD||TABLE/PROCEDURE|PACKAGE|377228|1|0|0|0
SYS|STANDARD||BODY|PACKAGE BODY|26312|1|34|0|0
SYS|STREAMS$_APPLY_PROCESS||TABLE/PROCEDURE|TABLE|1442|1|0|0|0
SYS|STREAMS$_CAPTURE_PROCESS||TABLE/PROCEDURE|TABLE|1444|1|0|0|0
SYS|SUBCOLTYPE$||TABLE/PROCEDURE|TABLE|1431|1|0|0|0
SYS|SYN$||TABLE/PROCEDURE|TABLE|1424|1|0|0|0
SYS|SYS||TABLE/PROCEDURE|NON-EXISTENT|863|1|0|0|0
SYS|SYSAUTH$||TABLE/PROCEDURE|TABLE|1428|1|0|0|0
SYS|SYS_DBA_SEGS||TABLE/PROCEDURE|VIEW|3060|1|0|0|0
SYS|SYS_LOGOFF||TRIGGER|TRIGGER|1834|1|0|0|0
SYS|SYS_LOGON||TRIGGER|TRIGGER|1513|1|0|0|0
SYS|SYS_OBJECTS||TABLE/PROCEDURE|VIEW|3111|1|0|0|0
SYS|TAB$||TABLE/PROCEDURE|TABLE|1664|1|0|0|0
SYS|TABCOMPART$||TABLE/PROCEDURE|TABLE|1431|1|0|0|0
SYS|TABPART$||TABLE/PROCEDURE|TABLE|1428|1|0|0|0
SYS|TABSUBPART$||TABLE/PROCEDURE|TABLE|1431|1|0|0|0
SYS|TRIGGER$||TABLE/PROCEDURE|TABLE|1428|1|0|0|0
SYS|TRIGGERCOL$||TABLE/PROCEDURE|TABLE|1431|1|0|0|0
SYS|TS$||TABLE/PROCEDURE|TABLE|13759|1|0|0|0
SYS|TYPE$||TABLE/PROCEDURE|TABLE|1445|1|0|0|0
SYS|TYPE_MISC$||TABLE/PROCEDURE|TABLE|1430|1|0|0|0
SYS|UET$||TABLE/PROCEDURE|TABLE|9256|1|0|0|0
SYS|UNDO$||TABLE/PROCEDURE|TABLE|1425|1|0|0|0
SYS|USER$||TABLE/PROCEDURE|TABLE|1425|1|0|0|0
SYS|UTL_HTTP||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|UTL_RAW||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|V$ACCESS||TABLE/PROCEDURE|VIEW|548|1|0|0|0
SYS|V$ACTIVE_INSTANCES||TABLE/PROCEDURE|NOT LOADED|0|0|0|0|0
SYS|V$DATABASE||TABLE/PROCEDURE|VIEW|14014|1|0|0|0
SYS|V$DATAFILE||TABLE/PROCEDURE|VIEW|550|1|0|0|0
SYS|V$DBFILE||TABLE/PROCEDURE|VIEW|7928|1|0|0|0
SYS|V$DB_OBJECT_CACHE||TABLE/PROCEDURE|VIEW|557|1|0|0|0
SYS|V$FILESTAT||TABLE/PROCEDURE|VIEW|550|1|0|0|0
SYS|V$INSTANCE||TABLE/PROCEDURE|VIEW|550|1|0|0|0
SYS|V$LIBRARYCACHE||TABLE/PROCEDURE|VIEW|554|1|0|0|0
SYS|V$LOG||TABLE/PROCEDURE|VIEW|545|1|0|0|0
SYS|V$LOGFILE||TABLE/PROCEDURE|VIEW|549|1|0|0|0
SYS|V$LOGHIST||TABLE/PROCEDURE|VIEW|549|1|0|0|0
SYS|V$LOG_HISTORY||TABLE/PROCEDURE|VIEW|553|1|0|0|0
SYS|V$PARAMETER||TABLE/PROCEDURE|VIEW|551|1|0|0|0
SYS|V$ROLLSTAT||TABLE/PROCEDURE|VIEW|550|1|0|0|0
SYS|V$ROWCACHE||TABLE/PROCEDURE|VIEW|550|1|0|0|0
SYS|V$SESSION||TABLE/PROCEDURE|VIEW|549|1|0|0|0
SYS|V$SQLAREA||TABLE/PROCEDURE|VIEW|549|1|0|0|0
SYS|V$SYSSTAT||TABLE/PROCEDURE|VIEW|549|1|0|0|0
SYS|V$VERSION||TABLE/PROCEDURE|VIEW|549|1|0|0|0
SYS|V$WAITSTAT||TABLE/PROCEDURE|VIEW|550|1|0|0|0
SYS|VIEW$||TABLE/PROCEDURE|TABLE|1425|1|0|0|0
SYS|V_$ACCESS||TABLE/PROCEDURE|VIEW|2001|1|0|0|0
SYS|V_$DATABASE||TABLE/PROCEDURE|VIEW|15359|1|0|0|0
SYS|V_$DATAFILE||TABLE/PROCEDURE|VIEW|1991|1|0|0|0
SYS|V_$DBFILE||TABLE/PROCEDURE|VIEW|9201|1|0|0|0
SYS|V_$DB_OBJECT_CACHE||TABLE/PROCEDURE|VIEW|1998|1|0|0|0
SYS|V_$FILESTAT||TABLE/PROCEDURE|VIEW|1991|1|0|0|0
SYS|V_$INSTANCE||TABLE/PROCEDURE|VIEW|1991|1|0|0|0
SYS|V_$LIBRARYCACHE||TABLE/PROCEDURE|VIEW|1995|1|0|0|0
SYS|V_$LOG||TABLE/PROCEDURE|VIEW|1986|1|0|0|0
SYS|V_$LOGFILE||TABLE/PROCEDURE|VIEW|1990|1|0|0|0
SYS|V_$LOGHIST||TABLE/PROCEDURE|VIEW|1990|1|0|0|0
SYS|V_$LOG_HISTORY||TABLE/PROCEDURE|VIEW|1994|1|0|0|0
SYS|V_$ROLLNAME||TABLE/PROCEDURE|VIEW|1991|1|0|0|0
SYS|V_$ROLLSTAT||TABLE/PROCEDURE|VIEW|1991|1|0|0|0
SYS|V_$ROWCACHE||TABLE/PROCEDURE|VIEW|1991|1|0|0|0
SYS|V_$SESSION||TABLE/PROCEDURE|VIEW|1990|1|0|0|0
SYS|V_$SQLAREA||TABLE/PROCEDURE|VIEW|1990|1|0|0|0
SYS|V_$SYSSTAT||TABLE/PROCEDURE|VIEW|1990|1|0|0|0
SYS|V_$VERSION||TABLE/PROCEDURE|VIEW|2014|1|0|0|0
SYS|V_$WAITSTAT||TABLE/PROCEDURE|VIEW|1991|1|0|0|0
SYS|X$KCBWAIT||TABLE/PROCEDURE|TABLE|549|1|0|0|0
SYS|X$KCCDI||TABLE/PROCEDURE|TABLE|547|1|0|0|0
SYS|X$KCCFE||TABLE/PROCEDURE|TABLE|547|1|0|0|0
SYS|X$KCCFN||TABLE/PROCEDURE|TABLE|547|1|0|0|0
SYS|X$KCCLE||TABLE/PROCEDURE|TABLE|547|1|0|0|0
SYS|X$KCCLH||TABLE/PROCEDURE|TABLE|547|1|0|0|0
SYS|X$KCCRT||TABLE/PROCEDURE|TABLE|547|1|0|0|0
SYS|X$KCFIO||TABLE/PROCEDURE|TABLE|547|1|0|0|0
SYS|X$KCVFH||TABLE/PROCEDURE|TABLE|547|1|0|0|0
SYS|X$KGLCURSOR||TABLE/PROCEDURE|TABLE|551|1|0|0|0
SYS|X$KGLDP||TABLE/PROCEDURE|TABLE|547|1|0|0|0
SYS|X$KGLLK||TABLE/PROCEDURE|TABLE|547|1|0|0|0
SYS|X$KGLOB||TABLE/PROCEDURE|TABLE|547|1|0|0|0
SYS|X$KGLST||TABLE/PROCEDURE|TABLE|547|1|0|0|0
SYS|X$KQRST||TABLE/PROCEDURE|TABLE|547|1|0|0|0
SYS|X$KSPPCV||TABLE/PROCEDURE|TABLE|548|1|0|0|0
SYS|X$KSPPI||TABLE/PROCEDURE|TABLE|547|1|0|0|0
SYS|X$KSUSE||TABLE/PROCEDURE|TABLE|547|1|0|0|0
SYS|X$KSUSGSTA||TABLE/PROCEDURE|TABLE|550|1|0|0|0
SYS|X$KSUXSINST||TABLE/PROCEDURE|TABLE|551|1|0|0|0
SYS|X$KTFBFE||TABLE/PROCEDURE|TABLE|548|1|0|0|0
SYS|X$KTFBHC||TABLE/PROCEDURE|TABLE|548|1|0|0|0
SYS|X$KTURD||TABLE/PROCEDURE|TABLE|547|1|0|0|0
SYS|X$KVIT||TABLE/PROCEDURE|TABLE|546|1|0|0|0
SYS|X$QUIESCE||TABLE/PROCEDURE|TABLE|549|1|0|0|0
SYS|X$VERSION||TABLE/PROCEDURE|TABLE|549|1|0|0|0
SYSTEM|AQ$_DEF$_AQCALL_I||INDEX|NOT LOADED|0|1|0|0|0
SYSTEM|AQ$_DEF$_AQERROR_I||INDEX|NOT LOADED|0|1|0|0|0
SYSTEM|AQ$_QUEUES||TABLE/PROCEDURE|TABLE|1993|1|0|0|0
SYSTEM|AQ$_QUEUE_TABLES||TABLE/PROCEDURE|TABLE|1439|1|0|0|0
SYSTEM|DBA_SEGMENTS||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|DBMS_APPLICATION_INFO||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|DBMS_OUTPUT||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|DEF$_AQCALL||TABLE/PROCEDURE|TABLE|1994|1|0|0|0
SYSTEM|DEF$_AQERROR||TABLE/PROCEDURE|TABLE|1435|1|0|0|0
SYSTEM|DUAL||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|GLOBAL_NAME||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|NLS_INSTANCE_PARAMETERS||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|POOL_SIZE||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|REPCAT$_REPPROP||TABLE/PROCEDURE|TABLE|1438|1|0|0|0
SYSTEM|SYSTEM||PUB_SUB|PUB_SUB|929|1|0|1|0
SYSTEM|TIME||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$ACCESS||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$DATABASE||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$DATAFILE||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$DBFILE||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$DB_OBJECT_CACHE||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$FILESTAT||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$INSTANCE||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$LIBRARYCACHE||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$LOG||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$LOGFILE||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$LOGHIST||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$ROLLNAME||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$ROLLSTAT||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$ROWCACHE||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$SESSION||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$SQLAREA||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$SYSSTAT||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$VERSION||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
SYSTEM|V$WAITSTAT||TABLE/PROCEDURE|NOT LOADED|0|1|0|0|0
|ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN'||CURSOR|CURSOR|3912|1|11|1|0
|ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN'||CURSOR|CURSOR|1473|1|0|1|0
|ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CHARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'AMERICAN'  NLS_SORT= 'BINARY' TIME_ZONE= '-04:00' NLS_DUAL_CURRENCY = '$' NLS_TIME_FORMAT = 'HH.MI.SSXFF AM' NLS_TIMESTAMP_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM' NLS_TIME_TZ_FORMAT = 'HH.MI.SSXFF AM TZR' NLS_TIMESTAMP_TZ_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM TZR'||CURSOR|CURSOR|3660|1|1|0|0
|ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CHARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'AMERICAN'  NLS_SORT= 'BINARY' TIME_ZONE= '-04:00' NLS_DUAL_CURRENCY = '$' NLS_TIME_FORMAT = 'HH.MI.SSXFF AM' NLS_TIMESTAMP_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM' NLS_TIME_TZ_FORMAT = 'HH.MI.SSXFF AM TZR' NLS_TIMESTAMP_TZ_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM TZR'||CURSOR|CURSOR|2165|1|0|0|0
|ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CHARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= 'BINARY'||CURSOR|NOT LOADED|0|1|1|0|0
|ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CHARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= 'BINARY'||CURSOR|CURSOR|1664|1|0|0|0
|ALTER SESSION SET NLS_TERRITORY = 'AMERICA'||CURSOR|CURSOR|3660|1|11|1|0
|ALTER SESSION SET NLS_TERRITORY = 'AMERICA'||CURSOR|CURSOR|1461|1|0|1|0
|BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END; ||CURSOR|CURSOR|8040|1|1|0|0
|BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END; ||CURSOR|CURSOR|1472|1|0|0|0
|BEGIN DBMS_OUTPUT.DISABLE; END;||CURSOR|CURSOR|7592|1|1|0|0
|BEGIN DBMS_OUTPUT.DISABLE; END;||CURSOR|CURSOR|1449|1|0|0|0
|BEGIN DBMS_OUTPUT.ENABLE(10240); END;||CURSOR|CURSOR|7836|1|6|0|0
|BEGIN DBMS_OUTPUT.ENABLE(10240); END;||CURSOR|CURSOR|1339|1|0|0|0
|BEGIN DBMS_OUTPUT.ENABLE(2000); END;||CURSOR|CURSOR|8156|1|2|0|0
|BEGIN DBMS_OUTPUT.ENABLE(2000); END;||CURSOR|CURSOR|1454|1|0|0|0
|BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;||CURSOR|CURSOR|9348|1|8|0|0
|BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;||CURSOR|CURSOR|1402|1|0|0|0
|DELETE FROM AQ$_PEND||CURSOR|NOT LOADED|0|0|0|0|0
|DELETE FROM SYS.AQ$_||CURSOR|NOT LOADED|0|0|0|0|0
|DELETE FROM SYS.AQ$_||CURSOR|NOT LOADED|0|0|0|0|0
|DELETE FROM SYS.AQ$_||CURSOR|NOT LOADED|0|0|0|0|0
|INSERT INTO SMON_SCN_TIME (THREAD, TIME_MP, TIME_DP, SCN_WRP, SCN_BAS)  VALUES (:1, :2, :3, :4, :5)||CURSOR|CURSOR|6368|1|4|0|0
|INSERT INTO SMON_SCN_TIME (THREAD, TIME_MP, TIME_DP, SCN_WRP, SCN_BAS)  VALUES (:1, :2, :3, :4, :5)||CURSOR|CURSOR|1517|1|0|0|0
|INSERT INTO SYS.AQ$_||CURSOR|NOT LOADED|0|0|0|0|0
|LOCK TABLE SYS.AQ$_P||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT 'x'   FROM SY||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT * FROM SYS.TS$ WHERE ONLINE$ = 1 ORDER BY NAME ||CURSOR|CURSOR|14352|1|1|0|0
|SELECT * FROM SYS.TS$ WHERE ONLINE$ = 1 ORDER BY NAME ||CURSOR|CURSOR|1472|1|0|0|0
|SELECT /*+ ALL_ROWS IGNORE_WHERE_CLAUSE */ NVL(SUM(C1),0), NVL(SUM(C2),0), COUNT(DISTINCT C3) FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NOPARALLEL("S") */ 1 AS C1, CASE WHEN "S"."TYPE#"<>1 AND "S"."TYPE#"<>5 AND "S"."TYPE#"<>6 AND "S"."TYPE#"<>8 AND "S"."TYPE#"<>10 THEN 1 ELSE 0 END AS C2, "S"."TS#" AS C3 FROM "SYS"."SEG$" "S") SAMPLESUB||CURSOR|CURSOR|10208|1|2|0|0
|SELECT /*+ ALL_ROWS IGNORE_WHERE_CLAUSE */ NVL(SUM(C1),0), NVL(SUM(C2),0), COUNT(DISTINCT C3) FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NOPARALLEL("S") */ 1 AS C1, CASE WHEN "S"."TYPE#"<>1 AND "S"."TYPE#"<>5 AND "S"."TYPE#"<>6 AND "S"."TYPE#"<>8 AND "S"."TYPE#"<>10 THEN 1 ELSE 0 END AS C2, "S"."TS#" AS C3 FROM "SYS"."SEG$" "S") SAMPLESUB||CURSOR|CURSOR|1728|1|0|0|0
|SELECT /*+ ALL_ROWS IGNORE_WHERE_CLAUSE */ NVL(SUM(C1),0), NVL(SUM(C2),0), COUNT(DISTINCT C3) FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NOPARALLEL("S") */ 1 AS C1, CASE WHEN "S"."TYPE#"=1 OR "S"."TYPE#"=10 THEN 1 ELSE 0 END AS C2, "S"."FILE#" AS C3 FROM "SYS"."SEG$" "S") SAMPLESUB||CURSOR|CURSOR|8820|1|2|0|0
|SELECT /*+ ALL_ROWS IGNORE_WHERE_CLAUSE */ NVL(SUM(C1),0), NVL(SUM(C2),0), COUNT(DISTINCT C3) FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NOPARALLEL("S") */ 1 AS C1, CASE WHEN "S"."TYPE#"=1 OR "S"."TYPE#"=10 THEN 1 ELSE 0 END AS C2, "S"."FILE#" AS C3 FROM "SYS"."SEG$" "S") SAMPLESUB||CURSOR|CURSOR|2006|1|0|0|0
|SELECT /*+ ALL_ROWS IGNORE_WHERE_CLAUSE */ NVL(SUM(C1),0), NVL(SUM(C2),0), COUNT(DISTINCT C3) FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NOPARALLEL("UN") */ 1 AS C1, CASE WHEN "UN"."STATUS$"<>1 THEN 1 ELSE 0 END AS C2, "UN"."FILE#" AS C3 FROM "SYS"."UNDO$" "UN") SAMPLESUB||CURSOR|CURSOR|8512|1|2|0|0
|SELECT /*+ ALL_ROWS IGNORE_WHERE_CLAUSE */ NVL(SUM(C1),0), NVL(SUM(C2),0), COUNT(DISTINCT C3) FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NOPARALLEL("UN") */ 1 AS C1, CASE WHEN "UN"."STATUS$"<>1 THEN 1 ELSE 0 END AS C2, "UN"."FILE#" AS C3 FROM "SYS"."UNDO$" "UN") SAMPLESUB||CURSOR|CURSOR|1684|1|0|0|0
|SELECT /*+ ALL_ROWS IGNORE_WHERE_CLAUSE */ NVL(SUM(C1),0), NVL(SUM(C2),0), COUNT(DISTINCT C3) FROM (SELECT /*+ NOPARALLEL("F") */ 1 AS C1, 1 AS C2, "F"."TS#" AS C3 FROM "SYS"."FILE$" "F") SAMPLESUB||CURSOR|CURSOR|7712|1|6|0|0
|SELECT /*+ ALL_ROWS IGNORE_WHERE_CLAUSE */ NVL(SUM(C1),0), NVL(SUM(C2),0), COUNT(DISTINCT C3) FROM (SELECT /*+ NOPARALLEL("F") */ 1 AS C1, 1 AS C2, "F"."TS#" AS C3 FROM "SYS"."FILE$" "F") SAMPLESUB||CURSOR|CURSOR|1615|1|0|0|0
|SELECT /*+ ALL_ROWS IGNORE_WHERE_CLAUSE */ NVL(SUM(C1),0), NVL(SUM(C2),0), COUNT(DISTINCT C3) FROM (SELECT /*+ NOPARALLEL("O") */ 1 AS C1, 1 AS C2, "O"."OBJ#" AS C3 FROM "SYS"."OBJ$" "O") SAMPLESUB||CURSOR|CURSOR|8200|1|2|0|0
|SELECT /*+ ALL_ROWS IGNORE_WHERE_CLAUSE */ NVL(SUM(C1),0), NVL(SUM(C2),0), COUNT(DISTINCT C3) FROM (SELECT /*+ NOPARALLEL("O") */ 1 AS C1, 1 AS C2, "O"."OBJ#" AS C3 FROM "SYS"."OBJ$" "O") SAMPLESUB||CURSOR|CURSOR|1615|1|0|0|0
|SELECT /*+ ALL_ROWS IGNORE_WHERE_CLAUSE */ NVL(SUM(C1),0), NVL(SUM(C2),0), COUNT(DISTINCT C3) FROM (SELECT /*+ NOPARALLEL("S") */ 1 AS C1, 1 AS C2, "S"."FILE#" AS C3 FROM "SYS"."SEG$" "S") SAMPLESUB||CURSOR|CURSOR|7356|1|2|0|0
|SELECT /*+ ALL_ROWS IGNORE_WHERE_CLAUSE */ NVL(SUM(C1),0), NVL(SUM(C2),0), COUNT(DISTINCT C3) FROM (SELECT /*+ NOPARALLEL("S") */ 1 AS C1, 1 AS C2, "S"."FILE#" AS C3 FROM "SYS"."SEG$" "S") SAMPLESUB||CURSOR|CURSOR|1616|1|0|0|0
|SELECT /*+ ALL_ROWS IGNORE_WHERE_CLAUSE */ NVL(SUM(C1),0), NVL(SUM(C2),0), COUNT(DISTINCT C3) FROM (SELECT /*+ NOPARALLEL("TS") */ 1 AS C1, 1 AS C2, "TS"."TS#" AS C3 FROM "SYS"."TS$" "TS") SAMPLESUB||CURSOR|CURSOR|7932|1|6|0|0
|SELECT /*+ ALL_ROWS IGNORE_WHERE_CLAUSE */ NVL(SUM(C1),0), NVL(SUM(C2),0), COUNT(DISTINCT C3) FROM (SELECT /*+ NOPARALLEL("TS") */ 1 AS C1, 1 AS C2, "TS"."TS#" AS C3 FROM "SYS"."TS$" "TS") SAMPLESUB||CURSOR|CURSOR|1852|1|0|0|0
|SELECT /*+ ALL_ROWS IGNORE_WHERE_CLAUSE */ NVL(SUM(C1),0), NVL(SUM(C2),0), COUNT(DISTINCT C3) FROM (SELECT /*+ NOPARALLEL("U") */ 1 AS C1, 1 AS C2, "U"."USER#" AS C3 FROM "SYS"."USER$" "U") SAMPLESUB||CURSOR|CURSOR|7932|1|6|0|0
|SELECT /*+ ALL_ROWS IGNORE_WHERE_CLAUSE */ NVL(SUM(C1),0), NVL(SUM(C2),0), COUNT(DISTINCT C3) FROM (SELECT /*+ NOPARALLEL("U") */ 1 AS C1, 1 AS C2, "U"."USER#" AS C3 FROM "SYS"."USER$" "U") SAMPLESUB||CURSOR|CURSOR|1617|1|0|0|0
|SELECT 1   FROM SYS.||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT 1   FROM SYS.||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT A.OWNER_INSTA||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT COUNT(*)   FR||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT COUNT(*)   FR||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT COUNT(*)   FR||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT COUNT(*)   FR||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT COUNT(*), SUM(BLOCKS)*:B2 FROM SYS.FILE$ FL, V$DBFILE VF WHERE FL.TS# = :B1 AND FL.FILE# = VF.FILE#||CURSOR|CURSOR|13920|1|7|0|0
|SELECT COUNT(*), SUM(BLOCKS)*:B2 FROM SYS.FILE$ FL, V$DBFILE VF WHERE FL.TS# = :B1 AND FL.FILE# = VF.FILE#||CURSOR|CURSOR|1524|1|0|0|0
|SELECT CT.TOID,CT.VE||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT DBTIMEZONE FR||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT DECODE('A','A','1','2') FROM DUAL||CURSOR|CURSOR|3956|1|1|0|0
|SELECT DECODE('A','A','1','2') FROM DUAL||CURSOR|CURSOR|1710|1|0|0|0
|SELECT DISTINCT OBJ#||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT DISTINCT OBJE||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT DISTINCT TO_C||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT DURATION,NEXT||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT ENABLE_FLAG  ||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT EVENTID,PROPE||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT INSTANCE_NUMBER   FROM SYS.V$INSTANCE||CURSOR|CURSOR|24164|1|1|0|0
|SELECT INSTANCE_NUMBER   FROM SYS.V$INSTANCE||CURSOR|CURSOR|1462|1|0|0|0
|SELECT INST_NUMBER,I||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT JOBNO,DISABLE||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT JOBNO,DISABLE||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT JOBNO,INSTANC||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT JOBNO,PROCESS||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT MIN(1)   FROM||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT MIN(TIME_MP), COUNT(*) FROM SMON_SCN_TIME WHERE THREAD = :1||CURSOR|CURSOR|5652|1|4|0|0
|SELECT MIN(TIME_MP), COUNT(*) FROM SMON_SCN_TIME WHERE THREAD = :1||CURSOR|CURSOR|1484|1|0|0|0
|SELECT MSGID,COPY,PM||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT NAME FROM V$DATABASE||CURSOR|CURSOR|49896|1|1|0|0
|SELECT NAME FROM V$DATABASE||CURSOR|CURSOR|1609|1|0|0|0
|SELECT NEXT_DATE   F||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT NEXT_TIME,LAT||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT NLS_CHARSET_D||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT NLS_CHARSET_I||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT NLS_CHARSET_N||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT NULL FROM DUAL FOR UPDATE NOWAIT ||CURSOR|CURSOR|4132|1|1|0|0
|SELECT NULL FROM DUAL FOR UPDATE NOWAIT ||CURSOR|CURSOR|1370|1|0|0|0
|SELECT NULL FROM OBJ$ WHERE NAME='MAP_FILE$' AND OWNER# = 0||CURSOR|CURSOR|6360|1|1|0|0
|SELECT NULL FROM OBJ$ WHERE NAME='MAP_FILE$' AND OWNER# = 0||CURSOR|CURSOR|1477|1|0|0|0
|SELECT O.OBJ#,O.NAME||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT O.OBJ#,O.NAME||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT OBJECT_ID   F||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT OBJECT_NAME,O||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT OWNER,OBJECT_||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT PARTITION_NAM||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT PARTITION_NAM||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT POWER(2,:b1 -||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT PROCESS_NAME ||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT Q.EVENTID   F||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT Q.EVENTID,Q.P||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT Q.EVENTID,T.N||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT Q.NAME,T.SCHE||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT Q.NAME,T.SCHE||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT S.OID SOID,S.||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT S.OID,S.DESTI||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT S.OID,S.DESTINATION,S.INSTANCE,S.JOBNO,AFT.OWNER_INSTANCE   FROM SYS.AQ$_SCHEDULES S,SYSTEM.AQ$_QUEUES Q,SYS.AQ$_QUEUE_TABLE_AFFINITIES AFT  WHERE S.OID = Q.OID  AND Q.TABLE_OBJNO = AFT.TABLE_OBJNO  AND AFT.OWNER_INSTANCE = :b1  AND AFT.OWNER_INSTANCE != S.INSTANCE FOR UPDATE OF S.INSTANCE||CURSOR|CURSOR|12844|1|1|0|0
|SELECT S.OID,S.DESTINATION,S.INSTANCE,S.JOBNO,AFT.OWNER_INSTANCE   FROM SYS.AQ$_SCHEDULES S,SYSTEM.AQ$_QUEUES Q,SYS.AQ$_QUEUE_TABLE_AFFINITIES AFT  WHERE S.OID = Q.OID  AND Q.TABLE_OBJNO = AFT.TABLE_OBJNO  AND AFT.OWNER_INSTANCE = :b1  AND AFT.OWNER_INSTANCE != S.INSTANCE FOR UPDATE OF S.INSTANCE||CURSOR|CURSOR|1715|1|0|0|0
|SELECT S.TOTAL_TIME,||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT SOUNDEX(:B1) ||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT STATUS   FROM||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT STATUS,SEQUEN||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT SUM(COUNT(*)), SUM(DECODE(SIGN(MAX(EXT#)-10), -1, 0, 1)), SUM(DECODE(SIGN(MAX(EXT#)-100), -1, 0, 1)), MAX(MAX(EXT#)) FROM SYS.UET$ US WHERE US.TS# = :B1 GROUP BY SEGFILE#, SEGBLOCK#||CURSOR|CURSOR|8828|1|7|0|0
|SELECT SUM(COUNT(*)), SUM(DECODE(SIGN(MAX(EXT#)-10), -1, 0, 1)), SUM(DECODE(SIGN(MAX(EXT#)-100), -1, 0, 1)), MAX(MAX(EXT#)) FROM SYS.UET$ US WHERE US.TS# = :B1 GROUP BY SEGFILE#, SEGBLOCK#||CURSOR|CURSOR|1606|1|0|0|0
|SELECT SUM(LENGTH)*:B2, DECODE(SUM(LENGTH), 0, 100, SUM(LENGTH)*:B2*100/:B3), COUNT(*), MAX(LENGTH)*:B2, SUM(DECODE(SIGN(LENGTH*:B2-100*1024), 1, 0, 1)), SUM(DECODE(SIGN(LENGTH-5), 1, 0, 1)) FROM SYS.FET$ FS WHERE FS.TS# = :B1||CURSOR|CURSOR|9628|1|7|0|0
|SELECT SUM(LENGTH)*:B2, DECODE(SUM(LENGTH), 0, 100, SUM(LENGTH)*:B2*100/:B3), COUNT(*), MAX(LENGTH)*:B2, SUM(DECODE(SIGN(LENGTH*:B2-100*1024), 1, 0, 1)), SUM(DECODE(SIGN(LENGTH-5), 1, 0, 1)) FROM SYS.FET$ FS WHERE FS.TS# = :B1||CURSOR|CURSOR|1644|1|0|0|0
|SELECT SYSDATE   FRO||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT SYSDATE FROM ||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT SYSTIMESTAMP ||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT SYS_CONTEXT(:||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT SYS_CONTEXT(:||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT SYS_GUID() FR||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT T.NAME   FROM||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT UID   FROM DU||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT UID FROM SYS.||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT USER   FROM D||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT USER FROM DUAL ||CURSOR|CURSOR|3936|1|1|0|0
|SELECT USER FROM DUAL ||CURSOR|CURSOR|1680|1|0|0|0
|SELECT USER FROM SYS||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT USERENV('CLIE||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT USERENV('ENTR||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT USERENV('INST||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT USERENV('ISDB||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT USERENV('LANG||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT USERENV('LANG||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT USERENV('SCHE||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT USERENV('SESS||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT USERENV('TERM||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT VALUE   FROM ||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'||CURSOR|CURSOR|23880|1|11|1|0
|SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'||CURSOR|CURSOR|1494|1|0|1|0
|SELECT VALUE$   FROM||CURSOR|NOT LOADED|0|0|0|0|0
|SELECT apply#, apply_name FROM sys.streams$_apply_process  WHERE  status = :1 ORDER BY apply#||CURSOR|CURSOR|6676|1|1|0|0
|SELECT apply#, apply_name FROM sys.streams$_apply_process  WHERE  status = :1 ORDER BY apply#||CURSOR|CURSOR|1511|1|0|0|0
|SELECT capture#, capture_name FROM sys.streams$_capture_process  WHERE  status = :1 ORDER BY capture#||CURSOR|CURSOR|5880|1|1|0|0
|SELECT capture#, capture_name FROM sys.streams$_capture_process  WHERE  status = :1 ORDER BY capture#||CURSOR|CURSOR|1519|1|0|0|0
|Select 'Instance   : ' || Global_Name , 'Report Date: '||        To_char(Sysdate,'Month DD')||', '||        To_char(Sysdate,'YYYY')||' at '||        To_char(Sysdate,'HH24:MM:SS') From Global_Name||CURSOR|CURSOR|7632|1|8|0|0
|Select 'Instance   : ' || Global_Name , 'Report Date: '||        To_char(Sysdate,'Month DD')||', '||        To_char(Sysdate,'YYYY')||' at '||        To_char(Sysdate,'HH24:MM:SS') From Global_Name||CURSOR|CURSOR|1613|1|0|0|0
|Select A.Class, Count, Sum(Value)/1000000000 Con_Get,        ((Count / Sum(Value)) * 100) pct From V$WaitStat A, V$SysStat B Where Name In ('db block gets', 'consistent gets') Group by A.Class, Count ||CURSOR|CURSOR|26732|1|1|0|0
|Select A.Class, Count, Sum(Value)/1000000000 Con_Get,        ((Count / Sum(Value)) * 100) pct From V$WaitStat A, V$SysStat B Where Name In ('db block gets', 'consistent gets') Group by A.Class, Count ||CURSOR|CURSOR|1618|1|0|0|0
|Select C.TableSpace_Name,        B.Name,        A.Phyrds/1000000 Phyrds,        A.Phywrts/1000000 Phywrts,        A.Phyblkrd/1000000 Phyblkrd,        A.Phyblkwrt/1000000 Phyblkwrt,        ((A.ReadTim / Decode(A.Phyrds, 0, 1, A.Phyblkrd)) / 100) Avg_Rd_Time,        ((A.WriteTim / Decode(A.PhyWrts, 0, 1, A.PhyblkWrt)) / 100) Avg_Wrt_Time From V$FileStat A, V$DataFile B, Sys.DBA_Data_Files C Where B.File# = A.File#   And B.File# = C.File_Id Order By TableSpace_Name ||CURSOR|CURSOR|121604|1|1|0|0
|Select C.TableSpace_Name,        B.Name,        A.Phyrds/1000000 Phyrds,        A.Phywrts/1000000 Phywrts,        A.Phyblkrd/1000000 Phyblkrd,        A.Phyblkwrt/1000000 Phyblkwrt,        ((A.ReadTim / Decode(A.Phyrds, 0, 1, A.Phyblkrd)) / 100) Avg_Rd_Time,        ((A.WriteTim / Decode(A.PhyWrts, 0, 1, A.PhyblkWrt)) / 100) Avg_Wrt_Time From V$FileStat A, V$DataFile B, Sys.DBA_Data_Files C Where B.File# = A.File#   And B.File# = C.File_Id Order By TableSpace_Name ||CURSOR|CURSOR|1853|1|0|0|0
|Select Global_Name Instance From Global_Name||CURSOR|CURSOR|5872|1|1|0|0
|Select Global_Name Instance From Global_Name||CURSOR|CURSOR|1462|1|0|0|0
|Select Owner,        Segment_Name,        Segment_Type,        TableSpace_Name,        Extents,        Max_Extents From Sys.DBA_Segments Where Extents > 10 AND Owner not in ('SYS', 'SYSTEM') Order By TableSpace_Name ||CURSOR|CURSOR|149988|1|1|0|0
|Select Owner,        Segment_Name,        Segment_Type,        TableSpace_Name,        Extents,        Max_Extents From Sys.DBA_Segments Where Extents > 10 AND Owner not in ('SYS', 'SYSTEM') Order By TableSpace_Name ||CURSOR|CURSOR|1986|1|0|0|0
|Select Owner, Object_Name, Object_Type, Created, Last_DDL_Time From Sys.DBA_Objects Where Status = 'INVALID' Order By Owner, Object_Type ||CURSOR|CURSOR|41760|1|1|0|0
|Select Owner, Object_Name, Object_Type, Created, Last_DDL_Time From Sys.DBA_Objects Where Status = 'INVALID' Order By Owner, Object_Type ||CURSOR|CURSOR|1555|1|0|0|0
|Select Segment_Name,        Segment_Type,        TableSpace_Name,        Extents,        Max_Extents From Sys.DBA_Segments Where Max_Extents - 15 < Extents   And Max_Extents != 0 Order By TableSpace_Name ||CURSOR|CURSOR|148400|1|1|0|0
|Select Segment_Name,        Segment_Type,        TableSpace_Name,        Extents,        Max_Extents From Sys.DBA_Segments Where Max_Extents - 15 < Extents   And Max_Extents != 0 Order By TableSpace_Name ||CURSOR|CURSOR|1922|1|0|0|0
|Select Segment_Name, Segment_Type, Owner From   Sys.DBA_Segments Where  TableSpace_Name = 'SYSTEM'   And  Owner Not In ('SYS', 'SYSTEM', 'OUTLN') ||CURSOR|CURSOR|126240|1|1|0|0
|Select Segment_Name, Segment_Type, Owner From   Sys.DBA_Segments Where  TableSpace_Name = 'SYSTEM'   And  Owner Not In ('SYS', 'SYSTEM', 'OUTLN') ||CURSOR|CURSOR|1564|1|0|0|0
|Select Sum(Decode(Name, 'physical reads', value, 0)) Dsk_Rds,        Sum(Decode(Name, 'db block gets', value, 0)) Blk_Gts,        Sum(Decode(Name, 'consistent gets', value, 0)) Con_Gts,        ((1 - (Sum(Decode(Name, 'physical reads', value, 0)) /         (Sum(Decode(Name, 'db block gets', value, 0)) +          Sum(Decode(Name, 'consistent gets', value, 0))))) * 100) Hit_Rate From V$SysStat||CURSOR|CURSOR|17116|1|1|0|0
|Select Sum(Decode(Name, 'physical reads', value, 0)) Dsk_Rds,        Sum(Decode(Name, 'db block gets', value, 0)) Blk_Gts,        Sum(Decode(Name, 'consistent gets', value, 0)) Con_Gts,        ((1 - (Sum(Decode(Name, 'physical reads', value, 0)) /         (Sum(Decode(Name, 'db block gets', value, 0)) +          Sum(Decode(Name, 'consistent gets', value, 0))))) * 100) Hit_Rate From V$SysStat||CURSOR|CURSOR|1811|1|0|0|0
|Select Sum(Pins) Pins, Sum(PinHits) PinHits,        ((Sum(PinHits) / Sum(Pins)) * 100) PHitRat,        Sum(Reloads) Reloads,        ((Sum(Pins) / (Sum(Pins) + Sum(Reloads))) * 100)  HitRat From V$LibraryCache||CURSOR|CURSOR|26032|1|1|0|0
|Select Sum(Pins) Pins, Sum(PinHits) PinHits,        ((Sum(PinHits) / Sum(Pins)) * 100) PHitRat,        Sum(Reloads) Reloads,        ((Sum(Pins) / (Sum(Pins) + Sum(Reloads))) * 100)  HitRat From V$LibraryCache||CURSOR|CURSOR|1626|1|0|0|0
|Select Sum(gets) Gets, Sum(getmisses) Misses,        (1-(Sum(getmisses)/Sum(gets))) * 100 Hit_Ratio from V$RowCache ||CURSOR|CURSOR|20992|1|1|0|0
|Select Sum(gets) Gets, Sum(getmisses) Misses,        (1-(Sum(getmisses)/Sum(gets))) * 100 Hit_Ratio from V$RowCache ||CURSOR|CURSOR|1534|1|0|0|0
|Select TableSpace_Name, Owner, Segment_Name, Segment_Type,        To_Char((Next_Extent / 1024), '999,999') || 'K' Nxt_Ext From  Sys.DBA_Segments A Where Not Exists (Select 'x'                   From Sys.DBA_Free_Space B                   Where A.TableSpace_Name = B.TableSpace_Name                     And B.Bytes >= A.Next_Extent) Order By TableSpace_Name, Segment_Name ||CURSOR|CURSOR|284304|1|1|0|0
|Select TableSpace_Name, Owner, Segment_Name, Segment_Type,        To_Char((Next_Extent / 1024), '999,999') || 'K' Nxt_Ext From  Sys.DBA_Segments A Where Not Exists (Select 'x'                   From Sys.DBA_Free_Space B                   Where A.TableSpace_Name = B.TableSpace_Name                     And B.Bytes >= A.Next_Extent) Order By TableSpace_Name, Segment_Name ||CURSOR|CURSOR|1789|1|0|0|0
|UPDATE SYS.AQ$_PROPA||CURSOR|NOT LOADED|0|0|0|0|0
|UPDATE SYS.AQ$_SCHED||CURSOR|NOT LOADED|0|0|0|0|0
|UPDATE SYS.AQ$_SCHED||CURSOR|NOT LOADED|0|0|0|0|0
|UPDATE SYS.AQ$_SCHED||CURSOR|NOT LOADED|0|0|0|0|0
|UPDATE SYS.AQ$_SCHED||CURSOR|NOT LOADED|0|0|0|0|0
|UPDATE SYS.AQ$_SCHED||CURSOR|NOT LOADED|0|0|0|0|0
|UPDATE SYS.AQ$_SCHED||CURSOR|NOT LOADED|0|0|0|0|0
|UPDATE SYS.AQ$_SCHED||CURSOR|NOT LOADED|0|0|0|0|0
|UPDATE SYS.AQ$_SCHED||CURSOR|NOT LOADED|0|0|0|0|0
|UPDATE SYS.AQ$_SCHED||CURSOR|NOT LOADED|0|0|0|0|0
|UPDATE SYS.AQ$_SCHED||CURSOR|NOT LOADED|0|0|0|0|0
|UPDATE SYS.AQ$_SCHED||CURSOR|NOT LOADED|0|0|0|0|0
|UPDATE SYS.AQ$_SCHED||CURSOR|NOT LOADED|0|0|0|0|0
|alter database mount exclusive ||CURSOR|NOT LOADED|0|1|1|0|0
|alter database mount exclusive ||CURSOR|CURSOR|1449|1|0|0|0
|alter database open||CURSOR|NOT LOADED|0|1|1|0|0
|alter database open||CURSOR|CURSOR|1437|1|0|0|0
|begin dbms_output.put_line(''); end;||CURSOR|CURSOR|8112|1|7|0|0
|begin dbms_output.put_line(''); end;||CURSOR|CURSOR|1455|1|0|0|0
|begin sys.dbms_prvtaqip.update_aqs_instance(); end;||CURSOR|CURSOR|7836|1|1|0|0
|begin sys.dbms_prvtaqip.update_aqs_instance(); end;||CURSOR|CURSOR|1305|1|0|0|0
|declare   dbnm    varchar2(8);   files   number;   sizem   number;   freem   number;   pctf    number;   pieces  number;   biggest number;   lt100k  number;   dead    number;   mexts   number;   nsegs   number;   gt10e   number;   gt100e  number;   moste   number; begin    select     name   into dbnm   from v$database;    dbms_output.put_line('FREE SPACE - '||RPAD(dbnm,8)||' +------------- FREE ------------+ +------  USED ------+');   dbms_output.put_line('Tspace       Fl SizeM FreeM %Fre Piecs BigsM <100k Dead NmSegs >10e >100 Most');   dbms_output.put_line('------------ -- ----- ----- ---- ----- ----- ----- ---- ------ ---- ---- ----');    for r in (     select *     from sys.ts$     where online$ = 1     order by name   ) loop       select        count(*),        sum(blocks)*r.blocksize      into files, sizem      from sys.file$ fl, v$dbfile vf      where fl.ts# = r.ts#      and fl.file# = vf.file#; -- make sure dropped files don't show       select        sum(length)*r.blocksize, ||CURSOR|CURSOR|13028|1|1|0|0
|declare   dbnm    varchar2(8);   files   number;   sizem   number;   freem   number;   pctf    number;   pieces  number;   biggest number;   lt100k  number;   dead    number;   mexts   number;   nsegs   number;   gt10e   number;   gt100e  number;   moste   number; begin    select     name   into dbnm   from v$database;    dbms_output.put_line('FREE SPACE - '||RPAD(dbnm,8)||' +------------- FREE ------------+ +------  USED ------+');   dbms_output.put_line('Tspace       Fl SizeM FreeM %Fre Piecs BigsM <100k Dead NmSegs >10e >100 Most');   dbms_output.put_line('------------ -- ----- ----- ---- ----- ----- ----- ---- ------ ---- ---- ----');    for r in (     select *     from sys.ts$     where online$ = 1     order by name   ) loop       select        count(*),        sum(blocks)*r.blocksize      into files, sizem      from sys.file$ fl, v$dbfile vf      where fl.ts# = r.ts#      and fl.file# = vf.file#; -- make sure dropped files don't show       select        sum(length)*r.blocksize, ||CURSOR|CURSOR|3834|1|0|0|0
|insert into sys.col_usage$ values (   :objn, :coln,   decode(bitand(:flag,1),0,0,1),   decode(bitand(:flag,2),0,0,1),   decode(bitand(:flag,4),0,0,1),   decode(bitand(:flag,8),0,0,1),   decode(bitand(:flag,16),0,0,1),   decode(bitand(:flag,32),0,0,1),   :time)||CURSOR|CURSOR|14352|1|0|0|0
|insert into sys.col_usage$ values (   :objn, :coln,   decode(bitand(:flag,1),0,0,1),   decode(bitand(:flag,2),0,0,1),   decode(bitand(:flag,4),0,0,1),   decode(bitand(:flag,8),0,0,1),   decode(bitand(:flag,16),0,0,1),   decode(bitand(:flag,32),0,0,1),   :time)||CURSOR|CURSOR|1678|1|0|0|0
|lock table sys.col_usage$ in exclusive mode nowait||CURSOR|CURSOR|3440|1|12|0|0
|lock table sys.col_usage$ in exclusive mode nowait||CURSOR|CURSOR|1468|1|0|0|0
|select 'Switches occur at a rate of 1 switch every '||        round((7*24*60)/decode(count(*),count(*),-1))||' minutes over the past week' from v$loghist where first_time >= sysdate-7||CURSOR|CURSOR|14584|1|1|0|0
|select 'Switches occur at a rate of 1 switch every '||        round((7*24*60)/decode(count(*),count(*),-1))||' minutes over the past week' from v$loghist where first_time >= sysdate-7||CURSOR|CURSOR|1601|1|0|0|0
|select 'to_char(first_time,''DD/MM/YY HH24:MI:SS'')' time from   dual where  902000500 like '8%'      -- Oracle8 ||CURSOR|CURSOR|4096|1|1|0|0
|select 'to_char(first_time,''DD/MM/YY HH24:MI:SS'')' time from   dual where  902000500 like '8%'      -- Oracle8 ||CURSOR|CURSOR|1803|1|0|0|0
|select * from V$ACCESS||CURSOR|CURSOR|26372|1|1|0|0
|select * from V$ACCESS||CURSOR|CURSOR|1412|1|0|0|0
|select * from v$db_object_cache||CURSOR|CURSOR|54748|1|1|0|0
|select * from v$db_object_cache||CURSOR|CURSOR|1449|1|0|0|0
|select * from v$rowcache||CURSOR|CURSOR|33832|1|1|0|0
|select * from v$rowcache||CURSOR|CURSOR|1442|1|0|0|0
|select * pool_size f||CURSOR|NOT LOADED|0|1|0|0|0
|select * pool_size f||CURSOR|CURSOR|1396|1|0|0|0
|select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#||CURSOR|CURSOR|7496|1|34|0|0
|select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#||CURSOR|CURSOR|1553|1|0|0|0
|select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#||CURSOR|CURSOR|7536|1|34|0|0
|select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#||CURSOR|CURSOR|1550|1|0|0|0
|select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#||CURSOR|CURSOR|7348|1|34|0|0
|select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#||CURSOR|CURSOR|1550|1|0|0|0
|select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#||CURSOR|CURSOR|7412|1|34|0|0
|select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#||CURSOR|CURSOR|1550|1|0|0|0
|select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2||CURSOR|CURSOR|10468|1|113|0|0
|select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2||CURSOR|CURSOR|1628|1|0|0|0
|select 1 from aq$_schedules||CURSOR|CURSOR|4088|1|1|0|0
|select 1 from aq$_schedules||CURSOR|CURSOR|1345|1|0|0|0
|select 1 from dual where exists (select 1 from system.repcat$_repprop prop  where prop.type in (-1,2,9,-4) and prop.how in (1,3))||CURSOR|CURSOR|8824|1|1|0|0
|select 1 from dual where exists (select 1 from system.repcat$_repprop prop  where prop.type in (-1,2,9,-4) and prop.how in (1,3))||CURSOR|CURSOR|1547|1|0|0|0
|select 1 from sys.aq$_queue_table_affinities||CURSOR|CURSOR|3540|1|1|0|0
|select 1 from sys.aq$_queue_table_affinities||CURSOR|CURSOR|1462|1|0|0|0
|select OPEN_MODE from v$database||CURSOR|CURSOR|48892|1|1|0|0
|select OPEN_MODE from v$database||CURSOR|CURSOR|1450|1|0|0|0
|select OWNER,  NAME,  DB_LINK,  NAMESPACE,  TYPE,         SHARABLE_MEM,         LOADS,         EXECUTIONS,         LOCKS,         PINS from  v$db_object_cache order  by OWNER, NAME ||CURSOR|CURSOR|52584|1|0|1|1
|select OWNER,  NAME,  DB_LINK,  NAMESPACE,  TYPE,         SHARABLE_MEM,         LOADS,         EXECUTIONS,         LOCKS,         PINS from  v$db_object_cache order  by OWNER, NAME ||CURSOR|CURSOR|1415|1|0|1|0
|select SCHEMANAME, OSUSER, MACHINE, PROGRAM from V$SESSION where SCHEMA# > 0||CURSOR|CURSOR|52236|1|1|0|0
|select SCHEMANAME, OSUSER, MACHINE, PROGRAM from V$SESSION where SCHEMA# > 0||CURSOR|CURSOR|1442|1|0|0|0
|select TOTAL from SYS.ID_GENS$||CURSOR|CURSOR|3336|1|1|0|0
|select TOTAL from SYS.ID_GENS$||CURSOR|CURSOR|1448|1|0|0|0
|select a.name, status, b.extents, b.rssize, optsize, b.xacts,        b.gets, b.waits, ((b.waits / b.gets) * 100) pct from v$rollname a, v$rollstat b where a.usn = b.usn||CURSOR|CURSOR|37368|1|1|0|0
|select a.name, status, b.extents, b.rssize, optsize, b.xacts,        b.gets, b.waits, ((b.waits / b.gets) * 100) pct from v$rollname a, v$rollstat b where a.usn = b.usn||CURSOR|CURSOR|1586|1|0|0|0
|select a.schema, a.name, b.name, b.eventid from system.aq$_queues b, system.aq$_queue_tables a, sys.aq$_queue_table_affinities t  where a.objno = b.table_objno and t.table_objno = b.table_objno and bitand(b.properties, 512) = 512 and t.owner_instance = :1||CURSOR|CURSOR|11832|1|1|0|0
|select a.schema, a.name, b.name, b.eventid from system.aq$_queues b, system.aq$_queue_tables a, sys.aq$_queue_table_affinities t  where a.objno = b.table_objno and t.table_objno = b.table_objno and bitand(b.properties, 512) = 512 and t.owner_instance = :1||CURSOR|CURSOR|1673|1|0|0|0
|select action# from trigger$ where obj# = :1||CURSOR|CURSOR|5636|1|2|0|0
|select action# from trigger$ where obj# = :1||CURSOR|CURSOR|1462|1|0|0|0
|select actionsize from trigger$ where obj# = :1||CURSOR|CURSOR|5640|1|2|0|0
|select actionsize from trigger$ where obj# = :1||CURSOR|CURSOR|1465|1|0|0|0
|select audit$,options from procedure$ where obj#=:1||CURSOR|CURSOR|5384|1|17|0|0
|select audit$,options from procedure$ where obj#=:1||CURSOR|CURSOR|1469|1|0|0|0
|select audit$,properties from type_misc$ where obj#=:1||CURSOR|CURSOR|5596|1|4|0|0
|select audit$,properties from type_misc$ where obj#=:1||CURSOR|CURSOR|1472|1|0|0|0
|select banner from v$version where banner like '%racle%'||CURSOR|CURSOR|8764|1|1|0|0
|select banner from v$version where banner like '%racle%'||CURSOR|CURSOR|1822|1|0|0|0
|select baseobject,type#,update$,insert$,delete$,refnewname,refoldname,whenclause,definition,enabled,property,sys_evts,nttrigcol,nttrigatt,refprtname,rowid from trigger$ where obj# =:1||CURSOR|CURSOR|9484|1|2|0|0
|select baseobject,type#,update$,insert$,delete$,refnewname,refoldname,whenclause,definition,enabled,property,sys_evts,nttrigcol,nttrigatt,refprtname,rowid from trigger$ where obj# =:1||CURSOR|CURSOR|1933|1|0|0|0
|select blevel, leafcnt, distkey, lblkkey, dblkkey, clufac,        nvl(degree,1), nvl(instances,1) from ind$ where bo# = :1 and obj# = :2||CURSOR|NOT LOADED|0|1|31|0|0
|select blevel, leafcnt, distkey, lblkkey, dblkkey, clufac,        nvl(degree,1), nvl(instances,1) from ind$ where bo# = :1 and obj# = :2||CURSOR|CURSOR|1554|1|0|0|0
|select blocks,NVL(ts#,-1),status$,NVL(relfile#,0),maxextend,inc, crscnwrp,crscnbas,NVL(spare1,0) from file$ where file#=:1||CURSOR|CURSOR|8520|1|5|0|0
|select blocks,NVL(ts#,-1),status$,NVL(relfile#,0),maxextend,inc, crscnwrp,crscnbas,NVL(spare1,0) from file$ where file#=:1||CURSOR|CURSOR|1844|1|0|0|0
|select charsetid, charsetform from col$  where obj# = :1 and col# = :2||CURSOR|NOT LOADED|0|1|45|0|0
|select charsetid, charsetform from col$  where obj# = :1 and col# = :2||CURSOR|CURSOR|1488|1|0|0|0
|select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#||CURSOR|CURSOR|8136|2|62|0|0
|select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#||CURSOR|CURSOR|1499|1|0|0|0
|select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc||CURSOR|CURSOR|7652|1|38|0|0
|select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc||CURSOR|CURSOR|1504|1|0|0|0
|select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc||CURSOR|CURSOR|7316|1|38|0|0
|select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc||CURSOR|CURSOR|1489|1|0|0|0
|select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc||CURSOR|CURSOR|7652|1|38|0|0
|select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc||CURSOR|CURSOR|1508|1|0|0|0
|select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc||CURSOR|CURSOR|9160|1|38|0|0
|select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc||CURSOR|CURSOR|1559|1|0|0|0
|select cols,audit$,textlength,intcols,property,flags,rowid from view$ where obj#=:1||CURSOR|CURSOR|6420|1|29|0|0
|select cols,audit$,textlength,intcols,property,flags,rowid from view$ where obj#=:1||CURSOR|CURSOR|1501|1|0|0|0
|select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1||CURSOR|CURSOR|8312|2|10|0|0
|select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1||CURSOR|CURSOR|1487|1|0|0|0
|select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),rowid,cols,nvl(defer,0),mtime,nvl(spare1,0) from cdef$ where obj#=:1||CURSOR|CURSOR|10820|2|11|0|0
|select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),rowid,cols,nvl(defer,0),mtime,nvl(spare1,0) from cdef$ where obj#=:1||CURSOR|CURSOR|1564|1|0|0|0
|select count(*) from dba_jobs where what = 'sys.dbms_aqadm_sys.register_driver();'||CURSOR|CURSOR|6520|1|1|0|0
|select count(*) from dba_jobs where what = 'sys.dbms_aqadm_sys.register_driver();'||CURSOR|CURSOR|1500|1|0|0|0
|select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))||CURSOR|CURSOR|5836|1|227|1|0
|select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))||CURSOR|CURSOR|1515|1|0|1|0
|select count(*) from sys.job$ where next_date < :1 and (field1 = :2 or (field1 = 0 and 'Y' = :3))                              ||CURSOR|CURSOR|7644|1|3|1|0
|select count(*) from sys.job$ where next_date < :1 and (field1 = :2 or (field1 = 0 and 'Y' = :3))                              ||CURSOR|CURSOR|1809|1|0|1|0
|select ctime, mtime, stime from obj$ where obj# = :1||CURSOR|NOT LOADED|0|1|55|0|0
|select ctime, mtime, stime from obj$ where obj# = :1||CURSOR|CURSOR|1470|1|0|0|0
|select database_status from v$instance||CURSOR|CURSOR|25480|1|1|0|0
|select database_status from v$instance||CURSOR|CURSOR|1732|1|0|0|0
|select distinct(-privilege#),nvl(option$,0) from sysauth$ where grantee#=:1 and privilege#<0||CURSOR|CURSOR|6448|1|10|0|0
|select distinct(-privilege#),nvl(option$,0) from sysauth$ where grantee#=:1 and privilege#<0||CURSOR|CURSOR|1510|1|0|0|0
|select f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t where t.ts#=f.ts# and t.dflextpct!=0 and t.bitmapped=0||CURSOR|CURSOR|8620|1|3|0|0
|select f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t where t.ts#=f.ts# and t.dflextpct!=0 and t.bitmapped=0||CURSOR|CURSOR|1549|1|0|0|0
|select f.group#, f.status, f.member, l.bytes/1024 bytes from   v$logfile f, v$log l where  f.group# = l.group# order  by f.group#||CURSOR|CURSOR|44300|1|1|0|0
|select f.group#, f.status, f.member, l.bytes/1024 bytes from   v$logfile f, v$log l where  f.group# = l.group# order  by f.group#||CURSOR|CURSOR|1547|1|0|0|0
|select file# from file$ where spare1 is NOT NULL and status$ = 2||CURSOR|CURSOR|5380|1|2|0|0
|select file# from file$ where spare1 is NOT NULL and status$ = 2||CURSOR|CURSOR|1814|1|0|0|0
|select file# from file$ where ts#=:1||CURSOR|CURSOR|5780|2|2349|0|0
|select file# from file$ where ts#=:1||CURSOR|CURSOR|1450|1|0|0|0
|select file#, block#, ts# from seg$ where type# = 3||CURSOR|CURSOR|5304|1|1|0|0
|select file#, block#, ts# from seg$ where type# = 3||CURSOR|CURSOR|1469|1|0|0|0
|select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee#||CURSOR|CURSOR|8192|2|64|0|0
|select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee#||CURSOR|CURSOR|1569|1|0|0|0
|select group#, thread#, sequence#, members,        archived, status, first_change#, first_time from   v$log order  by group#||CURSOR|CURSOR|36316|1|1|0|0
|select group#, thread#, sequence#, members,        archived, status, first_change#, first_time from   v$log order  by group#||CURSOR|CURSOR|1542|1|0|0|0
|select i.obj#, i.flags, u.name, o.name, o.type#     from sys.obj$ o, sys.user$ u, sys.ind$ idx, sys.ind_online$ i    where  bitand(i.flags, 512) = 512 and o.obj#=idx.obj# and           o.owner# = u.user# and idx.obj#=i.obj# ||CURSOR|CURSOR|13928|1|1|0|0
|select i.obj#, i.flags, u.name, o.name, o.type#     from sys.obj$ o, sys.user$ u, sys.ind$ idx, sys.ind_online$ i    where  bitand(i.flags, 512) = 512 and o.obj#=idx.obj# and           o.owner# = u.user# and idx.obj#=i.obj# ||CURSOR|CURSOR|1642|1|0|0|0
|select i.obj#, i.flags, u.name, o.name, o.type#     from sys.obj$ o, sys.user$ u, sys.ind_online$ i    where  (bitand(i.flags, 256) = 256 or bitand(i.flags, 512) = 512) and           (not((i.type# = 9) and bitand(i.flags,8) = 8)) and           o.obj#=i.obj# and o.owner# = u.user#||CURSOR|CURSOR|13024|1|1|0|0
|select i.obj#, i.flags, u.name, o.name, o.type#     from sys.obj$ o, sys.user$ u, sys.ind_online$ i    where  (bitand(i.flags, 256) = 256 or bitand(i.flags, 512) = 512) and           (not((i.type# = 9) and bitand(i.flags,8) = 8)) and           o.obj#=i.obj# and o.owner# = u.user#||CURSOR|CURSOR|1570|1|0|0|0
|select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags, i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey, i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#, nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0), nvl(i.spare1,i.intcols),i.spare4,spare2,spare6, decode(i.pctthres$,null,null, mod(trunc(i.pctthres$/256),256)) from ind$ i, (select enabled, min(cols) unicols, min(to_number(bitand(defer,1))) deferrable#, min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.bo#=:1||CURSOR|CURSOR|27132|2|69|0|0
|select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags, i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey, i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#, nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0), nvl(i.spare1,i.intcols),i.spare4,spare2,spare6, decode(i.pctthres$,null,null, mod(trunc(i.pctthres$/256),256)) from ind$ i, (select enabled, min(cols) unicols, min(to_number(bitand(defer,1))) deferrable#, min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.bo#=:1||CURSOR|CURSOR|1967|1|0|0|0
|select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$,flags from seq$ where obj#=:1||CURSOR|CURSOR|7736|1|3|0|0
|select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$,flags from seq$ where obj#=:1||CURSOR|CURSOR|1520|1|0|0|0
|select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc||CURSOR|CURSOR|7872|1|38|0|0
|select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc||CURSOR|CURSOR|1535|1|0|0|0
|select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1||CURSOR|CURSOR|6868|2|45|0|0
|select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1||CURSOR|CURSOR|1474|1|0|0|0
|select intcol#,type,flags,lobcol,objcol,extracol,schemaoid,  elemnum from opqtype$ where obj# = :1 order by intcol# asc||CURSOR|CURSOR|8516|1|38|0|0
|select intcol#,type,flags,lobcol,objcol,extracol,schemaoid,  elemnum from opqtype$ where obj# = :1 order by intcol# asc||CURSOR|CURSOR|1505|1|0|0|0
|select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date < :2))    or  ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job    ||CURSOR|CURSOR|10880|1|226|1|0
|select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date < :2))    or  ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job    ||CURSOR|CURSOR|1663|1|0|1|0
|select job, nvl2(last_date, 1, 0) from sys.job$ where next_date < :1 and (field1 = :2 or (field1 = 0 and 'Y' = :3)) order by next_date, job                                                                                                          ||CURSOR|CURSOR|8156|1|1|0|0
|select job, nvl2(last_date, 1, 0) from sys.job$ where next_date < :1 and (field1 = :2 or (field1 = 0 and 'Y' = :3)) order by next_date, job                                                                                                          ||CURSOR|CURSOR|1663|1|0|0|0
|select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc||CURSOR|CURSOR|9672|1|38|0|0
|select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc||CURSOR|CURSOR|1609|1|0|0|0
|select length from fet$ where file#=:1 and block#=:2 and ts#=:3||CURSOR|CURSOR|6284|1|1|0|0
|select length from fet$ where file#=:1 and block#=:2 and ts#=:3||CURSOR|CURSOR|1481|1|0|0|0
|select limit# from profile$ where profile#=:1 and resource#=:2 and type#=:3||CURSOR|CURSOR|6460|1|17|0|0
|select limit# from profile$ where profile#=:1 and resource#=:2 and type#=:3||CURSOR|CURSOR|1861|1|0|0|0
|select line#, sql_text from bootstrap$ where obj# != :1||CURSOR|NOT LOADED|0|1|1|0|0
|select line#, sql_text from bootstrap$ where obj# != :1||CURSOR|CURSOR|1473|1|0|0|0
|select line,position#,text from error$ where obj# = :1  order by sequence#||CURSOR|CURSOR|6436|1|4|0|0
|select line,position#,text from error$ where obj# = :1  order by sequence#||CURSOR|CURSOR|1492|1|0|0|0
|select local_tran_id, global_tran_fmt, global_oracle_id, global_foreign_id,        state, status, heuristic_dflt,        session_vector, reco_vector, 3600*24*(sysdate-reco_time),        3600*24*(sysdate-nvl(heuristic_time,fail_time)), global_commit#, type#   from pending_trans$  where session_vector != '00000000'||CURSOR|CURSOR|10080|1|1|0|0
|select local_tran_id, global_tran_fmt, global_oracle_id, global_foreign_id,        state, status, heuristic_dflt,        session_vector, reco_vector, 3600*24*(sysdate-reco_time),        3600*24*(sysdate-nvl(heuristic_time,fail_time)), global_commit#, type#   from pending_trans$  where session_vector != '00000000'||CURSOR|CURSOR|1732|1|0|0|0
|select location_name from loc$||CURSOR|CURSOR|3592|1|1|0|0
|select location_name from loc$||CURSOR|CURSOR|1448|1|0|0|0
|select max(procedure#) from procedurec$ where obj#=:1||CURSOR|CURSOR|4952|1|4|0|0
|select max(procedure#) from procedurec$ where obj#=:1||CURSOR|CURSOR|1471|1|0|0|0
|select max(procedure#) from procedurejava$ where obj#=:1||CURSOR|CURSOR|5052|1|4|0|0
|select max(procedure#) from procedurejava$ where obj#=:1||CURSOR|CURSOR|1410|1|0|0|0
|select metadata from kopm$  where name='DB_FDO'||CURSOR|CURSOR|5180|1|3|0|0
|select metadata from kopm$  where name='DB_FDO'||CURSOR|CURSOR|1465|1|0|0|0
|select migrated from MIGRATE$||CURSOR|CURSOR|4052|1|1|0|0
|select migrated from MIGRATE$||CURSOR|CURSOR|1731|1|0|0|0
|select name,file#,block#,status$,user#,undosqn,xactsqn,scnbas,scnwrp,DECODE(inst#,0,NULL,inst#),ts#,spare1 from undo$ where us#=:1||CURSOR|NOT LOADED|0|1|11|0|0
|select name,file#,block#,status$,user#,undosqn,xactsqn,scnbas,scnwrp,DECODE(inst#,0,NULL,inst#),ts#,spare1 from undo$ where us#=:1||CURSOR|CURSOR|1440|1|0|0|0
|select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$ where obj#=:1 order by intcol#||CURSOR|CURSOR|14968|2|98|0|0
|select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$ where obj#=:1 order by intcol#||CURSOR|CURSOR|1766|1|0|0|0
|select name,online$,contents$,undofile#,undoblock#,blocksize,dflmaxext,dflinit,dflincr,dflextpct,dflminext, dflminlen, owner#,scnwrp,scnbas, NVL(pitrscnwrp, 0), NVL(pitrscnbas, 0), dflogging, bitmapped, inc#, flags, plugged, NVL(spare1,0), NVL(spare2,0) from ts$ where ts#=:1||CURSOR|CURSOR|12500|2|6|0|0
|select name,online$,contents$,undofile#,undoblock#,blocksize,dflmaxext,dflinit,dflincr,dflextpct,dflminext, dflminlen, owner#,scnwrp,scnbas, NVL(pitrscnwrp, 0), NVL(pitrscnbas, 0), dflogging, bitmapped, inc#, flags, plugged, NVL(spare1,0), NVL(spare2,0) from ts$ where ts#=:1||CURSOR|CURSOR|2041|1|0|0|0
|select name,password,datats#,tempts#,type#,defrole,resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass) from user$ where user#=:1||CURSOR|CURSOR|9404|1|13|0|0
|select name,password,datats#,tempts#,type#,defrole,resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass) from user$ where user#=:1||CURSOR|CURSOR|1607|1|0|0|0
|select node,owner,name from syn$ where obj#=:1||CURSOR|CURSOR|5816|1|25|0|0
|select node,owner,name from syn$ where obj#=:1||CURSOR|CURSOR|1464|1|0|0|0
|select null from obj$ where obj#=:1 and type#=:2 and obj# not in (select p_obj# from dependency$ where p_obj# = obj$.obj#)||CURSOR|CURSOR|14980|1|0|0|0
|select null from obj$ where obj#=:1 and type#=:2 and obj# not in (select p_obj# from dependency$ where p_obj# = obj$.obj#)||CURSOR|CURSOR|1540|1|0|0|0
|select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1||CURSOR|CURSOR|8252|2|100|0|0
|select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1||CURSOR|CURSOR|1534|1|0|0|0
|select o.owner#,o.obj#,decode(o.linkname,null, decode(u.name,null,'SYS',u.name),o.remoteowner), o.name,o.linkname,o.namespace,o.subname from user$ u, obj$ o where u.user#(+)=o.owner# and o.type#=:1 and not exists (select p_obj# from dependency$ where p_obj# = o.obj#)||CURSOR|CURSOR|14256|1|1|0|0
|select o.owner#,o.obj#,decode(o.linkname,null, decode(u.name,null,'SYS',u.name),o.remoteowner), o.name,o.linkname,o.namespace,o.subname from user$ u, obj$ o where u.user#(+)=o.owner# and o.type#=:1 and not exists (select p_obj# from dependency$ where p_obj# = o.obj#)||CURSOR|CURSOR|1685|1|0|0|0
|select obj# from oid$ where user#=:1 and oid$=:2||CURSOR|CURSOR|5760|1|2|0|0
|select obj# from oid$ where user#=:1 and oid$=:2||CURSOR|CURSOR|1466|1|0|0|0
|select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null||CURSOR|CURSOR|10800|2|228|0|0
|select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null||CURSOR|CURSOR|1984|1|0|0|0
|select order#,columns,types from access$ where d_obj#=:1||CURSOR|CURSOR|6012|2|60|0|0
|select order#,columns,types from access$ where d_obj#=:1||CURSOR|CURSOR|1474|1|0|0|0
|select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, d_owner#, nvl(property,0),subname from dependency$,obj$ where d_obj#=:1 and p_obj#=obj#(+) order by order#||CURSOR|CURSOR|11960|2|60|0|0
|select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, d_owner#, nvl(property,0),subname from dependency$,obj$ where d_obj#=:1 and p_obj#=obj#(+) order by order#||CURSOR|CURSOR|1834|1|0|0|0
|select ownername,classname,methodname,signature,flags from procedurejava$ where obj#=:1 and procedure#=:2 order by procedure#||CURSOR|CURSOR|10564|1|0|0|0
|select ownername,classname,methodname,signature,flags from procedurejava$ where obj#=:1 and procedure#=:2 order by procedure#||CURSOR|CURSOR|1543|1|0|0|0
|select p.value$, lengthb(p.value$) from sys.props$ p   where p.name = 'BACK_END_DB'||CURSOR|CURSOR|4640|1|1|0|0
|select p.value$, lengthb(p.value$) from sys.props$ p   where p.name = 'BACK_END_DB'||CURSOR|CURSOR|1501|1|0|0|0
|select parsing_user_id, command_type,        disk_reads, buffer_gets, executions, sql_text from v$sqlarea where disk_reads > 100000 order by disk_reads||CURSOR|CURSOR|46888|1|1|0|0
|select parsing_user_id, command_type,        disk_reads, buffer_gets, executions, sql_text from v$sqlarea where disk_reads > 100000 order by disk_reads||CURSOR|CURSOR|1669|1|0|0|0
|select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags from partobj$ where obj# = :1||CURSOR|CURSOR|12080|1|1|0|0
|select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags from partobj$ where obj# = :1||CURSOR|CURSOR|1820|1|0|0|0
|select pool_size fro||CURSOR|NOT LOADED|0|1|0|0|0
|select pool_size fro||CURSOR|CURSOR|1690|1|0|0|0
|select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1||CURSOR|CURSOR|7132|2|103|0|0
|select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1||CURSOR|CURSOR|1485|1|0|0|0
|select position#,sequence#,level#,argument,type#,charsetid,charsetform,properties,nvl(length, 0), nvl(precision#, 0),nvl(scale, 0),nvl(radix, 0), type_owner,type_name,type_subname,type_linkname,pls_type from argument$ where obj#=:1 and procedure#=:2 order by sequence# desc||CURSOR|CURSOR|11616|1|33|0|0
|select position#,sequence#,level#,argument,type#,charsetid,charsetform,properties,nvl(length, 0), nvl(precision#, 0),nvl(scale, 0),nvl(radix, 0), type_owner,type_name,type_subname,type_linkname,pls_type from argument$ where obj#=:1 and procedure#=:2 order by sequence# desc||CURSOR|CURSOR|1691|1|0|0|0
|select privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with (grantee#=:1 or grantee#=1) and privilege#>0||CURSOR|CURSOR|11028|1|12|0|0
|select privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with (grantee#=:1 or grantee#=1) and privilege#>0||CURSOR|CURSOR|1565|1|0|0|0
|select procedure#,entrypoint# from procedurec$ where obj#=:1 order by procedure#||CURSOR|CURSOR|5736|1|2|0|0
|select procedure#,entrypoint# from procedurec$ where obj#=:1 order by procedure#||CURSOR|CURSOR|1830|1|0|0|0
|select procedure#,ownerlength,classlength,methodlength,siglength, flagslength,cookiesize from procedurejava$ where obj#=:1 order by procedure#||CURSOR|CURSOR|7292|1|2|0|0
|select procedure#,ownerlength,classlength,methodlength,siglength, flagslength,cookiesize from procedurejava$ where obj#=:1 order by procedure#||CURSOR|CURSOR|1560|1|0|0|0
|select procedure#,procedurename,properties,itypeobj# from procedureinfo$ where obj#=:1 order by procedurename desc, overload# desc||CURSOR|CURSOR|7452|1|2|0|0
|select procedure#,procedurename,properties,itypeobj# from procedureinfo$ where obj#=:1 order by procedurename desc, overload# desc||CURSOR|CURSOR|1548|1|0|0|0
|select procedure#,procedurename,properties,itypeobj# from procedureinfo$ where obj#=:1 order by procedurename desc, overload# desc||CURSOR|CURSOR|6720|1|2|0|0
|select pval2 from sys.aux_stats$ where sname = 'SYSSTATS_INFO' and pname = 'STATUS'||CURSOR|CURSOR|5340|1|1|0|0
|select pval2 from sys.aux_stats$ where sname = 'SYSSTATS_INFO' and pname = 'STATUS'||CURSOR|CURSOR|1833|1|0|0|0
|select q.eventid from system.aq$_queues q ||CURSOR|CURSOR|4660|1|1|0|0
|select q.eventid from system.aq$_queues q ||CURSOR|CURSOR|1460|1|0|0|0
|select q.eventid, s.destination, q.name, t.schema, s.disabled from system.aq$_queues q, sys.aq$_schedules s, system.aq$_queue_tables t,   sys.aq$_queue_table_affinities aft where q.oid = s.oid and q.table_objno = t.objno and aft.table_objno = t.objno and bitand(q.properties, 512) = 512 and aft.owner_instance = :1||CURSOR|CURSOR|14928|1|1|0|0
|select q.eventid, s.destination, q.name, t.schema, s.disabled from system.aq$_queues q, sys.aq$_schedules s, system.aq$_queue_tables t,   sys.aq$_queue_table_affinities aft where q.oid = s.oid and q.table_objno = t.objno and aft.table_objno = t.objno and bitand(q.properties, 512) = 512 and aft.owner_instance = :1||CURSOR|CURSOR|1732|1|0|0|0
|select q_name, state, delay, expiration, rowid, msgid,    dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,   priority, exception_qschema, exception_queue, retry_count, corrid,     time_manager_info   from SYS.AQ_EVENT_TABLE   where time_manager_info <= :1 and state != :2   for update skip locked||CURSOR|CURSOR|13072|1|38|0|0
|select q_name, state, delay, expiration, rowid, msgid,    dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,   priority, exception_qschema, exception_queue, retry_count, corrid,     time_manager_info   from SYS.AQ_EVENT_TABLE   where time_manager_info <= :1 and state != :2   for update skip locked||CURSOR|CURSOR|2030|1|0|0|0
|select q_name, state, delay, expiration, rowid, msgid,    dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,   priority, exception_qschema, exception_queue, retry_count, corrid,     time_manager_info   from SYSTEM.DEF$_AQCALL   where time_manager_info <= :1 and state != :2   for update skip locked||CURSOR|CURSOR|12324|1|38|0|0
|select q_name, state, delay, expiration, rowid, msgid,    dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,   priority, exception_qschema, exception_queue, retry_count, corrid,     time_manager_info   from SYSTEM.DEF$_AQCALL   where time_manager_info <= :1 and state != :2   for update skip locked||CURSOR|CURSOR|1982|1|0|0|0
|select q_name, state, delay, expiration, rowid, msgid,    dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,   priority, exception_qschema, exception_queue, retry_count, corrid,     time_manager_info   from SYSTEM.DEF$_AQERROR   where time_manager_info <= :1 and state != :2   for update skip locked||CURSOR|CURSOR|11852|1|38|0|0
|select q_name, state, delay, expiration, rowid, msgid,    dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,   priority, exception_qschema, exception_queue, retry_count, corrid,     time_manager_info   from SYSTEM.DEF$_AQERROR   where time_manager_info <= :1 and state != :2   for update skip locked||CURSOR|CURSOR|2067|1|0|0|0
|select q_name, state, delay, expiration, rowid, msgid,   dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,   priority, exception_qschema, exception_queue, retry_count, corrid,   time_manager_info, sender_name, sender_address, sender_protocol   from SYS.AQ_SRVNTFN_TABLE   where time_manager_info <= :1 and state != :2   for update skip locked||CURSOR|CURSOR|13876|1|38|0|0
|select q_name, state, delay, expiration, rowid, msgid,   dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,   priority, exception_qschema, exception_queue, retry_count, corrid,   time_manager_info, sender_name, sender_address, sender_protocol   from SYS.AQ_SRVNTFN_TABLE   where time_manager_info <= :1 and state != :2   for update skip locked||CURSOR|CURSOR|2139|1|0|0|0
|select rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,nvl(degree,1), nvl(instances,1) from tab$ where obj# = :1||CURSOR|NOT LOADED|0|1|19|0|0
|select rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,nvl(degree,1), nvl(instances,1) from tab$ where obj# = :1||CURSOR|CURSOR|1692|1|0|0|0
|select s.owner ,s.segment_type ,s.tablespace_name ,count(*) cntsegs ,avg(s.extents) avgexts ,max(s.extents) maxexts ,sum(s.blocks) sumblks ,sum(s.bytes/1048576) sumbyts from dba_segments s where owner not in ('SYS', 'SYSTEM', 'OUTLN') group by s.owner,s.segment_type,s.tablespace_name ||CURSOR|CURSOR|167052|1|1|0|0
|select s.owner ,s.segment_type ,s.tablespace_name ,count(*) cntsegs ,avg(s.extents) avgexts ,max(s.extents) maxexts ,sum(s.blocks) sumblks ,sum(s.bytes/1048576) sumbyts from dba_segments s where owner not in ('SYS', 'SYSTEM', 'OUTLN') group by s.owner,s.segment_type,s.tablespace_name ||CURSOR|CURSOR|1703|1|0|0|0
|select substr(time, ||CURSOR|NOT LOADED|0|1|0|0|0
|select substr(time, ||CURSOR|CURSOR|3109|1|0|0|0
|select sum(getmisses)/sum(gets)*100 pool_size from v$rowcache||CURSOR|CURSOR|20072|1|2|0|0
|select sum(getmisses)/sum(gets)*100 pool_size from v$rowcache||CURSOR|CURSOR|1479|1|0|0|0
|select t.name,  (select owner_instance from sys.aq$_queue_table_affinities   where table_objno = t.objno)  from system.aq$_queue_tables t where t.name = :1 and t.schema = :2 for update skip locked||CURSOR|CURSOR|8964|1|152|0|0
|select t.name,  (select owner_instance from sys.aq$_queue_table_affinities   where table_objno = t.objno)  from system.aq$_queue_tables t where t.name = :1 and t.schema = :2 for update skip locked||CURSOR|CURSOR|1614|1|0|0|0
|select t.schema, t.name, t.flags, q.name from system.aq$_queue_tables t, sys.aq$_queue_table_affinities aft,      system.aq$_queues q where aft.table_objno = t.objno and aft.owner_instance = :1 and        q.table_objno = t.objno and q.usage = 0 and       bitand(t.flags, 4+16+32+64+128+256) = 0 for update of t.name, aft.table_objno skip locked||CURSOR|CURSOR|13960|1|38|0|0
|select t.schema, t.name, t.flags, q.name from system.aq$_queue_tables t, sys.aq$_queue_table_affinities aft,      system.aq$_queues q where aft.table_objno = t.objno and aft.owner_instance = :1 and        q.table_objno = t.objno and q.usage = 0 and       bitand(t.flags, 4+16+32+64+128+256) = 0 for update of t.name, aft.table_objno skip locked||CURSOR|CURSOR|2054|1|0|0|0
|select table_objno, primary_instance, secondary_instance, owner_instance from sys.aq$_queue_table_affinities a  where  a.owner_instance <> :1 and (a.primary_instance = :2 or a.secondary_instance = :3) and dbms_aqadm_syscalls.get_owner_instance(a.primary_instance,       a.secondary_instance,       a.owner_instance) = :4  order by table_objno for update of a.owner_instance||CURSOR|CURSOR|13964|1|1|0|0
|select table_objno, primary_instance, secondary_instance, owner_instance from sys.aq$_queue_table_affinities a  where  a.owner_instance <> :1 and (a.primary_instance = :2 or a.secondary_instance = :3) and dbms_aqadm_syscalls.get_owner_instance(a.primary_instance,       a.secondary_instance,       a.owner_instance) = :4  order by table_objno for update of a.owner_instance||CURSOR|CURSOR|1791|1|0|0|0
|select table_objno, primary_instance, secondary_instance, owner_instance from sys.aq$_queue_table_affinities a  where  a.owner_instance <> :1 and dbms_aqadm_syscalls.get_owner_instance(a.primary_instance,       a.secondary_instance,       a.owner_instance) = :2  order by table_objno for update of a.owner_instance skip locked||CURSOR|CURSOR|13180|1|1|0|0
|select table_objno, primary_instance, secondary_instance, owner_instance from sys.aq$_queue_table_affinities a  where  a.owner_instance <> :1 and dbms_aqadm_syscalls.get_owner_instance(a.primary_instance,       a.secondary_instance,       a.owner_instance) = :2  order by table_objno for update of a.owner_instance skip locked||CURSOR|CURSOR|1744|1|0|0|0
|select tc.type#,tc.intcol#,tc.position#,c.type#, c.length,c.scale,c.precision#,c.charsetid,c.charsetform from triggercol$ tc,col$ c ,trigger$ tr where tc.obj#=:1 and c.obj#=:2 and tc.intcol#=c.intcol# and tr.obj# = tc.obj# and (bitand(tr.property,32) != 32 or bitand(tc.type#,20) = 20) union select type#,intcol#,position#,69,0,0,0,0,0 from triggercol$ where obj#=:3 and intcol#=1001 union select tc.type#,tc.intcol#,tc.position#,121,0,0,0,0,0 from triggercol$ tc,trigger$ tr where tr.obj# = tc.obj# and bitand(tr.property,32) = 32 and tc.obj# = :4 and bitand(tc.type#,20) != 20||CURSOR|CURSOR|30372|1|2|0|0
|select tc.type#,tc.intcol#,tc.position#,c.type#, c.length,c.scale,c.precision#,c.charsetid,c.charsetform from triggercol$ tc,col$ c ,trigger$ tr where tc.obj#=:1 and c.obj#=:2 and tc.intcol#=c.intcol# and tr.obj# = tc.obj# and (bitand(tr.property,32) != 32 or bitand(tc.type#,20) = 20) union select type#,intcol#,position#,69,0,0,0,0,0 from triggercol$ where obj#=:3 and intcol#=1001 union select tc.type#,tc.intcol#,tc.position#,121,0,0,0,0,0 from triggercol$ tc,trigger$ tr where tr.obj# = tc.obj# and bitand(tr.property,32) = 32 and tc.obj# = :4 and bitand(tc.type#,20) != 20||CURSOR|CURSOR|2304|1|0|0|0
|select text from view$ where rowid=:1||CURSOR|CURSOR|5364|1|51|0|0
|select text from view$ where rowid=:1||CURSOR|CURSOR|1455|1|0|0|0
|select ts# from ts$ where name=:1||CURSOR|NOT LOADED|0|1|1|0|0
|select ts# from ts$ where name=:1||CURSOR|CURSOR|1451|1|0|0|0
|select ts#,file#,block#,cols,nvl(size$,-1),pctfree$,pctused$,initrans,maxtrans,hashkeys,func,extind,avgchn,nvl(degree,1),nvl(instances,1),nvl(flags,0) from clu$ where obj#=:1||CURSOR|CURSOR|10132|2|2|0|0
|select ts#,file#,block#,cols,nvl(size$,-1),pctfree$,pctused$,initrans,maxtrans,hashkeys,func,extind,avgchn,nvl(degree,1),nvl(instances,1),nvl(flags,0) from clu$ where obj#=:1||CURSOR|CURSOR|1892|1|0|0|0
|select ts#,file#,block#,nvl(bobj#,0),nvl(tab#,0),intcols,nvl(clucols,0),audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,analyzetime, samplesize,cols,property,nvl(degree,1),nvl(instances,1),avgspc_flb,flbcnt,kernelcols,nvl(trigflag, 0),nvl(spare1,0),nvl(spare2,0),spare4,spare6 from tab$ where obj#=:1||CURSOR|CURSOR|15732|2|67|0|0
|select ts#,file#,block#,nvl(bobj#,0),nvl(tab#,0),intcols,nvl(clucols,0),audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,analyzetime, samplesize,cols,property,nvl(degree,1),nvl(instances,1),avgspc_flb,flbcnt,kernelcols,nvl(trigflag, 0),nvl(spare1,0),nvl(spare2,0),spare4,spare6 from tab$ where obj#=:1||CURSOR|CURSOR|1761|1|0|0|0
|select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3||CURSOR|CURSOR|10420|2|53|0|0
|select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3||CURSOR|CURSOR|1492|1|0|0|0
|select u.name, o.name, t.spare1, t.pctfree$    from sys.obj$ o, sys.user$ u, sys.tab$ t    where  (bitand(t.trigflag, 1048576) = 1048576) and           o.obj#=t.obj# and o.owner# = u.user#||CURSOR|CURSOR|12356|1|1|0|0
|select u.name, o.name, t.spare1, t.pctfree$    from sys.obj$ o, sys.user$ u, sys.tab$ t    where  (bitand(t.trigflag, 1048576) = 1048576) and           o.obj#=t.obj# and o.owner# = u.user#||CURSOR|CURSOR|1498|1|0|0|0
|select u.name, o.name, trigger$.sys_evts, trigger$.type#  from   obj$ o, user$ u, trigger$  where (bitand(trigger$.property, 8) = 8)  and   (bitand(trigger$.property, 16) != 16)  and   trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj#||CURSOR|CURSOR|13088|1|1|0|0
|select u.name, o.name, trigger$.sys_evts, trigger$.type#  from   obj$ o, user$ u, trigger$  where (bitand(trigger$.property, 8) = 8)  and   (bitand(trigger$.property, 16) != 16)  and   trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj#||CURSOR|CURSOR|2008|1|0|0|0
|select u.name, o.name, trigger$.sys_evts, trigger$.type# from obj$ o,  user$ u, trigger$ where bitand(trigger$.property,16) = 16 and  trigger$.baseobject = :1  and trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj#||CURSOR|CURSOR|13576|1|1|0|0
|select u.name, o.name, trigger$.sys_evts, trigger$.type# from obj$ o,  user$ u, trigger$ where bitand(trigger$.property,16) = 16 and  trigger$.baseobject = :1  and trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj#||CURSOR|CURSOR|1643|1|0|0|0
|select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled  from obj$ o,user$ u,trigger$ t  where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user#  order by o.obj#||CURSOR|CURSOR|13448|1|1|0|0
|select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled  from obj$ o,user$ u,trigger$ t  where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user#  order by o.obj#||CURSOR|CURSOR|1593|1|0|0|0
|select unique a.schema, a.name from system.aq$_queues b, system.aq$_queue_tables a, sys.aq$_queue_table_affinities t  where a.objno = b.table_objno and t.table_objno = b.table_objno and bitand(b.properties, 512) = 512 and t.owner_instance = :1||CURSOR|CURSOR|11560|1|1|0|0
|select unique a.schema, a.name from system.aq$_queues b, system.aq$_queue_tables a, sys.aq$_queue_table_affinities t  where a.objno = b.table_objno and t.table_objno = b.table_objno and bitand(b.properties, 512) = 512 and t.owner_instance = :1||CURSOR|CURSOR|1589|1|0|0|0
|select user# from sys.user$ where name = 'OUTLN'||CURSOR|CURSOR|5364|1|1|0|0
|select user# from sys.user$ where name = 'OUTLN'||CURSOR|CURSOR|1262|1|0|0|0
|select user#,type# from user$ where name=:1||CURSOR|CURSOR|5968|2|2|0|0
|select user#,type# from user$ where name=:1||CURSOR|CURSOR|1461|1|0|0|0
|select value from gv$parameter where name = 'undo_retention'  and INST_ID <> :1||CURSOR|CURSOR|15092|1|1|0|0
|select value from gv$parameter where name = 'undo_retention'  and INST_ID <> :1||CURSOR|CURSOR|1829|1|0|0|0
|select value$ from props$ where name='DEFAULT_TEMP_TABLESPACE'||CURSOR|NOT LOADED|0|1|1|0|0
|select value$ from props$ where name='DEFAULT_TEMP_TABLESPACE'||CURSOR|CURSOR|1468|1|0|0|0
|select value$ from sys.props$ where name = :1||CURSOR|CURSOR|4484|2|21|0|0
|select value$ from sys.props$ where name = :1||CURSOR|CURSOR|4264|1|6|0|0
|select value$ from sys.props$ where name = :1||CURSOR|CURSOR|1463|1|0|0|0
|select value$ from sys.props$ where name = :1||CURSOR|CURSOR|4328|1|3|0|0
|table_1_0_141_0_0_0||CURSOR|CURSOR|5900|1|0|1|1
|table_1_0_141_0_0_0||CURSOR|CURSOR|1437|1|0|1|0
|update lob$ set retention = :1 where retention >= 0||CURSOR|CURSOR|6100|1|1|0|0
|update lob$ set retention = :1 where retention >= 0||CURSOR|CURSOR|1469|1|0|0|0
|update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1||CURSOR|CURSOR|9460|1|1|0|0
|update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1||CURSOR|CURSOR|1547|1|0|0|0
|update sys.col_usage$ set   equality_preds    = equality_preds    + decode(bitand(:flag,1),0,0,1),   equijoin_preds    = equijoin_preds    + decode(bitand(:flag,2),0,0,1),   nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0,1),   range_preds       = range_preds       + decode(bitand(:flag,8),0,0,1),   like_preds        = like_preds        + decode(bitand(:flag,16),0,0,1),   null_preds        = null_preds        + decode(bitand(:flag,32),0,0,1),  timestamp = :time where obj# = :objn and intcol# = :coln||CURSOR|CURSOR|13132|1|35|0|0
|update sys.col_usage$ set   equality_preds    = equality_preds    + decode(bitand(:flag,1),0,0,1),   equijoin_preds    = equijoin_preds    + decode(bitand(:flag,2),0,0,1),   nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0,1),   range_preds       = range_preds       + decode(bitand(:flag,8),0,0,1),   like_preds        = like_preds        + decode(bitand(:flag,16),0,0,1),   null_preds        = null_preds        + decode(bitand(:flag,32),0,0,1),  timestamp = :time where obj# = :objn and intcol# = :coln||CURSOR|CURSOR|1941|1|0|0|0
|update undo$ set name=:2,file#=:3,block#=:4,status$=:5,user#=:6,undosqn=:7,xactsqn=:8,scnbas=:9,scnwrp=:10,inst#=:11,ts#=:12,spare1=:13 where us#=:1||CURSOR|NOT LOADED|0|1|30|0|0
|update undo$ set name=:2,file#=:3,block#=:4,status$=:5,user#=:6,undosqn=:7,xactsqn=:8,scnbas=:9,scnwrp=:10,inst#=:11,ts#=:12,spare1=:13 where us#=:1||CURSOR|CURSOR|1566|1|0|0|0

