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