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

OWNER NAME DB_LINK NAMESPACE TYPE SHARABLE_MEM LOADS EXECUTIONS LOCKS PINS
PUBLIC DBA_SEGMENTS null TABLE/PROCEDURE SYNONYM 875 1 0 0 0
PUBLIC DBMS_APPLICATION_INFO null TABLE/PROCEDURE SYNONYM 7696 1 0 0 0
PUBLIC DBMS_OUTPUT null TABLE/PROCEDURE SYNONYM 7674 1 0 0 0
PUBLIC DUAL null TABLE/PROCEDURE SYNONYM 867 1 0 0 0
PUBLIC GLOBAL_NAME null TABLE/PROCEDURE SYNONYM 874 1 0 0 0
PUBLIC NLS_INSTANCE_PARAMETERS null TABLE/PROCEDURE SYNONYM 886 1 0 0 0
PUBLIC POOL_SIZE null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
PUBLIC SYS null TABLE/PROCEDURE NON-EXISTENT 866 1 0 0 0
PUBLIC TIME null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
PUBLIC V$ACCESS null TABLE/PROCEDURE SYNONYM 871 1 0 0 0
PUBLIC V$DATABASE null TABLE/PROCEDURE SYNONYM 7685 1 0 0 0
PUBLIC V$DATAFILE null TABLE/PROCEDURE SYNONYM 873 1 0 0 0
PUBLIC V$DBFILE null TABLE/PROCEDURE SYNONYM 7683 1 0 0 0
PUBLIC V$DB_OBJECT_CACHE null TABLE/PROCEDURE SYNONYM 880 1 0 0 0
PUBLIC V$FILESTAT null TABLE/PROCEDURE SYNONYM 873 1 0 0 0
PUBLIC V$INSTANCE null TABLE/PROCEDURE SYNONYM 873 1 0 0 0
PUBLIC V$LIBRARYCACHE null TABLE/PROCEDURE SYNONYM 877 1 0 0 0
PUBLIC V$LOG null TABLE/PROCEDURE SYNONYM 868 1 0 0 0
PUBLIC V$LOGFILE null TABLE/PROCEDURE SYNONYM 872 1 0 0 0
PUBLIC V$LOGHIST null TABLE/PROCEDURE SYNONYM 872 1 0 0 0
PUBLIC V$ROLLNAME null TABLE/PROCEDURE SYNONYM 873 1 0 0 0
PUBLIC V$ROLLSTAT null TABLE/PROCEDURE SYNONYM 873 1 0 0 0
PUBLIC V$ROWCACHE null TABLE/PROCEDURE SYNONYM 873 1 0 0 0
PUBLIC V$SESSION null TABLE/PROCEDURE SYNONYM 872 1 0 0 0
PUBLIC V$SQLAREA null TABLE/PROCEDURE SYNONYM 872 1 0 0 0
PUBLIC V$SYSSTAT null TABLE/PROCEDURE SYNONYM 872 1 0 0 0
PUBLIC V$VERSION null TABLE/PROCEDURE SYNONYM 872 1 0 0 0
PUBLIC V$WAITSTAT null TABLE/PROCEDURE SYNONYM 873 1 0 0 0
SYS ACCESS$ null TABLE/PROCEDURE TABLE 1431 1 0 0 0
SYS ALL_OBJECTS null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS AQ$_AGENT null TABLE/PROCEDURE TYPE 869 1 0 0 0
SYS AQ$_AQ_EVENT_TABLE_I null INDEX INDEX 560 1 0 0 0
SYS AQ$_AQ_SRVNTFN_TABLE_I null INDEX INDEX 562 1 0 0 0
SYS AQ$_EVENT_MESSAGE null TABLE/PROCEDURE TYPE 1437 1 0 0 0
SYS AQ$_MESSAGE_TYPES null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS AQ$_NOTIFY_MSG null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS AQ$_PENDING_MESSAGES null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS AQ$_PROPAGATION_STATUS null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS AQ$_QUEUE_TABLE_AFFINITIES null TABLE/PROCEDURE TABLE 1134 1 0 0 0
SYS AQ$_RECIPIENTS null TABLE/PROCEDURE TYPE 1278 1 0 0 0
SYS AQ$_SCHEDULES null TABLE/PROCEDURE TABLE 1433 1 0 0 0
SYS AQ$_SRVNTFN_MESSAGE null TABLE/PROCEDURE TYPE 879 1 0 0 0
SYS AQ$_SUBSCRIBERS null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS AQ_EVENT_TABLE null TABLE/PROCEDURE TABLE 2554 1 0 0 0
SYS AQ_SRVNTFN_TABLE null TABLE/PROCEDURE TABLE 1996 1 0 0 0
SYS ARGUMENT$ null TABLE/PROCEDURE TABLE 1429 1 0 0 0
SYS ATTRCOL$ null TABLE/PROCEDURE TABLE 1428 1 0 0 0
SYS ATTRIBUTE$ null TABLE/PROCEDURE TABLE 1266 1 0 0 0
SYS AUDSES$ null TABLE/PROCEDURE SEQUENCE 867 1 0 0 0
SYS AUX_STATS$ null TABLE/PROCEDURE TABLE 1430 1 0 0 0
SYS BOOTSTRAP$ null TABLE/PROCEDURE TABLE 1430 1 0 0 0
SYS CCOL$ null TABLE/PROCEDURE TABLE 1681 1 0 0 0
SYS CDEF$ null TABLE/PROCEDURE TABLE 1653 1 0 0 0
SYS CLU$ null TABLE/PROCEDURE TABLE 1336 1 0 0 0
SYS COL$ null TABLE/PROCEDURE TABLE 1984 1 0 0 0
SYS COLTYPE$ null TABLE/PROCEDURE TABLE 1428 1 0 0 0
SYS COL_USAGE$ null TABLE/PROCEDURE TABLE 1430 1 0 0 0
SYS CON$ null TABLE/PROCEDURE TABLE 1424 1 0 0 0
SYS C_COBJ# null CLUSTER CLUSTER 1391 1 0 0 0
SYS C_FILE#_BLOCK# null CLUSTER CLUSTER 1406 1 0 0 0
SYS C_OBJ# null CLUSTER CLUSTER 1426 1 0 0 0
SYS C_OBJ#_INTCOL# null CLUSTER CLUSTER 1434 1 0 0 0
SYS C_TS# null CLUSTER CLUSTER 1425 1 0 0 0
SYS C_USER# null CLUSTER CLUSTER 1235 1 0 0 0
SYS DATABASE null PUB_SUB PUB_SUB 1328 1 0 1 0
SYS DBA_ANALYZE_OBJECTS null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBA_DATA_FILES null TABLE/PROCEDURE VIEW 2718 1 0 0 0
SYS DBA_FREE_SPACE null TABLE/PROCEDURE VIEW 2718 1 0 0 0
SYS DBA_IND_PARTITIONS null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBA_JOBS null TABLE/PROCEDURE VIEW 1868 1 0 0 0
SYS DBA_OBJECTS null TABLE/PROCEDURE VIEW 2551 1 0 0 0
SYS DBA_SEGMENTS null TABLE/PROCEDURE VIEW 1696 1 0 0 0
SYS DBA_TAB_PARTITIONS null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_APPLICATION_INFO null TABLE/PROCEDURE PACKAGE 12465 1 0 0 0
SYS DBMS_APPLICATION_INFO null BODY PACKAGE BODY 3041 1 1 0 0
SYS DBMS_AQ null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_AQADM null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_AQADM_LIB null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_AQADM_SYS null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_AQADM_SYSCALLS null TABLE/PROCEDURE PACKAGE 31911 1 0 0 0
SYS DBMS_AQADM_SYSCALLS null BODY PACKAGE BODY 7259 1 9 0 0
SYS DBMS_AQ_LIB null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_DDL null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_IJOB null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_JOB null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_LOB null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_LOCK null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_OUTPUT null TABLE/PROCEDURE PACKAGE 13011 1 0 0 0
SYS DBMS_OUTPUT null BODY PACKAGE BODY 8091 1 76 0 0
SYS DBMS_PRVTAQIP null TABLE/PROCEDURE PACKAGE 39609 1 0 0 0
SYS DBMS_PRVTAQIP null BODY PACKAGE BODY 72285 1 1 0 0
SYS DBMS_SPACE_ADMIN null TABLE/PROCEDURE PACKAGE 31960 1 0 0 0
SYS DBMS_SPACE_ADMIN null BODY PACKAGE BODY 7564 1 20 0 0
SYS DBMS_SPACE_ADMIN_LIB null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_SQL null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_STANDARD null TABLE/PROCEDURE PACKAGE 23633 1 0 0 0
SYS DBMS_SYSTEM null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_SYS_ERROR null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_SYS_SQL null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_TRANSACTION null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS DBMS_UTILITY null TABLE/PROCEDURE PACKAGE 5580 1 0 0 0
SYS DBMS_UTILITY null BODY PACKAGE BODY 29648 1 1 0 0
SYS DEPENDENCY$ null TABLE/PROCEDURE TABLE 1431 1 0 0 0
SYS DUAL null TABLE/PROCEDURE TABLE 1424 1 0 0 0
SYS ERROR$ null TABLE/PROCEDURE TABLE 1426 1 0 0 0
SYS FET$ null TABLE/PROCEDURE TABLE 9040 1 0 0 0
SYS FILE$ null TABLE/PROCEDURE TABLE 10825 1 0 0 0
SYS GET_DEP_DT1 null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS GET_DEP_DT2 null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS GLOBAL_NAME null TABLE/PROCEDURE VIEW 1991 1 0 0 0
SYS GV$ACCESS null TABLE/PROCEDURE VIEW 549 1 0 0 0
SYS GV$DATABASE null TABLE/PROCEDURE VIEW 551 1 0 0 0
SYS GV$DATAFILE null TABLE/PROCEDURE VIEW 551 1 0 0 0
SYS GV$DBFILE null TABLE/PROCEDURE VIEW 549 1 0 0 0
SYS GV$DB_OBJECT_CACHE null TABLE/PROCEDURE VIEW 558 1 0 0 0
SYS GV$FILESTAT null TABLE/PROCEDURE VIEW 551 1 0 0 0
SYS GV$INSTANCE null TABLE/PROCEDURE VIEW 551 1 0 0 0
SYS GV$LIBRARYCACHE null TABLE/PROCEDURE VIEW 555 1 0 0 0
SYS GV$LOG null TABLE/PROCEDURE VIEW 546 1 0 0 0
SYS GV$LOGFILE null TABLE/PROCEDURE VIEW 550 1 0 0 0
SYS GV$LOGHIST null TABLE/PROCEDURE VIEW 550 1 0 0 0
SYS GV$LOG_HISTORY null TABLE/PROCEDURE VIEW 634 1 0 0 0
SYS GV$PARAMETER null TABLE/PROCEDURE VIEW 552 1 0 0 0
SYS GV$ROLLSTAT null TABLE/PROCEDURE VIEW 551 1 0 0 0
SYS GV$ROWCACHE null TABLE/PROCEDURE VIEW 551 1 0 0 0
SYS GV$SESSION null TABLE/PROCEDURE VIEW 550 1 0 0 0
SYS GV$SQLAREA null TABLE/PROCEDURE VIEW 550 1 0 0 0
SYS GV$SYSSTAT null TABLE/PROCEDURE VIEW 550 1 0 0 0
SYS GV$VERSION null TABLE/PROCEDURE VIEW 550 1 0 0 0
SYS GV$WAITSTAT null TABLE/PROCEDURE VIEW 551 1 0 0 0
SYS HISTGRM$ null TABLE/PROCEDURE TABLE 1328 1 0 0 0
SYS HIST_HEAD$ null TABLE/PROCEDURE TABLE 1430 1 0 0 0
SYS ICOL$ null TABLE/PROCEDURE TABLE 1425 1 0 0 0
SYS IDGEN1$ null TABLE/PROCEDURE SEQUENCE 867 1 0 0 0
SYS IDL_CHAR$ null TABLE/PROCEDURE TABLE 1429 1 0 0 0
SYS IDL_SB4$ null TABLE/PROCEDURE TABLE 1428 1 0 0 0
SYS IDL_UB1$ null TABLE/PROCEDURE TABLE 1428 1 0 0 0
SYS IDL_UB2$ null TABLE/PROCEDURE TABLE 1428 1 0 0 0
SYS ID_GENS$ null TABLE/PROCEDURE TABLE 1216 1 0 0 0
SYS IND$ null TABLE/PROCEDURE TABLE 1424 1 0 0 0
SYS INDCOMPART$ null TABLE/PROCEDURE TABLE 1355 1 0 0 0
SYS INDPART$ null TABLE/PROCEDURE TABLE 1352 1 0 0 0
SYS INDSUBPART$ null TABLE/PROCEDURE TABLE 1435 1 0 0 0
SYS IND_ONLINE$ null TABLE/PROCEDURE TABLE 1431 1 0 0 0
SYS I_CCOL1 null INDEX INDEX 675 1 0 0 0
SYS I_CCOL2 null INDEX INDEX 547 1 0 0 0
SYS I_CDEF1 null INDEX INDEX 547 1 0 0 0
SYS I_CDEF2 null INDEX INDEX 675 1 0 0 0
SYS I_CDEF3 null INDEX INDEX 547 1 0 0 0
SYS I_CDEF4 null INDEX INDEX 547 1 0 0 0
SYS I_COBJ# null INDEX INDEX 547 1 0 0 0
SYS I_COL1 null INDEX INDEX 546 1 0 0 0
SYS I_COL2 null INDEX INDEX 546 1 0 0 0
SYS I_COL3 null INDEX INDEX 546 1 0 0 0
SYS I_CON1 null INDEX INDEX 674 1 0 0 0
SYS I_CON2 null INDEX INDEX 546 1 0 0 0
SYS I_FILE#_BLOCK# null INDEX INDEX 554 1 0 0 0
SYS I_FILE1 null INDEX INDEX 675 1 0 0 0
SYS I_FILE2 null INDEX INDEX 547 1 0 0 0
SYS I_HH_OBJ#_COL# null INDEX INDEX 698 1 0 0 0
SYS I_HH_OBJ#_INTCOL# null INDEX INDEX 721 1 0 0 0
SYS I_H_OBJ#_COL# null INDEX INDEX 873 1 0 0 0
SYS I_ICOL1 null INDEX INDEX 547 1 0 0 0
SYS I_IND1 null INDEX INDEX 546 1 0 0 0
SYS I_OBJ# null INDEX INDEX 546 1 0 0 0
SYS I_OBJ#_INTCOL# null INDEX INDEX 874 1 0 0 0
SYS I_OBJ1 null INDEX INDEX 546 1 0 0 0
SYS I_OBJ2 null INDEX INDEX 546 1 0 0 0
SYS I_OBJ3 null INDEX INDEX 674 1 0 0 0
SYS I_PROXY_DATA$ null INDEX INDEX 553 1 0 0 0
SYS I_PROXY_ROLE_DATA$_1 null INDEX INDEX 560 1 0 0 0
SYS I_PROXY_ROLE_DATA$_2 null INDEX INDEX 568 1 0 0 0
SYS I_TAB1 null INDEX INDEX 546 1 0 0 0
SYS I_TS# null INDEX INDEX 545 1 0 0 0
SYS I_TS1 null INDEX INDEX 545 1 0 0 0
SYS I_UNDO1 null INDEX INDEX 547 1 0 0 0
SYS I_UNDO2 null INDEX INDEX 675 1 0 0 0
SYS I_USER# null INDEX INDEX 547 1 0 0 0
SYS I_USER1 null INDEX INDEX 675 1 0 0 0
SYS JOB$ null TABLE/PROCEDURE TABLE 1120 1 0 0 0
SYS KOPM$ null TABLE/PROCEDURE TABLE 1425 1 0 0 0
SYS KOTTD$ null TABLE/PROCEDURE TABLE 2070 1 0 0 0
SYS LINK$ null TABLE/PROCEDURE TABLE 1425 1 0 0 0
SYS LOB$ null TABLE/PROCEDURE TABLE 1424 1 0 0 0
SYS LOBFRAG$ null TABLE/PROCEDURE TABLE 1412 1 0 0 0
SYS LOC$ null TABLE/PROCEDURE TABLE 1424 1 0 0 0
SYS LOGOFF_PROC null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS LOGON_PROC null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS LT null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS MIGRATE$ null TABLE/PROCEDURE TABLE 1428 1 0 0 0
SYS NLS_INSTANCE_PARAMETERS null TABLE/PROCEDURE VIEW 1983 1 0 0 0
SYS NTAB$ null TABLE/PROCEDURE TABLE 1425 1 0 0 0
SYS OBJ$ null TABLE/PROCEDURE TABLE 1424 1 0 0 0
SYS OBJAUTH$ null TABLE/PROCEDURE TABLE 1428 1 0 0 0
SYS OBJECT_USAGE null TABLE/PROCEDURE TABLE 1432 1 0 0 0
SYS OID$ null TABLE/PROCEDURE TABLE 1424 1 0 0 0
SYS OPQTYPE$ null TABLE/PROCEDURE TABLE 1428 1 0 0 0
SYS PARTOBJ$ null TABLE/PROCEDURE TABLE 1428 1 0 0 0
SYS PENDING_TRANS$ null TABLE/PROCEDURE TABLE 1434 1 0 0 0
SYS PROCEDURE$ null TABLE/PROCEDURE TABLE 1390 1 0 0 0
SYS PROCEDUREC$ null TABLE/PROCEDURE TABLE 1431 1 0 0 0
SYS PROCEDUREINFO$ null TABLE/PROCEDURE TABLE 1434 1 0 0 0
SYS PROCEDUREJAVA$ null TABLE/PROCEDURE TABLE 1434 1 0 0 0
SYS PROFILE$ null TABLE/PROCEDURE TABLE 1428 1 0 0 0
SYS PROPS$ null TABLE/PROCEDURE TABLE 1426 1 0 0 0
SYS PROXY_DATA$ null TABLE/PROCEDURE TABLE 1431 1 0 0 0
SYS PROXY_ROLE_DATA$ null TABLE/PROCEDURE TABLE 1620 1 0 0 0
SYS REFCON$ null TABLE/PROCEDURE TABLE 1427 1 0 0 0
SYS S$KCBWAIT null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KCCDI null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KCCFE null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KCCFN null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KCCLE null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KCCLH null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KCCRT null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KCFIO null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KCVFH null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KGLCURSOR null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KGLDP null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KGLLK null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KGLOB null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KGLST null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KQRST null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KSPPCV null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KSPPI null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KSUSE null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KSUSGSTA null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KSUXSINST null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KTFBFE null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KTFBHC null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KTURD null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$KVIT null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$QUIESCE null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS S$VERSION null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYS SEG$ null TABLE/PROCEDURE TABLE 1424 1 0 0 0
SYS SEQ$ null TABLE/PROCEDURE TABLE 1424 1 0 0 0
SYS SMON_SCN_TIME null TABLE/PROCEDURE TABLE 1433 1 0 0 0
SYS SMON_SCN_TO_TIME null CLUSTER CLUSTER 1436 1 0 0 0
SYS STANDARD null TABLE/PROCEDURE PACKAGE 377228 1 0 0 0
SYS STANDARD null BODY PACKAGE BODY 26312 1 34 0 0
SYS STREAMS$_APPLY_PROCESS null TABLE/PROCEDURE TABLE 1442 1 0 0 0
SYS STREAMS$_CAPTURE_PROCESS null TABLE/PROCEDURE TABLE 1444 1 0 0 0
SYS SUBCOLTYPE$ null TABLE/PROCEDURE TABLE 1431 1 0 0 0
SYS SYN$ null TABLE/PROCEDURE TABLE 1424 1 0 0 0
SYS SYS null TABLE/PROCEDURE NON-EXISTENT 863 1 0 0 0
SYS SYSAUTH$ null TABLE/PROCEDURE TABLE 1428 1 0 0 0
SYS SYS_DBA_SEGS null TABLE/PROCEDURE VIEW 3060 1 0 0 0
SYS SYS_LOGOFF null TRIGGER TRIGGER 1834 1 0 0 0
SYS SYS_LOGON null TRIGGER TRIGGER 1513 1 0 0 0
SYS SYS_OBJECTS null TABLE/PROCEDURE VIEW 3111 1 0 0 0
SYS TAB$ null TABLE/PROCEDURE TABLE 1664 1 0 0 0
SYS TABCOMPART$ null TABLE/PROCEDURE TABLE 1431 1 0 0 0
SYS TABPART$ null TABLE/PROCEDURE TABLE 1428 1 0 0 0
SYS TABSUBPART$ null TABLE/PROCEDURE TABLE 1431 1 0 0 0
SYS TRIGGER$ null TABLE/PROCEDURE TABLE 1428 1 0 0 0
SYS TRIGGERCOL$ null TABLE/PROCEDURE TABLE 1431 1 0 0 0
SYS TS$ null TABLE/PROCEDURE TABLE 13759 1 0 0 0
SYS TYPE$ null TABLE/PROCEDURE TABLE 1445 1 0 0 0
SYS TYPE_MISC$ null TABLE/PROCEDURE TABLE 1430 1 0 0 0
SYS UET$ null TABLE/PROCEDURE TABLE 9256 1 0 0 0
SYS UNDO$ null TABLE/PROCEDURE TABLE 1425 1 0 0 0
SYS USER$ null TABLE/PROCEDURE TABLE 1425 1 0 0 0
SYS UTL_HTTP null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS UTL_RAW null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS V$ACCESS null TABLE/PROCEDURE VIEW 548 1 0 0 0
SYS V$ACTIVE_INSTANCES null TABLE/PROCEDURE NOT LOADED 0 0 0 0 0
SYS V$DATABASE null TABLE/PROCEDURE VIEW 14014 1 0 0 0
SYS V$DATAFILE null TABLE/PROCEDURE VIEW 550 1 0 0 0
SYS V$DBFILE null TABLE/PROCEDURE VIEW 7928 1 0 0 0
SYS V$DB_OBJECT_CACHE null TABLE/PROCEDURE VIEW 557 1 0 0 0
SYS V$FILESTAT null TABLE/PROCEDURE VIEW 550 1 0 0 0
SYS V$INSTANCE null TABLE/PROCEDURE VIEW 550 1 0 0 0
SYS V$LIBRARYCACHE null TABLE/PROCEDURE VIEW 554 1 0 0 0
SYS V$LOG null TABLE/PROCEDURE VIEW 545 1 0 0 0
SYS V$LOGFILE null TABLE/PROCEDURE VIEW 549 1 0 0 0
SYS V$LOGHIST null TABLE/PROCEDURE VIEW 549 1 0 0 0
SYS V$LOG_HISTORY null TABLE/PROCEDURE VIEW 553 1 0 0 0
SYS V$PARAMETER null TABLE/PROCEDURE VIEW 551 1 0 0 0
SYS V$ROLLSTAT null TABLE/PROCEDURE VIEW 550 1 0 0 0
SYS V$ROWCACHE null TABLE/PROCEDURE VIEW 550 1 0 0 0
SYS V$SESSION null TABLE/PROCEDURE VIEW 549 1 0 0 0
SYS V$SQLAREA null TABLE/PROCEDURE VIEW 549 1 0 0 0
SYS V$SYSSTAT null TABLE/PROCEDURE VIEW 549 1 0 0 0
SYS V$VERSION null TABLE/PROCEDURE VIEW 549 1 0 0 0
SYS V$WAITSTAT null TABLE/PROCEDURE VIEW 550 1 0 0 0
SYS VIEW$ null TABLE/PROCEDURE TABLE 1425 1 0 0 0
SYS V_$ACCESS null TABLE/PROCEDURE VIEW 2001 1 0 0 0
SYS V_$DATABASE null TABLE/PROCEDURE VIEW 15359 1 0 0 0
SYS V_$DATAFILE null TABLE/PROCEDURE VIEW 1991 1 0 0 0
SYS V_$DBFILE null TABLE/PROCEDURE VIEW 9201 1 0 0 0
SYS V_$DB_OBJECT_CACHE null TABLE/PROCEDURE VIEW 1998 1 0 0 0
SYS V_$FILESTAT null TABLE/PROCEDURE VIEW 1991 1 0 0 0
SYS V_$INSTANCE null TABLE/PROCEDURE VIEW 1991 1 0 0 0
SYS V_$LIBRARYCACHE null TABLE/PROCEDURE VIEW 1995 1 0 0 0
SYS V_$LOG null TABLE/PROCEDURE VIEW 1986 1 0 0 0
SYS V_$LOGFILE null TABLE/PROCEDURE VIEW 1990 1 0 0 0
SYS V_$LOGHIST null TABLE/PROCEDURE VIEW 1990 1 0 0 0
SYS V_$LOG_HISTORY null TABLE/PROCEDURE VIEW 1994 1 0 0 0
SYS V_$ROLLNAME null TABLE/PROCEDURE VIEW 1991 1 0 0 0
SYS V_$ROLLSTAT null TABLE/PROCEDURE VIEW 1991 1 0 0 0
SYS V_$ROWCACHE null TABLE/PROCEDURE VIEW 1991 1 0 0 0
SYS V_$SESSION null TABLE/PROCEDURE VIEW 1990 1 0 0 0
SYS V_$SQLAREA null TABLE/PROCEDURE VIEW 1990 1 0 0 0
SYS V_$SYSSTAT null TABLE/PROCEDURE VIEW 1990 1 0 0 0
SYS V_$VERSION null TABLE/PROCEDURE VIEW 2014 1 0 0 0
SYS V_$WAITSTAT null TABLE/PROCEDURE VIEW 1991 1 0 0 0
SYS X$KCBWAIT null TABLE/PROCEDURE TABLE 549 1 0 0 0
SYS X$KCCDI null TABLE/PROCEDURE TABLE 547 1 0 0 0
SYS X$KCCFE null TABLE/PROCEDURE TABLE 547 1 0 0 0
SYS X$KCCFN null TABLE/PROCEDURE TABLE 547 1 0 0 0
SYS X$KCCLE null TABLE/PROCEDURE TABLE 547 1 0 0 0
SYS X$KCCLH null TABLE/PROCEDURE TABLE 547 1 0 0 0
SYS X$KCCRT null TABLE/PROCEDURE TABLE 547 1 0 0 0
SYS X$KCFIO null TABLE/PROCEDURE TABLE 547 1 0 0 0
SYS X$KCVFH null TABLE/PROCEDURE TABLE 547 1 0 0 0
SYS X$KGLCURSOR null TABLE/PROCEDURE TABLE 551 1 0 0 0
SYS X$KGLDP null TABLE/PROCEDURE TABLE 547 1 0 0 0
SYS X$KGLLK null TABLE/PROCEDURE TABLE 547 1 0 0 0
SYS X$KGLOB null TABLE/PROCEDURE TABLE 547 1 0 0 0
SYS X$KGLST null TABLE/PROCEDURE TABLE 547 1 0 0 0
SYS X$KQRST null TABLE/PROCEDURE TABLE 547 1 0 0 0
SYS X$KSPPCV null TABLE/PROCEDURE TABLE 548 1 0 0 0
SYS X$KSPPI null TABLE/PROCEDURE TABLE 547 1 0 0 0
SYS X$KSUSE null TABLE/PROCEDURE TABLE 547 1 0 0 0
SYS X$KSUSGSTA null TABLE/PROCEDURE TABLE 550 1 0 0 0
SYS X$KSUXSINST null TABLE/PROCEDURE TABLE 551 1 0 0 0
SYS X$KTFBFE null TABLE/PROCEDURE TABLE 548 1 0 0 0
SYS X$KTFBHC null TABLE/PROCEDURE TABLE 548 1 0 0 0
SYS X$KTURD null TABLE/PROCEDURE TABLE 547 1 0 0 0
SYS X$KVIT null TABLE/PROCEDURE TABLE 546 1 0 0 0
SYS X$QUIESCE null TABLE/PROCEDURE TABLE 549 1 0 0 0
SYS X$VERSION null TABLE/PROCEDURE TABLE 549 1 0 0 0
SYSTEM AQ$_DEF$_AQCALL_I null INDEX NOT LOADED 0 1 0 0 0
SYSTEM AQ$_DEF$_AQERROR_I null INDEX NOT LOADED 0 1 0 0 0
SYSTEM AQ$_QUEUES null TABLE/PROCEDURE TABLE 1993 1 0 0 0
SYSTEM AQ$_QUEUE_TABLES null TABLE/PROCEDURE TABLE 1439 1 0 0 0
SYSTEM DBA_SEGMENTS null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM DBMS_APPLICATION_INFO null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM DBMS_OUTPUT null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM DEF$_AQCALL null TABLE/PROCEDURE TABLE 1994 1 0 0 0
SYSTEM DEF$_AQERROR null TABLE/PROCEDURE TABLE 1435 1 0 0 0
SYSTEM DUAL null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM GLOBAL_NAME null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM NLS_INSTANCE_PARAMETERS null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM POOL_SIZE null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM REPCAT$_REPPROP null TABLE/PROCEDURE TABLE 1438 1 0 0 0
SYSTEM SYSTEM null PUB_SUB PUB_SUB 929 1 0 1 0
SYSTEM TIME null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$ACCESS null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$DATABASE null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$DATAFILE null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$DBFILE null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$DB_OBJECT_CACHE null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$FILESTAT null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$INSTANCE null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$LIBRARYCACHE null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$LOG null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$LOGFILE null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$LOGHIST null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$ROLLNAME null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$ROLLSTAT null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$ROWCACHE null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$SESSION null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$SQLAREA null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$SYSSTAT null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$VERSION null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
SYSTEM V$WAITSTAT null TABLE/PROCEDURE NOT LOADED 0 1 0 0 0
null ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN' null CURSOR CURSOR 3912 1 11 1 0
null ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN' null CURSOR CURSOR 1473 1 0 1 0
null 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' null CURSOR CURSOR 3660 1 1 0 0
null 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' null CURSOR CURSOR 2165 1 0 0 0
null 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' null CURSOR NOT LOADED 0 1 1 0 0
null 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' null CURSOR CURSOR 1664 1 0 0 0
null ALTER SESSION SET NLS_TERRITORY = 'AMERICA' null CURSOR CURSOR 3660 1 11 1 0
null ALTER SESSION SET NLS_TERRITORY = 'AMERICA' null CURSOR CURSOR 1461 1 0 1 0
null BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END; null CURSOR CURSOR 8040 1 1 0 0
null BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END; null CURSOR CURSOR 1472 1 0 0 0
null BEGIN DBMS_OUTPUT.DISABLE; END; null CURSOR CURSOR 7592 1 1 0 0
null BEGIN DBMS_OUTPUT.DISABLE; END; null CURSOR CURSOR 1449 1 0 0 0
null BEGIN DBMS_OUTPUT.ENABLE(10240); END; null CURSOR CURSOR 7836 1 6 0 0
null BEGIN DBMS_OUTPUT.ENABLE(10240); END; null CURSOR CURSOR 1339 1 0 0 0
null BEGIN DBMS_OUTPUT.ENABLE(2000); END; null CURSOR CURSOR 8156 1 2 0 0
null BEGIN DBMS_OUTPUT.ENABLE(2000); END; null CURSOR CURSOR 1454 1 0 0 0
null BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END; null CURSOR CURSOR 9348 1 8 0 0
null BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END; null CURSOR CURSOR 1402 1 0 0 0
null DELETE FROM AQ$_PEND null CURSOR NOT LOADED 0 0 0 0 0
null DELETE FROM SYS.AQ$_ null CURSOR NOT LOADED 0 0 0 0 0
null DELETE FROM SYS.AQ$_ null CURSOR NOT LOADED 0 0 0 0 0
null DELETE FROM SYS.AQ$_ null CURSOR NOT LOADED 0 0 0 0 0
null INSERT INTO SMON_SCN_TIME (THREAD, TIME_MP, TIME_DP, SCN_WRP, SCN_BAS) VALUES (:1, :2, :3, :4, :5) null CURSOR CURSOR 6368 1 4 0 0
null INSERT INTO SMON_SCN_TIME (THREAD, TIME_MP, TIME_DP, SCN_WRP, SCN_BAS) VALUES (:1, :2, :3, :4, :5) null CURSOR CURSOR 1517 1 0 0 0
null INSERT INTO SYS.AQ$_ null CURSOR NOT LOADED 0 0 0 0 0
null LOCK TABLE SYS.AQ$_P null CURSOR NOT LOADED 0 0 0 0 0
null SELECT 'x' FROM SY null CURSOR NOT LOADED 0 0 0 0 0
null SELECT * FROM SYS.TS$ WHERE ONLINE$ = 1 ORDER BY NAME null CURSOR CURSOR 14352 1 1 0 0
null SELECT * FROM SYS.TS$ WHERE ONLINE$ = 1 ORDER BY NAME null CURSOR CURSOR 1472 1 0 0 0
null 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 null CURSOR CURSOR 10208 1 2 0 0
null 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 null CURSOR CURSOR 1728 1 0 0 0
null 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 null CURSOR CURSOR 8820 1 2 0 0
null 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 null CURSOR CURSOR 2006 1 0 0 0
null 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 null CURSOR CURSOR 8512 1 2 0 0
null 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 null CURSOR CURSOR 1684 1 0 0 0
null 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 null CURSOR CURSOR 7712 1 6 0 0
null 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 null CURSOR CURSOR 1615 1 0 0 0
null 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 null CURSOR CURSOR 8200 1 2 0 0
null 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 null CURSOR CURSOR 1615 1 0 0 0
null 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 null CURSOR CURSOR 7356 1 2 0 0
null 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 null CURSOR CURSOR 1616 1 0 0 0
null 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 null CURSOR CURSOR 7932 1 6 0 0
null 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 null CURSOR CURSOR 1852 1 0 0 0
null 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 null CURSOR CURSOR 7932 1 6 0 0
null 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 null CURSOR CURSOR 1617 1 0 0 0
null SELECT 1 FROM SYS. null CURSOR NOT LOADED 0 0 0 0 0
null SELECT 1 FROM SYS. null CURSOR NOT LOADED 0 0 0 0 0
null SELECT A.OWNER_INSTA null CURSOR NOT LOADED 0 0 0 0 0
null SELECT COUNT(*) FR null CURSOR NOT LOADED 0 0 0 0 0
null SELECT COUNT(*) FR null CURSOR NOT LOADED 0 0 0 0 0
null SELECT COUNT(*) FR null CURSOR NOT LOADED 0 0 0 0 0
null SELECT COUNT(*) FR null CURSOR NOT LOADED 0 0 0 0 0
null SELECT COUNT(*), SUM(BLOCKS)*:B2 FROM SYS.FILE$ FL, V$DBFILE VF WHERE FL.TS# = :B1 AND FL.FILE# = VF.FILE# null CURSOR CURSOR 13920 1 7 0 0
null SELECT COUNT(*), SUM(BLOCKS)*:B2 FROM SYS.FILE$ FL, V$DBFILE VF WHERE FL.TS# = :B1 AND FL.FILE# = VF.FILE# null CURSOR CURSOR 1524 1 0 0 0
null SELECT CT.TOID,CT.VE null CURSOR NOT LOADED 0 0 0 0 0
null SELECT DBTIMEZONE FR null CURSOR NOT LOADED 0 0 0 0 0
null SELECT DECODE('A','A','1','2') FROM DUAL null CURSOR CURSOR 3956 1 1 0 0
null SELECT DECODE('A','A','1','2') FROM DUAL null CURSOR CURSOR 1710 1 0 0 0
null SELECT DISTINCT OBJ# null CURSOR NOT LOADED 0 0 0 0 0
null SELECT DISTINCT OBJE null CURSOR NOT LOADED 0 0 0 0 0
null SELECT DISTINCT TO_C null CURSOR NOT LOADED 0 0 0 0 0
null SELECT DURATION,NEXT null CURSOR NOT LOADED 0 0 0 0 0
null SELECT ENABLE_FLAG null CURSOR NOT LOADED 0 0 0 0 0
null SELECT EVENTID,PROPE null CURSOR NOT LOADED 0 0 0 0 0
null SELECT INSTANCE_NUMBER FROM SYS.V$INSTANCE null CURSOR CURSOR 24164 1 1 0 0
null SELECT INSTANCE_NUMBER FROM SYS.V$INSTANCE null CURSOR CURSOR 1462 1 0 0 0
null SELECT INST_NUMBER,I null CURSOR NOT LOADED 0 0 0 0 0
null SELECT JOBNO,DISABLE null CURSOR NOT LOADED 0 0 0 0 0
null SELECT JOBNO,DISABLE null CURSOR NOT LOADED 0 0 0 0 0
null SELECT JOBNO,INSTANC null CURSOR NOT LOADED 0 0 0 0 0
null SELECT JOBNO,PROCESS null CURSOR NOT LOADED 0 0 0 0 0
null SELECT MIN(1) FROM null CURSOR NOT LOADED 0 0 0 0 0
null SELECT MIN(TIME_MP), COUNT(*) FROM SMON_SCN_TIME WHERE THREAD = :1 null CURSOR CURSOR 5652 1 4 0 0
null SELECT MIN(TIME_MP), COUNT(*) FROM SMON_SCN_TIME WHERE THREAD = :1 null CURSOR CURSOR 1484 1 0 0 0
null SELECT MSGID,COPY,PM null CURSOR NOT LOADED 0 0 0 0 0
null SELECT NAME FROM V$DATABASE null CURSOR CURSOR 49896 1 1 0 0
null SELECT NAME FROM V$DATABASE null CURSOR CURSOR 1609 1 0 0 0
null SELECT NEXT_DATE F null CURSOR NOT LOADED 0 0 0 0 0
null SELECT NEXT_TIME,LAT null CURSOR NOT LOADED 0 0 0 0 0
null SELECT NLS_CHARSET_D null CURSOR NOT LOADED 0 0 0 0 0
null SELECT NLS_CHARSET_I null CURSOR NOT LOADED 0 0 0 0 0
null SELECT NLS_CHARSET_N null CURSOR NOT LOADED 0 0 0 0 0
null SELECT NULL FROM DUAL FOR UPDATE NOWAIT null CURSOR CURSOR 4132 1 1 0 0
null SELECT NULL FROM DUAL FOR UPDATE NOWAIT null CURSOR CURSOR 1370 1 0 0 0
null SELECT NULL FROM OBJ$ WHERE NAME='MAP_FILE$' AND OWNER# = 0 null CURSOR CURSOR 6360 1 1 0 0
null SELECT NULL FROM OBJ$ WHERE NAME='MAP_FILE$' AND OWNER# = 0 null CURSOR CURSOR 1477 1 0 0 0
null SELECT O.OBJ#,O.NAME null CURSOR NOT LOADED 0 0 0 0 0
null SELECT O.OBJ#,O.NAME null CURSOR NOT LOADED 0 0 0 0 0
null SELECT OBJECT_ID F null CURSOR NOT LOADED 0 0 0 0 0
null SELECT OBJECT_NAME,O null CURSOR NOT LOADED 0 0 0 0 0
null SELECT OWNER,OBJECT_ null CURSOR NOT LOADED 0 0 0 0 0
null SELECT PARTITION_NAM null CURSOR NOT LOADED 0 0 0 0 0
null SELECT PARTITION_NAM null CURSOR NOT LOADED 0 0 0 0 0
null SELECT POWER(2,:b1 - null CURSOR NOT LOADED 0 0 0 0 0
null SELECT PROCESS_NAME null CURSOR NOT LOADED 0 0 0 0 0
null SELECT Q.EVENTID F null CURSOR NOT LOADED 0 0 0 0 0
null SELECT Q.EVENTID,Q.P null CURSOR NOT LOADED 0 0 0 0 0
null SELECT Q.EVENTID,T.N null CURSOR NOT LOADED 0 0 0 0 0
null SELECT Q.NAME,T.SCHE null CURSOR NOT LOADED 0 0 0 0 0
null SELECT Q.NAME,T.SCHE null CURSOR NOT LOADED 0 0 0 0 0
null SELECT S.OID SOID,S. null CURSOR NOT LOADED 0 0 0 0 0
null SELECT S.OID,S.DESTI null CURSOR NOT LOADED 0 0 0 0 0
null 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 null CURSOR CURSOR 12844 1 1 0 0
null 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 null CURSOR CURSOR 1715 1 0 0 0
null SELECT S.TOTAL_TIME, null CURSOR NOT LOADED 0 0 0 0 0
null SELECT SOUNDEX(:B1) null CURSOR NOT LOADED 0 0 0 0 0
null SELECT STATUS FROM null CURSOR NOT LOADED 0 0 0 0 0
null SELECT STATUS,SEQUEN null CURSOR NOT LOADED 0 0 0 0 0
null 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# null CURSOR CURSOR 8828 1 7 0 0
null 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# null CURSOR CURSOR 1606 1 0 0 0
null 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 null CURSOR CURSOR 9628 1 7 0 0
null 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 null CURSOR CURSOR 1644 1 0 0 0
null SELECT SYSDATE FRO null CURSOR NOT LOADED 0 0 0 0 0
null SELECT SYSDATE FROM null CURSOR NOT LOADED 0 0 0 0 0
null SELECT SYSTIMESTAMP null CURSOR NOT LOADED 0 0 0 0 0
null SELECT SYS_CONTEXT(: null CURSOR NOT LOADED 0 0 0 0 0
null SELECT SYS_CONTEXT(: null CURSOR NOT LOADED 0 0 0 0 0
null SELECT SYS_GUID() FR null CURSOR NOT LOADED 0 0 0 0 0
null SELECT T.NAME FROM null CURSOR NOT LOADED 0 0 0 0 0
null SELECT UID FROM DU null CURSOR NOT LOADED 0 0 0 0 0
null SELECT UID FROM SYS. null CURSOR NOT LOADED 0 0 0 0 0
null SELECT USER FROM D null CURSOR NOT LOADED 0 0 0 0 0
null SELECT USER FROM DUAL null CURSOR CURSOR 3936 1 1 0 0
null SELECT USER FROM DUAL null CURSOR CURSOR 1680 1 0 0 0
null SELECT USER FROM SYS null CURSOR NOT LOADED 0 0 0 0 0
null SELECT USERENV('CLIE null CURSOR NOT LOADED 0 0 0 0 0
null SELECT USERENV('ENTR null CURSOR NOT LOADED 0 0 0 0 0
null SELECT USERENV('INST null CURSOR NOT LOADED 0 0 0 0 0
null SELECT USERENV('ISDB null CURSOR NOT LOADED 0 0 0 0 0
null SELECT USERENV('LANG null CURSOR NOT LOADED 0 0 0 0 0
null SELECT USERENV('LANG null CURSOR NOT LOADED 0 0 0 0 0
null SELECT USERENV('SCHE null CURSOR NOT LOADED 0 0 0 0 0
null SELECT USERENV('SESS null CURSOR NOT LOADED 0 0 0 0 0
null SELECT USERENV('TERM null CURSOR NOT LOADED 0 0 0 0 0
null SELECT VALUE FROM null CURSOR NOT LOADED 0 0 0 0 0
null SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT' null CURSOR CURSOR 23880 1 11 1 0
null SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT' null CURSOR CURSOR 1494 1 0 1 0
null SELECT VALUE$ FROM null CURSOR NOT LOADED 0 0 0 0 0
null SELECT apply#, apply_name FROM sys.streams$_apply_process WHERE status = :1 ORDER BY apply# null CURSOR CURSOR 6676 1 1 0 0
null SELECT apply#, apply_name FROM sys.streams$_apply_process WHERE status = :1 ORDER BY apply# null CURSOR CURSOR 1511 1 0 0 0
null SELECT capture#, capture_name FROM sys.streams$_capture_process WHERE status = :1 ORDER BY capture# null CURSOR CURSOR 5880 1 1 0 0
null SELECT capture#, capture_name FROM sys.streams$_capture_process WHERE status = :1 ORDER BY capture# null CURSOR CURSOR 1519 1 0 0 0
null 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 null CURSOR CURSOR 7632 1 8 0 0
null 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 null CURSOR CURSOR 1613 1 0 0 0
null 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 null CURSOR CURSOR 26732 1 1 0 0
null 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 null CURSOR CURSOR 1618 1 0 0 0
null 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 null CURSOR CURSOR 121604 1 1 0 0
null 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 null CURSOR CURSOR 1853 1 0 0 0
null Select Global_Name Instance From Global_Name null CURSOR CURSOR 5872 1 1 0 0
null Select Global_Name Instance From Global_Name null CURSOR CURSOR 1462 1 0 0 0
null 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 null CURSOR CURSOR 149988 1 1 0 0
null 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 null CURSOR CURSOR 1986 1 0 0 0
null Select Owner, Object_Name, Object_Type, Created, Last_DDL_Time From Sys.DBA_Objects Where Status = 'INVALID' Order By Owner, Object_Type null CURSOR CURSOR 41760 1 1 0 0
null Select Owner, Object_Name, Object_Type, Created, Last_DDL_Time From Sys.DBA_Objects Where Status = 'INVALID' Order By Owner, Object_Type null CURSOR CURSOR 1555 1 0 0 0
null 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 null CURSOR CURSOR 148400 1 1 0 0
null 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 null CURSOR CURSOR 1922 1 0 0 0
null Select Segment_Name, Segment_Type, Owner From Sys.DBA_Segments Where TableSpace_Name = 'SYSTEM' And Owner Not In ('SYS', 'SYSTEM', 'OUTLN') null CURSOR CURSOR 126240 1 1 0 0
null Select Segment_Name, Segment_Type, Owner From Sys.DBA_Segments Where TableSpace_Name = 'SYSTEM' And Owner Not In ('SYS', 'SYSTEM', 'OUTLN') null CURSOR CURSOR 1564 1 0 0 0
null 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 null CURSOR CURSOR 17116 1 1 0 0
null 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 null CURSOR CURSOR 1811 1 0 0 0
null 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 null CURSOR CURSOR 26032 1 1 0 0
null 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 null CURSOR CURSOR 1626 1 0 0 0
null Select Sum(gets) Gets, Sum(getmisses) Misses, (1-(Sum(getmisses)/Sum(gets))) * 100 Hit_Ratio from V$RowCache null CURSOR CURSOR 20992 1 1 0 0
null Select Sum(gets) Gets, Sum(getmisses) Misses, (1-(Sum(getmisses)/Sum(gets))) * 100 Hit_Ratio from V$RowCache null CURSOR CURSOR 1534 1 0 0 0
null 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 null CURSOR CURSOR 284304 1 1 0 0
null 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 null CURSOR CURSOR 1789 1 0 0 0
null UPDATE SYS.AQ$_PROPA null CURSOR NOT LOADED 0 0 0 0 0
null UPDATE SYS.AQ$_SCHED null CURSOR NOT LOADED 0 0 0 0 0
null UPDATE SYS.AQ$_SCHED null CURSOR NOT LOADED 0 0 0 0 0
null UPDATE SYS.AQ$_SCHED null CURSOR NOT LOADED 0 0 0 0 0
null UPDATE SYS.AQ$_SCHED null CURSOR NOT LOADED 0 0 0 0 0
null UPDATE SYS.AQ$_SCHED null CURSOR NOT LOADED 0 0 0 0 0
null UPDATE SYS.AQ$_SCHED null CURSOR NOT LOADED 0 0 0 0 0
null UPDATE SYS.AQ$_SCHED null CURSOR NOT LOADED 0 0 0 0 0
null UPDATE SYS.AQ$_SCHED null CURSOR NOT LOADED 0 0 0 0 0
null UPDATE SYS.AQ$_SCHED null CURSOR NOT LOADED 0 0 0 0 0
null UPDATE SYS.AQ$_SCHED null CURSOR NOT LOADED 0 0 0 0 0
null UPDATE SYS.AQ$_SCHED null CURSOR NOT LOADED 0 0 0 0 0
null UPDATE SYS.AQ$_SCHED null CURSOR NOT LOADED 0 0 0 0 0
null alter database mount exclusive null CURSOR NOT LOADED 0 1 1 0 0
null alter database mount exclusive null CURSOR CURSOR 1449 1 0 0 0
null alter database open null CURSOR NOT LOADED 0 1 1 0 0
null alter database open null CURSOR CURSOR 1437 1 0 0 0
null begin dbms_output.put_line(' '); end; null CURSOR CURSOR 8112 1 7 0 0
null begin dbms_output.put_line(' '); end; null CURSOR CURSOR 1455 1 0 0 0
null begin sys.dbms_prvtaqip.update_aqs_instance(); end; null CURSOR CURSOR 7836 1 1 0 0
null begin sys.dbms_prvtaqip.update_aqs_instance(); end; null CURSOR CURSOR 1305 1 0 0 0
null 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, null CURSOR CURSOR 13028 1 1 0 0
null 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, null CURSOR CURSOR 3834 1 0 0 0
null 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) null CURSOR CURSOR 14352 1 0 0 0
null 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) null CURSOR CURSOR 1678 1 0 0 0
null lock table sys.col_usage$ in exclusive mode nowait null CURSOR CURSOR 3440 1 12 0 0
null lock table sys.col_usage$ in exclusive mode nowait null CURSOR CURSOR 1468 1 0 0 0
null 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 null CURSOR CURSOR 14584 1 1 0 0
null 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 null CURSOR CURSOR 1601 1 0 0 0
null select 'to_char(first_time,''DD/MM/YY HH24:MI:SS'')' time from dual where 902000500 like '8%' -- Oracle8 null CURSOR CURSOR 4096 1 1 0 0
null select 'to_char(first_time,''DD/MM/YY HH24:MI:SS'')' time from dual where 902000500 like '8%' -- Oracle8 null CURSOR CURSOR 1803 1 0 0 0
null select * from V$ACCESS null CURSOR CURSOR 26372 1 1 0 0
null select * from V$ACCESS null CURSOR CURSOR 1412 1 0 0 0
null select * from v$db_object_cache null CURSOR CURSOR 54748 1 1 0 0
null select * from v$db_object_cache null CURSOR CURSOR 1449 1 0 0 0
null select * from v$rowcache null CURSOR CURSOR 33832 1 1 0 0
null select * from v$rowcache null CURSOR CURSOR 1442 1 0 0 0
null select * pool_size f null CURSOR NOT LOADED 0 1 0 0 0
null select * pool_size f null CURSOR CURSOR 1396 1 0 0 0
null 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# null CURSOR CURSOR 7496 1 34 0 0
null 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# null CURSOR CURSOR 1553 1 0 0 0
null 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# null CURSOR CURSOR 7536 1 34 0 0
null 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# null CURSOR CURSOR 1550 1 0 0 0
null 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# null CURSOR CURSOR 7348 1 34 0 0
null 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# null CURSOR CURSOR 1550 1 0 0 0
null 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# null CURSOR CURSOR 7412 1 34 0 0
null 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# null CURSOR CURSOR 1550 1 0 0 0
null 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 null CURSOR CURSOR 10468 1 113 0 0
null 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 null CURSOR CURSOR 1628 1 0 0 0
null select 1 from aq$_schedules null CURSOR CURSOR 4088 1 1 0 0
null select 1 from aq$_schedules null CURSOR CURSOR 1345 1 0 0 0
null 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)) null CURSOR CURSOR 8824 1 1 0 0
null 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)) null CURSOR CURSOR 1547 1 0 0 0
null select 1 from sys.aq$_queue_table_affinities null CURSOR CURSOR 3540 1 1 0 0
null select 1 from sys.aq$_queue_table_affinities null CURSOR CURSOR 1462 1 0 0 0
null select OPEN_MODE from v$database null CURSOR CURSOR 48892 1 1 0 0
null select OPEN_MODE from v$database null CURSOR CURSOR 1450 1 0 0 0
null select OWNER, NAME, DB_LINK, NAMESPACE, TYPE, SHARABLE_MEM, LOADS, EXECUTIONS, LOCKS, PINS from v$db_object_cache order by OWNER, NAME null CURSOR CURSOR 52584 1 0 1 1
null select OWNER, NAME, DB_LINK, NAMESPACE, TYPE, SHARABLE_MEM, LOADS, EXECUTIONS, LOCKS, PINS from v$db_object_cache order by OWNER, NAME null CURSOR CURSOR 1415 1 0 1 0
null select SCHEMANAME, OSUSER, MACHINE, PROGRAM from V$SESSION where SCHEMA# > 0 null CURSOR CURSOR 52236 1 1 0 0
null select SCHEMANAME, OSUSER, MACHINE, PROGRAM from V$SESSION where SCHEMA# > 0 null CURSOR CURSOR 1442 1 0 0 0
null select TOTAL from SYS.ID_GENS$ null CURSOR CURSOR 3336 1 1 0 0
null select TOTAL from SYS.ID_GENS$ null CURSOR CURSOR 1448 1 0 0 0
null 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 null CURSOR CURSOR 37368 1 1 0 0
null 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 null CURSOR CURSOR 1586 1 0 0 0
null 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 null CURSOR CURSOR 11832 1 1 0 0
null 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 null CURSOR CURSOR 1673 1 0 0 0
null select action# from trigger$ where obj# = :1 null CURSOR CURSOR 5636 1 2 0 0
null select action# from trigger$ where obj# = :1 null CURSOR CURSOR 1462 1 0 0 0
null select actionsize from trigger$ where obj# = :1 null CURSOR CURSOR 5640 1 2 0 0
null select actionsize from trigger$ where obj# = :1 null CURSOR CURSOR 1465 1 0 0 0
null select audit$,options from procedure$ where obj#=:1 null CURSOR CURSOR 5384 1 17 0 0
null select audit$,options from procedure$ where obj#=:1 null CURSOR CURSOR 1469 1 0 0 0
null select audit$,properties from type_misc$ where obj#=:1 null CURSOR CURSOR 5596 1 4 0 0
null select audit$,properties from type_misc$ where obj#=:1 null CURSOR CURSOR 1472 1 0 0 0
null select banner from v$version where banner like '%racle%' null CURSOR CURSOR 8764 1 1 0 0
null select banner from v$version where banner like '%racle%' null CURSOR CURSOR 1822 1 0 0 0
null select baseobject,type#,update$,insert$,delete$,refnewname,refoldname,whenclause,definition,enabled,property,sys_evts,nttrigcol,nttrigatt,refprtname,rowid from trigger$ where obj# =:1 null CURSOR CURSOR 9484 1 2 0 0
null select baseobject,type#,update$,insert$,delete$,refnewname,refoldname,whenclause,definition,enabled,property,sys_evts,nttrigcol,nttrigatt,refprtname,rowid from trigger$ where obj# =:1 null CURSOR CURSOR 1933 1 0 0 0
null select blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, nvl(degree,1), nvl(instances,1) from ind$ where bo# = :1 and obj# = :2 null CURSOR NOT LOADED 0 1 31 0 0
null select blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, nvl(degree,1), nvl(instances,1) from ind$ where bo# = :1 and obj# = :2 null CURSOR CURSOR 1554 1 0 0 0
null select blocks,NVL(ts#,-1),status$,NVL(relfile#,0),maxextend,inc, crscnwrp,crscnbas,NVL(spare1,0) from file$ where file#=:1 null CURSOR CURSOR 8520 1 5 0 0
null select blocks,NVL(ts#,-1),status$,NVL(relfile#,0),maxextend,inc, crscnwrp,crscnbas,NVL(spare1,0) from file$ where file#=:1 null CURSOR CURSOR 1844 1 0 0 0
null select charsetid, charsetform from col$ where obj# = :1 and col# = :2 null CURSOR NOT LOADED 0 1 45 0 0
null select charsetid, charsetform from col$ where obj# = :1 and col# = :2 null CURSOR CURSOR 1488 1 0 0 0
null 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# null CURSOR CURSOR 8136 2 62 0 0
null 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# null CURSOR CURSOR 1499 1 0 0 0
null select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc null CURSOR CURSOR 7652 1 38 0 0
null select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc null CURSOR CURSOR 1504 1 0 0 0
null select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc null CURSOR CURSOR 7316 1 38 0 0
null select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc null CURSOR CURSOR 1489 1 0 0 0
null select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc null CURSOR CURSOR 7652 1 38 0 0
null select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc null CURSOR CURSOR 1508 1 0 0 0
null select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc null CURSOR CURSOR 9160 1 38 0 0
null select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc null CURSOR CURSOR 1559 1 0 0 0
null select cols,audit$,textlength,intcols,property,flags,rowid from view$ where obj#=:1 null CURSOR CURSOR 6420 1 29 0 0
null select cols,audit$,textlength,intcols,property,flags,rowid from view$ where obj#=:1 null CURSOR CURSOR 1501 1 0 0 0
null select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1 null CURSOR CURSOR 8312 2 10 0 0
null select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1 null CURSOR CURSOR 1487 1 0 0 0
null 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 null CURSOR CURSOR 10820 2 11 0 0
null 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 null CURSOR CURSOR 1564 1 0 0 0
null select count(*) from dba_jobs where what = 'sys.dbms_aqadm_sys.register_driver();' null CURSOR CURSOR 6520 1 1 0 0
null select count(*) from dba_jobs where what = 'sys.dbms_aqadm_sys.register_driver();' null CURSOR CURSOR 1500 1 0 0 0
null select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400)) null CURSOR CURSOR 5836 1 227 1 0
null select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400)) null CURSOR CURSOR 1515 1 0 1 0
null select count(*) from sys.job$ where next_date < :1 and (field1 = :2 or (field1 = 0 and 'Y' = :3)) null CURSOR CURSOR 7644 1 3 1 0
null select count(*) from sys.job$ where next_date < :1 and (field1 = :2 or (field1 = 0 and 'Y' = :3)) null CURSOR CURSOR 1809 1 0 1 0
null select ctime, mtime, stime from obj$ where obj# = :1 null CURSOR NOT LOADED 0 1 55 0 0
null select ctime, mtime, stime from obj$ where obj# = :1 null CURSOR CURSOR 1470 1 0 0 0
null select database_status from v$instance null CURSOR CURSOR 25480 1 1 0 0
null select database_status from v$instance null CURSOR CURSOR 1732 1 0 0 0
null select distinct(-privilege#),nvl(option$,0) from sysauth$ where grantee#=:1 and privilege#<0 null CURSOR CURSOR 6448 1 10 0 0
null select distinct(-privilege#),nvl(option$,0) from sysauth$ where grantee#=:1 and privilege#<0 null CURSOR CURSOR 1510 1 0 0 0
null 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 null CURSOR CURSOR 8620 1 3 0 0
null 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 null CURSOR CURSOR 1549 1 0 0 0
null 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# null CURSOR CURSOR 44300 1 1 0 0
null 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# null CURSOR CURSOR 1547 1 0 0 0
null select file# from file$ where spare1 is NOT NULL and status$ = 2 null CURSOR CURSOR 5380 1 2 0 0
null select file# from file$ where spare1 is NOT NULL and status$ = 2 null CURSOR CURSOR 1814 1 0 0 0
null select file# from file$ where ts#=:1 null CURSOR CURSOR 5780 2 2349 0 0
null select file# from file$ where ts#=:1 null CURSOR CURSOR 1450 1 0 0 0
null select file#, block#, ts# from seg$ where type# = 3 null CURSOR CURSOR 5304 1 1 0 0
null select file#, block#, ts# from seg$ where type# = 3 null CURSOR CURSOR 1469 1 0 0 0
null 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# null CURSOR CURSOR 8192 2 64 0 0
null 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# null CURSOR CURSOR 1569 1 0 0 0
null select group#, thread#, sequence#, members, archived, status, first_change#, first_time from v$log order by group# null CURSOR CURSOR 36316 1 1 0 0
null select group#, thread#, sequence#, members, archived, status, first_change#, first_time from v$log order by group# null CURSOR CURSOR 1542 1 0 0 0
null 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# null CURSOR CURSOR 13928 1 1 0 0
null 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# null CURSOR CURSOR 1642 1 0 0 0
null 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# null CURSOR CURSOR 13024 1 1 0 0
null 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# null CURSOR CURSOR 1570 1 0 0 0
null 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 null CURSOR CURSOR 27132 2 69 0 0
null 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 null CURSOR CURSOR 1967 1 0 0 0
null select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$,flags from seq$ where obj#=:1 null CURSOR CURSOR 7736 1 3 0 0
null select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$,flags from seq$ where obj#=:1 null CURSOR CURSOR 1520 1 0 0 0
null select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc null CURSOR CURSOR 7872 1 38 0 0
null select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc null CURSOR CURSOR 1535 1 0 0 0
null select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1 null CURSOR CURSOR 6868 2 45 0 0
null select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1 null CURSOR CURSOR 1474 1 0 0 0
null select intcol#,type,flags,lobcol,objcol,extracol,schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc null CURSOR CURSOR 8516 1 38 0 0
null select intcol#,type,flags,lobcol,objcol,extracol,schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc null CURSOR CURSOR 1505 1 0 0 0
null 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 null CURSOR CURSOR 10880 1 226 1 0
null 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 null CURSOR CURSOR 1663 1 0 1 0
null 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 null CURSOR CURSOR 8156 1 1 0 0
null 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 null CURSOR CURSOR 1663 1 0 0 0
null 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 null CURSOR CURSOR 9672 1 38 0 0
null 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 null CURSOR CURSOR 1609 1 0 0 0
null select length from fet$ where file#=:1 and block#=:2 and ts#=:3 null CURSOR CURSOR 6284 1 1 0 0
null select length from fet$ where file#=:1 and block#=:2 and ts#=:3 null CURSOR CURSOR 1481 1 0 0 0
null select limit# from profile$ where profile#=:1 and resource#=:2 and type#=:3 null CURSOR CURSOR 6460 1 17 0 0
null select limit# from profile$ where profile#=:1 and resource#=:2 and type#=:3 null CURSOR CURSOR 1861 1 0 0 0
null select line#, sql_text from bootstrap$ where obj# != :1 null CURSOR NOT LOADED 0 1 1 0 0
null select line#, sql_text from bootstrap$ where obj# != :1 null CURSOR CURSOR 1473 1 0 0 0
null select line,position#,text from error$ where obj# = :1 order by sequence# null CURSOR CURSOR 6436 1 4 0 0
null select line,position#,text from error$ where obj# = :1 order by sequence# null CURSOR CURSOR 1492 1 0 0 0
null 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' null CURSOR CURSOR 10080 1 1 0 0
null 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' null CURSOR CURSOR 1732 1 0 0 0
null select location_name from loc$ null CURSOR CURSOR 3592 1 1 0 0
null select location_name from loc$ null CURSOR CURSOR 1448 1 0 0 0
null select max(procedure#) from procedurec$ where obj#=:1 null CURSOR CURSOR 4952 1 4 0 0
null select max(procedure#) from procedurec$ where obj#=:1 null CURSOR CURSOR 1471 1 0 0 0
null select max(procedure#) from procedurejava$ where obj#=:1 null CURSOR CURSOR 5052 1 4 0 0
null select max(procedure#) from procedurejava$ where obj#=:1 null CURSOR CURSOR 1410 1 0 0 0
null select metadata from kopm$ where name='DB_FDO' null CURSOR CURSOR 5180 1 3 0 0
null select metadata from kopm$ where name='DB_FDO' null CURSOR CURSOR 1465 1 0 0 0
null select migrated from MIGRATE$ null CURSOR CURSOR 4052 1 1 0 0
null select migrated from MIGRATE$ null CURSOR CURSOR 1731 1 0 0 0
null select name,file#,block#,status$,user#,undosqn,xactsqn,scnbas,scnwrp,DECODE(inst#,0,NULL,inst#),ts#,spare1 from undo$ where us#=:1 null CURSOR NOT LOADED 0 1 11 0 0
null select name,file#,block#,status$,user#,undosqn,xactsqn,scnbas,scnwrp,DECODE(inst#,0,NULL,inst#),ts#,spare1 from undo$ where us#=:1 null CURSOR CURSOR 1440 1 0 0 0
null 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# null CURSOR CURSOR 14968 2 98 0 0
null 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# null CURSOR CURSOR 1766 1 0 0 0
null 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 null CURSOR CURSOR 12500 2 6 0 0
null 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 null CURSOR CURSOR 2041 1 0 0 0
null 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 null CURSOR CURSOR 9404 1 13 0 0
null 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 null CURSOR CURSOR 1607 1 0 0 0
null select node,owner,name from syn$ where obj#=:1 null CURSOR CURSOR 5816 1 25 0 0
null select node,owner,name from syn$ where obj#=:1 null CURSOR CURSOR 1464 1 0 0 0
null select null from obj$ where obj#=:1 and type#=:2 and obj# not in (select p_obj# from dependency$ where p_obj# = obj$.obj#) null CURSOR CURSOR 14980 1 0 0 0
null select null from obj$ where obj#=:1 and type#=:2 and obj# not in (select p_obj# from dependency$ where p_obj# = obj$.obj#) null CURSOR CURSOR 1540 1 0 0 0
null select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1 null CURSOR CURSOR 8252 2 100 0 0
null select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1 null CURSOR CURSOR 1534 1 0 0 0
null 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#) null CURSOR CURSOR 14256 1 1 0 0
null 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#) null CURSOR CURSOR 1685 1 0 0 0
null select obj# from oid$ where user#=:1 and oid$=:2 null CURSOR CURSOR 5760 1 2 0 0
null select obj# from oid$ where user#=:1 and oid$=:2 null CURSOR CURSOR 1466 1 0 0 0
null 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 null CURSOR CURSOR 10800 2 228 0 0
null 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 null CURSOR CURSOR 1984 1 0 0 0
null select order#,columns,types from access$ where d_obj#=:1 null CURSOR CURSOR 6012 2 60 0 0
null select order#,columns,types from access$ where d_obj#=:1 null CURSOR CURSOR 1474 1 0 0 0
null 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# null CURSOR CURSOR 11960 2 60 0 0
null 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# null CURSOR CURSOR 1834 1 0 0 0
null select ownername,classname,methodname,signature,flags from procedurejava$ where obj#=:1 and procedure#=:2 order by procedure# null CURSOR CURSOR 10564 1 0 0 0
null select ownername,classname,methodname,signature,flags from procedurejava$ where obj#=:1 and procedure#=:2 order by procedure# null CURSOR CURSOR 1543 1 0 0 0
null select p.value$, lengthb(p.value$) from sys.props$ p where p.name = 'BACK_END_DB' null CURSOR CURSOR 4640 1 1 0 0
null select p.value$, lengthb(p.value$) from sys.props$ p where p.name = 'BACK_END_DB' null CURSOR CURSOR 1501 1 0 0 0
null select parsing_user_id, command_type, disk_reads, buffer_gets, executions, sql_text from v$sqlarea where disk_reads > 100000 order by disk_reads null CURSOR CURSOR 46888 1 1 0 0
null select parsing_user_id, command_type, disk_reads, buffer_gets, executions, sql_text from v$sqlarea where disk_reads > 100000 order by disk_reads null CURSOR CURSOR 1669 1 0 0 0
null 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 null CURSOR CURSOR 12080 1 1 0 0
null 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 null CURSOR CURSOR 1820 1 0 0 0
null select pool_size fro null CURSOR NOT LOADED 0 1 0 0 0
null select pool_size fro null CURSOR CURSOR 1690 1 0 0 0
null select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1 null CURSOR CURSOR 7132 2 103 0 0
null select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1 null CURSOR CURSOR 1485 1 0 0 0
null 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 null CURSOR CURSOR 11616 1 33 0 0
null 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 null CURSOR CURSOR 1691 1 0 0 0
null select privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with (grantee#=:1 or grantee#=1) and privilege#>0 null CURSOR CURSOR 11028 1 12 0 0
null select privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with (grantee#=:1 or grantee#=1) and privilege#>0 null CURSOR CURSOR 1565 1 0 0 0
null select procedure#,entrypoint# from procedurec$ where obj#=:1 order by procedure# null CURSOR CURSOR 5736 1 2 0 0
null select procedure#,entrypoint# from procedurec$ where obj#=:1 order by procedure# null CURSOR CURSOR 1830 1 0 0 0
null select procedure#,ownerlength,classlength,methodlength,siglength, flagslength,cookiesize from procedurejava$ where obj#=:1 order by procedure# null CURSOR CURSOR 7292 1 2 0 0
null select procedure#,ownerlength,classlength,methodlength,siglength, flagslength,cookiesize from procedurejava$ where obj#=:1 order by procedure# null CURSOR CURSOR 1560 1 0 0 0
null select procedure#,procedurename,properties,itypeobj# from procedureinfo$ where obj#=:1 order by procedurename desc, overload# desc null CURSOR CURSOR 7452 1 2 0 0
null select procedure#,procedurename,properties,itypeobj# from procedureinfo$ where obj#=:1 order by procedurename desc, overload# desc null CURSOR CURSOR 1548 1 0 0 0
null select procedure#,procedurename,properties,itypeobj# from procedureinfo$ where obj#=:1 order by procedurename desc, overload# desc null CURSOR CURSOR 6720 1 2 0 0
null select pval2 from sys.aux_stats$ where sname = 'SYSSTATS_INFO' and pname = 'STATUS' null CURSOR CURSOR 5340 1 1 0 0
null select pval2 from sys.aux_stats$ where sname = 'SYSSTATS_INFO' and pname = 'STATUS' null CURSOR CURSOR 1833 1 0 0 0
null select q.eventid from system.aq$_queues q null CURSOR CURSOR 4660 1 1 0 0
null select q.eventid from system.aq$_queues q null CURSOR CURSOR 1460 1 0 0 0
null 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 null CURSOR CURSOR 14928 1 1 0 0
null 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 null CURSOR CURSOR 1732 1 0 0 0
null 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 null CURSOR CURSOR 13072 1 38 0 0
null 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 null CURSOR CURSOR 2030 1 0 0 0
null 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 null CURSOR CURSOR 12324 1 38 0 0
null 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 null CURSOR CURSOR 1982 1 0 0 0
null 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 null CURSOR CURSOR 11852 1 38 0 0
null 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 null CURSOR CURSOR 2067 1 0 0 0
null 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 null CURSOR CURSOR 13876 1 38 0 0
null 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 null CURSOR CURSOR 2139 1 0 0 0
null select rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,nvl(degree,1), nvl(instances,1) from tab$ where obj# = :1 null CURSOR NOT LOADED 0 1 19 0 0
null select rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,nvl(degree,1), nvl(instances,1) from tab$ where obj# = :1 null CURSOR CURSOR 1692 1 0 0 0
null 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 null CURSOR CURSOR 167052 1 1 0 0
null 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 null CURSOR CURSOR 1703 1 0 0 0
null select substr(time, null CURSOR NOT LOADED 0 1 0 0 0
null select substr(time, null CURSOR CURSOR 3109 1 0 0 0
null select sum(getmisses)/sum(gets)*100 pool_size from v$rowcache null CURSOR CURSOR 20072 1 2 0 0
null select sum(getmisses)/sum(gets)*100 pool_size from v$rowcache null CURSOR CURSOR 1479 1 0 0 0
null 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 null CURSOR CURSOR 8964 1 152 0 0
null 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 null CURSOR CURSOR 1614 1 0 0 0
null 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 null CURSOR CURSOR 13960 1 38 0 0
null 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 null CURSOR CURSOR 2054 1 0 0 0
null 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 null CURSOR CURSOR 13964 1 1 0 0
null 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 null CURSOR CURSOR 1791 1 0 0 0
null 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 null CURSOR CURSOR 13180 1 1 0 0
null 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 null CURSOR CURSOR 1744 1 0 0 0
null 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 null CURSOR CURSOR 30372 1 2 0 0
null 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 null CURSOR CURSOR 2304 1 0 0 0
null select text from view$ where rowid=:1 null CURSOR CURSOR 5364 1 51 0 0
null select text from view$ where rowid=:1 null CURSOR CURSOR 1455 1 0 0 0
null select ts# from ts$ where name=:1 null CURSOR NOT LOADED 0 1 1 0 0
null select ts# from ts$ where name=:1 null CURSOR CURSOR 1451 1 0 0 0
null 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 null CURSOR CURSOR 10132 2 2 0 0
null 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 null CURSOR CURSOR 1892 1 0 0 0
null 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 null CURSOR CURSOR 15732 2 67 0 0
null 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 null CURSOR CURSOR 1761 1 0 0 0
null 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 null CURSOR CURSOR 10420 2 53 0 0
null 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 null CURSOR CURSOR 1492 1 0 0 0
null 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# null CURSOR CURSOR 12356 1 1 0 0
null 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# null CURSOR CURSOR 1498 1 0 0 0
null 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# null CURSOR CURSOR 13088 1 1 0 0
null 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# null CURSOR CURSOR 2008 1 0 0 0
null 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# null CURSOR CURSOR 13576 1 1 0 0
null 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# null CURSOR CURSOR 1643 1 0 0 0
null 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# null CURSOR CURSOR 13448 1 1 0 0
null 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# null CURSOR CURSOR 1593 1 0 0 0
null 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 null CURSOR CURSOR 11560 1 1 0 0
null 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 null CURSOR CURSOR 1589 1 0 0 0
null select user# from sys.user$ where name = 'OUTLN' null CURSOR CURSOR 5364 1 1 0 0
null select user# from sys.user$ where name = 'OUTLN' null CURSOR CURSOR 1262 1 0 0 0
null select user#,type# from user$ where name=:1 null CURSOR CURSOR 5968 2 2 0 0
null select user#,type# from user$ where name=:1 null CURSOR CURSOR 1461 1 0 0 0
null select value from gv$parameter where name = 'undo_retention' and INST_ID <> :1 null CURSOR CURSOR 15092 1 1 0 0
null select value from gv$parameter where name = 'undo_retention' and INST_ID <> :1 null CURSOR CURSOR 1829 1 0 0 0
null select value$ from props$ where name='DEFAULT_TEMP_TABLESPACE' null CURSOR NOT LOADED 0 1 1 0 0
null select value$ from props$ where name='DEFAULT_TEMP_TABLESPACE' null CURSOR CURSOR 1468 1 0 0 0
null select value$ from sys.props$ where name = :1 null CURSOR CURSOR 4484 2 21 0 0
null select value$ from sys.props$ where name = :1 null CURSOR CURSOR 4264 1 6 0 0
null select value$ from sys.props$ where name = :1 null CURSOR CURSOR 1463 1 0 0 0
null select value$ from sys.props$ where name = :1 null CURSOR CURSOR 4328 1 3 0 0
null table_1_0_141_0_0_0 null CURSOR CURSOR 5900 1 0 1 1
null table_1_0_141_0_0_0 null CURSOR CURSOR 1437 1 0 1 0
null update lob$ set retention = :1 where retention >= 0 null CURSOR CURSOR 6100 1 1 0 0
null update lob$ set retention = :1 where retention >= 0 null CURSOR CURSOR 1469 1 0 0 0
null update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1 null CURSOR CURSOR 9460 1 1 0 0
null update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1 null CURSOR CURSOR 1547 1 0 0 0
null 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 null CURSOR CURSOR 13132 1 35 0 0
null 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 null CURSOR CURSOR 1941 1 0 0 0
null 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 null CURSOR NOT LOADED 0 1 30 0 0
null 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 null CURSOR CURSOR 1566 1 0 0 0