V$OBJECT_USAGE | INDEX_NAME |
| TABLE_NAME |
| MONITORING |
| USED |
| START_MONITORING |
| END_MONITORING |
V_$ACCESS | SID |
| OWNER |
| OBJECT |
| TYPE |
V_$ACTIVE_INSTANCES | INST_NUMBER |
| INST_NAME |
V_$ACTIVE_SESS_POOL_MTH | NAME |
V_$AQ | QID |
| WAITING |
| READY |
| EXPIRED |
| TOTAL_WAIT |
| AVERAGE_WAIT |
V_$AQ1 | QID |
| WAITING |
| READY |
| EXPIRED |
| TOTAL_CONSUMERS |
| TOTAL_WAIT |
| AVERAGE_WAIT |
V_$ARCHIVE | GROUP # |
| THREAD# |
| SEQUENCE# |
| ISCURRENT |
| CURRENT |
| FIRST_CHANGE# |
V_$ARCHIVED_LOG | RECID |
| STAMP |
| NAME |
| DEST_ID |
| THREAD# |
| SEQUENCE# |
| RESETLOGS_CHANGE# |
| RESETLOGS_TIME |
| FIRST_CHANGE# |
| FIRST_TIME |
| NEXT_CHANGE# |
| NEXT_TIME |
| BLOCKS |
| BLOCK_SIZE |
| CREATOR |
| REGISTRAR |
| STANDBY_DEST |
| ARCHIVED |
| APPLIED |
| DELETED |
| STATUS |
| COMPLETION_TIME |
| DICTIONARY_BEGIN |
| DICTIONARY_END |
| END_OF_REDO |
| BACKUP_COUNT |
| ARCHIVAL_THREAD# |
| ACTIVATION# |
V_$ARCHIVE_DEST | DEST_ID |
| DEST_NAME |
| STATUS |
| BINDING |
| NAME_SPACE |
| TARGET |
| ARCHIVER |
| SCHEDULE |
| DESTINATION |
| LOG_SEQUENCE |
| REOPEN_SECS |
| DELAY_MINS |
| NET_TIMEOUT |
| PROCESS |
| REGISTER |
| FAIL_DATE |
| FAIL_SEQUENCE |
| FAIL_BLOCK |
| FAILURE_COUNT |
| MAX_FAILURE |
| ERROR |
| ALTERNATE |
| DEPENDENCY |
| REMOTE_TEMPLATE |
| QUOTA_SIZE |
| QUOTA_USED |
| MOUNTID |
| TRANSMIT_MODE |
| ASYNC_BLOCKS |
| AFFIRM |
| TYPE |
V_$ARCHIVE_DEST_STATUS | DEST_ID |
| DEST_NAME |
| STATUS |
| TYPE |
| DATABASE_MODE |
| RECOVERY_MODE |
| PROTECTION_MODE |
| DESTINATION |
| STANDBY_LOGFILE_COUNT |
| STANDBY_LOGFILE_ACTIVE |
| ARCHIVED_THREAD# |
| ARCHIVED_SEQ# |
| APPLIED_THREAD# |
| APPLIED_SEQ# |
| ERROR |
| SRL |
V_$ARCHIVE_GAP | THREAD# |
| LOW_SEQUENCE# |
| HIGH_SEQUENCE# |
V_$ARCHIVE_PROCESSES | PROCESS |
| STATUS |
| LOG_SEQUENCE |
| STATE |
V_$AW_CALC | AGGREGATE_CACHE_HITS |
| AGGREGATE_CACHE_MISSES |
| SESSION_CACHE_HITS |
| SESSION_CACHE_MISSES |
| POOL_HITS |
| POOL_MISSES |
| POOL_NEW_PAGES |
| POOL_RECLAIMED_PAGES |
| CACHE_WRITES |
| POOL_SIZE |
V_$AW_OLAP | SESSION_ID |
| AW_NUMBER |
| ATTACH_MODE |
| GENERATION |
| TEMP_SPACE_PAGES |
| TEMP_SPACE_READS |
| LOB_READS |
| POOL_CHANGED_PAGES |
| POOL_UNCHANGED_PAGES |
V_$AW_SESSION_INFO | CLIENT_TYPE |
| SESSION_STATE |
| SESSION_HANDLE |
| USERID |
| CURR_DML_COMMAND |
| PREV_DML_COMMAND |
| TOTAL_TRANSACTION |
| TOTAL_TRANSACTION_TIME |
| AVERAGE_TRANSACTION_TIME |
| TRANSACTION_CPU_TIME |
| TOTAL_TRANSACTION_CPU_TIME |
| AVERAGE_TRANSACTION_CPU_TIME |
V_$BACKUP | FILE# |
| STATUS |
| CHANGE# |
| TIME |
V_$BACKUP_ASYNC_IO | SID |
| SERIAL |
| USE_COUNT |
| DEVICE_TYPE |
| TYPE |
| STATUS |
| FILENAME |
| SET_COUNT |
| SET_STAMP |
| BUFFER_SIZE |
| BUFFER_COUNT |
| TOTAL_BYTES |
| OPEN_TIME |
| CLOSE_TIME |
| ELAPSED_TIME |
| MAXOPENFILES |
| BYTES |
| EFFECTIVE_BYTES_PER_SECOND |
| IO_COUNT |
| READY |
| SHORT_WAITS |
| SHORT_WAIT_TIME_TOTAL |
| SHORT_WAIT_TIME_MAX |
| LONG_WAITS |
| LONG_WAIT_TIME_TOTAL |
| LONG_WAIT_TIME_MAX |
V_$BACKUP_CORRUPTION | RECID |
| STAMP |
| SET_STAMP |
| SET_COUNT |
| PIECE# |
| FILE# |
| BLOCK# |
| BLOCKS |
| CORRUPTION_CHANGE# |
| MARKED_CORRUPT |
| CORRUPTION_TYPE |
V_$BACKUP_DATAFILE | RECID |
| STAMP |
| SET_STAMP |
| SET_COUNT |
| FILE# |
| CREATION_CHANGE# |
| CREATION_TIME |
| RESETLOGS_CHANGE# |
| RESETLOGS_TIME |
| INCREMENTAL_LEVEL |
| INCREMENTAL_CHANGE# |
| CHECKPOINT_CHANGE# |
| CHECKPOINT_TIME |
| ABSOLUTE_FUZZY_CHANGE# |
| MARKED_CORRUPT |
| MEDIA_CORRUPT |
| LOGICALLY_CORRUPT |
| DATAFILE_BLOCKS |
| BLOCKS |
| BLOCK_SIZE |
| OLDEST_OFFLINE_RANGE |
| COMPLETION_TIME |
| CONTROLFILE_TYPE |
V_$BACKUP_DEVICE | DEVICE_TYPE |
| DEVICE_NAME |
V_$BACKUP_PIECE | RECID |
| STAMP |
| SET_STAMP |
| SET_COUNT |
| PIECE# |
| COPY# |
| DEVICE_TYPE |
| HANDLE |
| COMMENTS |
| MEDIA |
| MEDIA_POOL |
| CONCUR |
| TAG |
| STATUS |
| START_TIME |
| COMPLETION_TIME |
| ELAPSED_SECONDS |
| DELETED |
V_$BACKUP_REDOLOG | RECID |
| STAMP |
| SET_STAMP |
| SET_COUNT |
| THREAD# |
| SEQUENCE# |
| RESETLOGS_CHANGE# |
| RESETLOGS_TIME |
| FIRST_CHANGE# |
| FIRST_TIME |
| NEXT_CHANGE# |
| NEXT_TIME |
| BLOCKS |
| BLOCK_SIZE |
V_$BACKUP_SET | RECID |
| STAMP |
| SET_STAMP |
| SET_COUNT |
| BACKUP_TYPE |
| CONTROLFILE_INCLUDED |
| INCREMENTAL_LEVEL |
| PIECES |
| START_TIME |
| COMPLETION_TIME |
| ELAPSED_SECONDS |
| BLOCK_SIZE |
| INPUT_FILE_SCAN_ONLY |
| KEEP |
| KEEP_UNTIL |
| KEEP_OPTIONS |
V_$BACKUP_SPFILE | RECID |
| STAMP |
| SET_STAMP |
| SET_COUNT |
| MODIFICATION_TIME |
| BYTES |
| COMPLETION_TIME |
V_$BACKUP_SYNC_IO | SID |
| SERIAL |
| USE_COUNT |
| DEVICE_TYPE |
| TYPE |
| STATUS |
| FILENAME |
| SET_COUNT |
| SET_STAMP |
| BUFFER_SIZE |
| BUFFER_COUNT |
| TOTAL_BYTES |
| OPEN_TIME |
| CLOSE_TIME |
| ELAPSED_TIME |
| MAXOPENFILES |
| BYTES |
| EFFECTIVE_BYTES_PER_SECOND |
| IO_COUNT |
| IO_TIME_TOTAL |
| IO_TIME_MAX |
| DISCRETE_BYTES_PER_SECOND |
V_$BGPROCESS | PADDR |
| NAME |
| DESCRIPTION |
| ERROR |
V_$BH | FILE# |
| BLOCK# |
| CLASS# |
| STATUS |
| XNC |
| FORCED_READS |
| FORCED_WRITES |
| LOCK_ELEMENT_ADDR |
| LOCK_ELEMENT_NAME |
| LOCK_ELEMENT_CLASS |
| DIRTY |
| TEMP |
| PING |
| STALE |
| DIRECT |
| NEW |
| OBJD |
| TS# |
V_$BSP | CR_REQUESTS |
| CURRENT_REQUESTS |
| DATA_REQUESTS |
| UNDO_REQUESTS |
| TX_REQUESTS |
| CURRENT_RESULTS |
| PRIVATE_RESULTS |
| ZERO_RESULTS |
| DISK_READ_RESULTS |
| FAIL_RESULTS |
| FAIRNESS_DOWN_CONVERTS |
| FAIRNESS_CLEARS |
| FREE_LOCK_ELEMENTS |
| FLUSHES |
| FLUSHES_QUEUED |
| FLUSH_QUEUE_FULL |
| FLUSH_MAX_TIME |
| LIGHT_WORKS |
| ERRORS |
V_$BUFFER_POOL | BUFFERS |
| TARGET_SIZE |
| TARGET_BUFFERS |
| PREV_SIZE |
| PREV_BUFFERS |
| LO_BNUM |
| HI_BNUM |
| LO_SETID |
| HI_SETID |
| SET_COUNT |
| ID |
| NAME |
| BLOCK_SIZE |
| RESIZE_STATE |
| CURRENT_SIZE |
V_$BUFFER_POOL_STATISTICS | ID |
| NAME |
| BLOCK_SIZE |
| SET_MSIZE |
| CNUM_REPL |
| CNUM_WRITE |
| CNUM_SET |
| BUF_GOT |
| SUM_WRITE |
| SUM_SCAN |
| FREE_BUFFER_WAIT |
| WRITE_COMPLETE_WAIT |
| BUFFER_BUSY_WAIT |
| FREE_BUFFER_INSPECTED |
| DIRTY_BUFFERS_INSPECTED |
| DB_BLOCK_CHANGE |
| DB_BLOCK_GETS |
| CONSISTENT_GETS |
| PHYSICAL_READS |
| PHYSICAL_WRITES |
V_$CIRCUIT | CIRCUIT |
| DISPATCHER |
| SERVER |
| WAITER |
| SADDR |
| STATUS |
| QUEUE |
| MESSAGE0 |
| MESSAGE1 |
| MESSAGE2 |
| MESSAGE3 |
| MESSAGES |
| BYTES |
| BREAKS |
| PRESENTATION |
| PCIRCUIT |
V_$CLASS_CACHE_TRANSFER | CLASS |
| X_2_NULL |
| X_2_NULL_FORCED_WRITE |
| X_2_NULL_FORCED_STALE |
| X_2_S |
| X_2_S_FORCED_WRITE |
| S_2_NULL |
| S_2_NULL_FORCED_STALE |
| NULL_2_X |
| S_2_X |
| NULL_2_S |
V_$CLASS_PING | CLASS |
| X_2_NULL |
| X_2_NULL_FORCED_WRITE |
| X_2_NULL_FORCED_STALE |
| X_2_S |
| X_2_S_FORCED_WRITE |
| X_2_SSX |
| X_2_SSX_FORCED_WRITE |
| S_2_NULL |
| S_2_NULL_FORCED_STALE |
| SS_2_NULL |
| SS_2_RLS |
| OP_2_SS |
| NULL_2_X |
| S_2_X |
| SSX_2_X |
| NULL_2_S |
| NULL_2_SS |
V_$COMPATIBILITY | TYPE_ID |
| RELEASE |
| DESCRIPTION |
V_$COMPATSEG | TYPE_ID |
| RELEASE |
| UPDATED |
V_$CONTEXT | NAMESPACE |
| ATTRIBUTE |
| VALUE |
V_$CONTROLFILE | STATUS |
| NAME |
V_$CONTROLFILE_RECORD_SECTION | TYPE |
| RECORD_SIZE |
| RECORDS_TOTAL |
| RECORDS_USED |
| FIRST_INDEX |
| LAST_INDEX |
| LAST_RECID |
V_$COPY_CORRUPTION | RECID |
| STAMP |
| COPY_RECID |
| COPY_STAMP |
| FILE# |
| BLOCK# |
| BLOCKS |
| CORRUPTION_CHANGE# |
| MARKED_CORRUPT |
| CORRUPTION_TYPE |
V_$CR_BLOCK_SERVER | CR_REQUESTS |
| CURRENT_REQUESTS |
| DATA_REQUESTS |
| UNDO_REQUESTS |
| TX_REQUESTS |
| CURRENT_RESULTS |
| PRIVATE_RESULTS |
| ZERO_RESULTS |
| DISK_READ_RESULTS |
| FAIL_RESULTS |
| FAIRNESS_DOWN_CONVERTS |
| FAIRNESS_CLEARS |
| FREE_GC_ELEMENTS |
| FLUSHES |
| FLUSHES_QUEUED |
| FLUSH_QUEUE_FULL |
| FLUSH_MAX_TIME |
| LIGHT_WORKS |
| ERRORS |
V_$DATABASE | DBID |
| NAME |
| CREATED |
| RESETLOGS_CHANGE# |
| RESETLOGS_TIME |
| PRIOR_RESETLOGS_CHANGE# |
| PRIOR_RESETLOGS_TIME |
| LOG_MODE |
| CHECKPOINT_CHANGE# |
| ARCHIVE_CHANGE# |
| CONTROLFILE_TYPE |
| CONTROLFILE_CREATED |
| CONTROLFILE_SEQUENCE# |
| CONTROLFILE_CHANGE# |
| CONTROLFILE_TIME |
| OPEN_RESETLOGS |
| VERSION_TIME |
| OPEN_MODE |
| PROTECTION_MODE |
| PROTECTION_LEVEL |
| REMOTE_ARCHIVE |
| ACTIVATION# |
| DATABASE_ROLE |
| ARCHIVELOG_CHANGE# |
| SWITCHOVER_STATUS |
| DATAGUARD_BROKER |
| GUARD_STATUS |
| SUPPLEMENTAL_LOG_DATA_MIN |
| SUPPLEMENTAL_LOG_DATA_PK |
| SUPPLEMENTAL_LOG_DATA_UI |
| FORCE_LOGGING |
V_$DATABASE_BLOCK_CORRUPTION | FILE# |
| BLOCK# |
| BLOCKS |
| CORRUPTION_CHANGE# |
| CORRUPTION_TYPE |
V_$DATABASE_INCARNATION | RESETLOGS_CHANGE# |
| RESETLOGS_TIME |
| PRIOR_RESETLOGS_CHANGE# |
| PRIOR_RESETLOGS_TIME |
V_$DATAFILE | FILE# |
| CREATION_CHANGE# |
| CREATION_TIME |
| TS# |
| RFILE# |
| STATUS |
| ENABLED |
| CHECKPOINT_CHANGE# |
| CHECKPOINT_TIME |
| UNRECOVERABLE_CHANGE# |
| UNRECOVERABLE_TIME |
| LAST_CHANGE# |
| LAST_TIME |
| OFFLINE_CHANGE# |
| ONLINE_CHANGE# |
| ONLINE_TIME |
| BYTES |
| BLOCKS |
| CREATE_BYTES |
| BLOCK_SIZE |
| NAME |
| PLUGGED_IN |
| BLOCK1_OFFSET |
| AUX_NAME |
V_$DATAFILE_COPY | TAG |
| FILE# |
| RFILE# |
| CREATION_CHANGE# |
| CREATION_TIME |
| RESETLOGS_CHANGE# |
| RESETLOGS_TIME |
| INCREMENTAL_LEVEL |
| CHECKPOINT_CHANGE# |
| CHECKPOINT_TIME |
| ABSOLUTE_FUZZY_CHANGE# |
| RECOVERY_FUZZY_CHANGE# |
| RECOVERY_FUZZY_TIME |
| ONLINE_FUZZY |
| BACKUP_FUZZY |
| MARKED_CORRUPT |
| MEDIA_CORRUPT |
| LOGICALLY_CORRUPT |
| BLOCKS |
| BLOCK_SIZE |
| OLDEST_OFFLINE_RANGE |
| DELETED |
| STATUS |
| COMPLETION_TIME |
| CONTROLFILE_TYPE |
| KEEP |
| KEEP_UNTIL |
| KEEP_OPTIONS |
| SCANNED |
| RECID |
| STAMP |
| NAME |
V_$DATAFILE_HEADER | FILE# |
| STATUS |
| ERROR |
| FORMAT |
| RECOVER |
| FUZZY |
| CREATION_CHANGE# |
| CREATION_TIME |
| TABLESPACE_NAME |
| TS# |
| RFILE# |
| RESETLOGS_CHANGE# |
| RESETLOGS_TIME |
| CHECKPOINT_CHANGE# |
| CHECKPOINT_TIME |
| CHECKPOINT_COUNT |
| BYTES |
| BLOCKS |
| NAME |
V_$DATAGUARD_STATUS | FACILITY |
| SEVERITY |
| DEST_ID |
| MESSAGE_NUM |
| ERROR_CODE |
| CALLOUT |
| TIMESTAMP |
| MESSAGE |
V_$DBFILE | FILE# |
| NAME |
V_$DBLINK | DB_LINK |
| OWNER_ID |
| LOGGED_ON |
| HETEROGENEOUS |
| PROTOCOL |
| OPEN_CURSORS |
| IN_TRANSACTION |
| UPDATE_SENT |
| COMMIT_POINT_STRENGTH |
V_$DB_CACHE_ADVICE | ID |
| NAME |
| BLOCK_SIZE |
| ADVICE_STATUS |
| SIZE_FOR_ESTIMATE |
| SIZE_FACTOR |
| BUFFERS_FOR_ESTIMATE |
| ESTD_PHYSICAL_READ_FACTOR |
| ESTD_PHYSICAL_READS |
V_$DB_OBJECT_CACHE | OWNER |
| NAME |
| DB_LINK |
| NAMESPACE |
| TYPE |
| SHARABLE_MEM |
| LOADS |
| EXECUTIONS |
| LOCKS |
| PINS |
| KEPT |
| CHILD_LATCH |
V_$DB_PIPES | OWNERID |
| NAME |
| TYPE |
| PIPE_SIZE |
V_$DELETED_OBJECT | RECID |
| STAMP |
| TYPE |
| OBJECT_RECID |
| OBJECT_STAMP |
| OBJECT_DATA |
V_$DISPATCHER | NAME |
| NETWORK |
| PADDR |
| STATUS |
| ACCEPT |
| MESSAGES |
| BYTES |
| BREAKS |
| OWNED |
| CREATED |
| IDLE |
| BUSY |
| LISTENER |
| CONF_INDX |
V_$DISPATCHER_RATE | AVG_EVENT_RATE |
| AVG_EVENTS_PER_LOOP |
| AVG_MSG_RATE |
| AVG_SVR_BUF_RATE |
| AVG_SVR_BYTE_RATE |
| AVG_SVR_BYTE_PER_BUF |
| AVG_CLT_BUF_RATE |
| AVG_CLT_BYTE_RATE |
| AVG_CLT_BYTE_PER_BUF |
| AVG_BUF_RATE |
| AVG_BYTE_RATE |
| AVG_BYTE_PER_BUF |
| AVG_IN_CONNECT_RATE |
| AVG_OUT_CONNECT_RATE |
| AVG_RECONNECT_RATE |
| TTL_LOOPS |
| TTL_MSG |
| TTL_SVR_BUF |
| TTL_CLT_BUF |
| TTL_BUF |
| TTL_IN_CONNECT |
| TTL_OUT_CONNECT |
| TTL_RECONNECT |
| SCALE_LOOPS |
| SCALE_MSG |
| SCALE_SVR_BUF |
| SCALE_CLT_BUF |
| SCALE_BUF |
| SCALE_IN_CONNECT |
| SCALE_OUT_CONNECT |
| SCALE_RECONNECT |
| NAME |
| PADDR |
| CUR_LOOP_RATE |
| CUR_EVENT_RATE |
| CUR_EVENTS_PER_LOOP |
| CUR_MSG_RATE |
| CUR_SVR_BUF_RATE |
| CUR_SVR_BYTE_RATE |
| CUR_SVR_BYTE_PER_BUF |
| CUR_CLT_BUF_RATE |
| CUR_CLT_BYTE_RATE |
| CUR_CLT_BYTE_PER_BUF |
| CUR_BUF_RATE |
| CUR_BYTE_RATE |
| CUR_BYTE_PER_BUF |
| CUR_IN_CONNECT_RATE |
| CUR_OUT_CONNECT_RATE |
| CUR_RECONNECT_RATE |
| MAX_LOOP_RATE |
| MAX_EVENT_RATE |
| MAX_EVENTS_PER_LOOP |
| MAX_MSG_RATE |
| MAX_SVR_BUF_RATE |
| MAX_SVR_BYTE_RATE |
| MAX_SVR_BYTE_PER_BUF |
| MAX_CLT_BUF_RATE |
| MAX_CLT_BYTE_RATE |
| MAX_CLT_BYTE_PER_BUF |
| MAX_BUF_RATE |
| MAX_BYTE_RATE |
| MAX_BYTE_PER_BUF |
| MAX_IN_CONNECT_RATE |
| MAX_OUT_CONNECT_RATE |
| MAX_RECONNECT_RATE |
| AVG_LOOP_RATE |
V_$DLM_ALL_LOCKS | LOCKP |
| GRANT_LEVEL |
| REQUEST_LEVEL |
| RESOURCE_NAME1 |
| RESOURCE_NAME2 |
| PID |
| TRANSACTION_ID0 |
| TRANSACTION_ID1 |
| GROUP_ID |
| OPEN_OPT_DEADLOCK |
| OPEN_OPT_PERSISTENT |
| OPEN_OPT_PROCESS_OWNED |
| OPEN_OPT_NO_XID |
| CONVERT_OPT_GETVALUE |
| CONVERT_OPT_PUTVALUE |
| CONVERT_OPT_NOVALUE |
| CONVERT_OPT_DUBVALUE |
| CONVERT_OPT_NOQUEUE |
| CONVERT_OPT_EXPRESS |
| CONVERT_OPT_NODEADLOCKWAIT |
| CONVERT_OPT_NODEADLOCKBLOCK |
| WHICH_QUEUE |
| LOCKSTATE |
| AST_EVENT0 |
| OWNER_NODE |
| BLOCKED |
| BLOCKER |
V_$DLM_CONVERT_LOCAL | INST_ID |
| CONVERT_TYPE |
| AVERAGE_CONVERT_TIME |
| CONVERT_COUNT |
V_$DLM_CONVERT_REMOTE | INST_ID |
| CONVERT_TYPE |
| AVERAGE_CONVERT_TIME |
| CONVERT_COUNT |
V_$DLM_LATCH | IMMEDIATE_GETS |
| IMMEDIATE_MISSES |
| WAITERS_WOKEN |
| WAITS_HOLDING_LATCH |
| SPIN_GETS |
| SLEEP1 |
| SLEEP2 |
| SLEEP3 |
| SLEEP4 |
| SLEEP5 |
| SLEEP6 |
| SLEEP7 |
| SLEEP8 |
| SLEEP9 |
| SLEEP10 |
| SLEEP11 |
| WAIT_TIME |
| ADDR |
| LATCH# |
| LEVEL# |
| NAME |
| GETS |
| MISSES |
| SLEEPS |
V_$DLM_LOCKS | LOCKP |
| GRANT_LEVEL |
| REQUEST_LEVEL |
| RESOURCE_NAME1 |
| RESOURCE_NAME2 |
| PID |
| TRANSACTION_ID0 |
| TRANSACTION_ID1 |
| GROUP_ID |
| OPEN_OPT_DEADLOCK |
| OPEN_OPT_PERSISTENT |
| OPEN_OPT_PROCESS_OWNED |
| OPEN_OPT_NO_XID |
| CONVERT_OPT_GETVALUE |
| CONVERT_OPT_PUTVALUE |
| CONVERT_OPT_NOVALUE |
| CONVERT_OPT_DUBVALUE |
| CONVERT_OPT_NOQUEUE |
| CONVERT_OPT_EXPRESS |
| CONVERT_OPT_NODEADLOCKWAIT |
| CONVERT_OPT_NODEADLOCKBLOCK |
| WHICH_QUEUE |
| LOCKSTATE |
| AST_EVENT0 |
| OWNER_NODE |
| BLOCKED |
| BLOCKER |
V_$DLM_MISC | STATISTIC# |
| NAME |
| VALUE |
V_$DLM_RESS | RESP |
| RESOURCE_NAME |
| ON_CONVERT_Q |
| ON_GRANT_Q |
| PERSISTENT_RES |
| MASTER_NODE |
| NEXT_CVT_LEVEL |
| VALUE_BLK_STATE |
| VALUE_BLK |
V_$DLM_TRAFFIC_CONTROLLER | LOCAL_NID |
| REMOTE_NID |
| REMOTE_RID |
| REMOTE_INC |
| TCKT_AVAIL |
| TCKT_LIMIT |
| TCKT_RCVD |
| TCKT_WAIT |
| SND_SEQ_NO |
| RCV_SEQ_NO |
| SND_Q_LEN |
| SND_Q_MAX |
| SND_Q_TOT |
| SND_Q_TM_BASE |
| SND_Q_TM_WRAP |
| STATUS |
| SND_PROXY |
V_$ENABLEDPRIVS | PRIV_NUMBER |
V_$ENQUEUE_LOCK | ADDR |
| KADDR |
| SID |
| TYPE |
| ID1 |
| ID2 |
| LMODE |
| REQUEST |
| CTIME |
| BLOCK |
V_$ENQUEUE_STAT | INST_ID |
| EQ_TYPE |
| TOTAL_REQ# |
| TOTAL_WAIT# |
| SUCC_REQ# |
| FAILED_REQ# |
| CUM_WAIT_TIME |
V_$EVENT_NAME | EVENT# |
| NAME |
| PARAMETER1 |
| PARAMETER2 |
| PARAMETER3 |
V_$EXECUTION | PID |
| DEPTH |
| FUNCTION |
| TYPE |
| NVALS |
| VAL1 |
| VAL2 |
| SEQH |
| SEQL |
V_$FAST_START_SERVERS | STATE |
| UNDOBLOCKSDONE |
| PID |
V_$FAST_START_TRANSACTIONS | USN |
| SLT |
| SEQ |
| STATE |
| UNDOBLOCKSDONE |
| UNDOBLOCKSTOTAL |
| PID |
| CPUTIME |
| PARENTUSN |
| PARENTSLT |
| PARENTSEQ |
V_$FILESTAT | FILE# |
| PHYRDS |
| PHYWRTS |
| PHYBLKRD |
| PHYBLKWRT |
| SINGLEBLKRDS |
| READTIM |
| WRITETIM |
| SINGLEBLKRDTIM |
| AVGIOTIM |
| LSTIOTIM |
| MINIOTIM |
| MAXIORTM |
| MAXIOWTM |
V_$FILESTATXS | TSNAME |
| FILENAME |
| PHYRDS |
| PHYWRTS |
| READTIM |
| WRITETIM |
| PHYBLKRD |
| PHYBLKWRT |
| WAIT_COUNT |
| TIME |
V_$FILE_CACHE_TRANSFER | FILE_NUMBER |
| X_2_NULL |
| X_2_NULL_FORCED_WRITE |
| X_2_NULL_FORCED_STALE |
| X_2_S |
| X_2_S_FORCED_WRITE |
| S_2_NULL |
| S_2_NULL_FORCED_STALE |
| RBR |
| RBR_FORCED_WRITE |
| RBR_FORCED_STALE |
| NULL_2_X |
| S_2_X |
| NULL_2_S |
| CR_TRANSFERS |
| CUR_TRANSFERS |
V_$FILE_PING | FILE_NUMBER |
| FREQUENCY |
| X_2_NULL |
| X_2_NULL_FORCED_WRITE |
| X_2_NULL_FORCED_STALE |
| X_2_S |
| X_2_S_FORCED_WRITE |
| X_2_SSX |
| X_2_SSX_FORCED_WRITE |
| S_2_NULL |
| S_2_NULL_FORCED_STALE |
| SS_2_NULL |
| SS_2_RLS |
| WRB |
| WRB_FORCED_WRITE |
| RBR |
| RBR_FORCED_WRITE |
| RBR_FORCED_STALE |
| CBR |
| CBR_FORCED_WRITE |
| NULL_2_X |
| S_2_X |
| SSX_2_X |
| NULL_2_S |
| NULL_2_SS |
| OP_2_SS |
V_$FIXED_TABLE | NAME |
| OBJECT_ID |
| TYPE |
| TABLE_NUM |
V_$FIXED_VIEW_DEFINITION | VIEW_NAME |
| VIEW_DEFINITION |
V_$GCSHVMASTER_INFO | HV_ID |
| CURRENT_MASTER |
| PREVIOUS_MASTER |
| REMASTER_CNT |
V_$GCSPFMASTER_INFO | FILE_ID |
| CURRENT_MASTER |
| PREVIOUS_MASTER |
| REMASTER_CNT |
V_$GC_ELEMENT | GC_ELEMENT_ADDR |
| INDX |
| CLASS |
| GC_ELEMENT_NAME |
| MODE_HELD |
| BLOCK_COUNT |
| RELEASING |
| ACQUIRING |
| WRITING |
| RECOVERING |
| LOCAL |
| FLAGS |
V_$GC_ELEMENTS_WITH_COLLISIONS | GC_ELEMENT_ADDR |
V_$GES_BLOCKING_ENQUEUE | HANDLE |
| GRANT_LEVEL |
| REQUEST_LEVEL |
| RESOURCE_NAME1 |
| RESOURCE_NAME2 |
| PID |
| TRANSACTION_ID0 |
| TRANSACTION_ID1 |
| GROUP_ID |
| OPEN_OPT_DEADLOCK |
| OPEN_OPT_PERSISTENT |
| OPEN_OPT_PROCESS_OWNED |
| OPEN_OPT_NO_XID |
| CONVERT_OPT_GETVALUE |
| CONVERT_OPT_PUTVALUE |
| CONVERT_OPT_NOVALUE |
| CONVERT_OPT_DUBVALUE |
| CONVERT_OPT_NOQUEUE |
| CONVERT_OPT_EXPRESS |
| CONVERT_OPT_NODEADLOCKWAIT |
| CONVERT_OPT_NODEADLOCKBLOCK |
| WHICH_QUEUE |
| STATE |
| AST_EVENT0 |
| OWNER_NODE |
| BLOCKED |
| BLOCKER |
V_$GES_ENQUEUE | HANDLE |
| GRANT_LEVEL |
| REQUEST_LEVEL |
| RESOURCE_NAME1 |
| RESOURCE_NAME2 |
| PID |
| TRANSACTION_ID0 |
| TRANSACTION_ID1 |
| GROUP_ID |
| OPEN_OPT_DEADLOCK |
| OPEN_OPT_PERSISTENT |
| OPEN_OPT_PROCESS_OWNED |
| OPEN_OPT_NO_XID |
| CONVERT_OPT_GETVALUE |
| CONVERT_OPT_PUTVALUE |
| CONVERT_OPT_NOVALUE |
| CONVERT_OPT_DUBVALUE |
| CONVERT_OPT_NOQUEUE |
| CONVERT_OPT_EXPRESS |
| CONVERT_OPT_NODEADLOCKWAIT |
| CONVERT_OPT_NODEADLOCKBLOCK |
| WHICH_QUEUE |
| STATE |
| AST_EVENT0 |
| OWNER_NODE |
| BLOCKED |
| BLOCKER |
V_$GLOBALCONTEXT | NAMESPACE |
| ATTRIBUTE |
| VALUE |
| USERNAME |
| CLIENT_IDENTIFIER |
V_$GLOBAL_BLOCKED_LOCKS | ADDR |
| KADDR |
| SID |
| TYPE |
| ID1 |
| ID2 |
| LMODE |
| REQUEST |
| CTIME |
V_$GLOBAL_TRANSACTION | FORMATID |
| GLOBALID |
| BRANCHID |
| BRANCHES |
| REFCOUNT |
| PREPARECOUNT |
| STATE |
| FLAGS |
| COUPLING |
V_$HS_AGENT | AGENT_ID |
| MACHINE |
| PROCESS |
| PROGRAM |
| OSUSER |
| STARTTIME |
| AGENT_TYPE |
| FDS_CLASS_ID |
| FDS_INST_ID |
V_$HS_PARAMETER | HS_SESSION_ID |
| PARAMETER |
| VALUE |
| SOURCE |
| ENV |
V_$HS_SESSION | HS_SESSION_ID |
| AGENT_ID |
| SID |
| DB_LINK |
| DB_LINK_OWNER |
| STARTTIME |
V_$HVMASTER_INFO | HV_ID |
| CURRENT_MASTER |
| PREVIOUS_MASTER |
| REMASTER_CNT |
V_$INDEXED_FIXED_COLUMN | TABLE_NAME |
| INDEX_NUMBER |
| COLUMN_NAME |
| COLUMN_POSITION |
V_$INSTANCE | INSTANCE_NUMBER |
| INSTANCE_NAME |
| HOST_NAME |
| VERSION |
| STARTUP_TIME |
| STATUS |
| PARALLEL |
| THREAD# |
| ARCHIVER |
| LOG_SWITCH_WAIT |
| LOGINS |
| SHUTDOWN_PENDING |
| DATABASE_STATUS |
| INSTANCE_ROLE |
| ACTIVE_STATE |
V_$INSTANCE_RECOVERY | RECOVERY_ESTIMATED_IOS |
| ACTUAL_REDO_BLKS |
| TARGET_REDO_BLKS |
| LOG_FILE_SIZE_REDO_BLKS |
| LOG_CHKPT_TIMEOUT_REDO_BLKS |
| LOG_CHKPT_INTERVAL_REDO_BLKS |
| FAST_START_IO_TARGET_REDO_BLKS |
| TARGET_MTTR |
| ESTIMATED_MTTR |
| CKPT_BLOCK_WRITES |
V_$LATCH | ADDR |
| LATCH# |
| LEVEL# |
| NAME |
| GETS |
| MISSES |
| SLEEPS |
| IMMEDIATE_GETS |
| IMMEDIATE_MISSES |
| WAITERS_WOKEN |
| WAITS_HOLDING_LATCH |
| SPIN_GETS |
| SLEEP1 |
| SLEEP2 |
| SLEEP3 |
| SLEEP4 |
| SLEEP5 |
| SLEEP6 |
| SLEEP7 |
| SLEEP8 |
| SLEEP9 |
| SLEEP10 |
| SLEEP11 |
| WAIT_TIME |
V_$LATCHHOLDER | PID |
| SID |
| LADDR |
| NAME |
V_$LATCHNAME | LATCH# |
| NAME |
V_$LATCH_CHILDREN | ADDR |
| LATCH# |
| CHILD# |
| LEVEL# |
| NAME |
| GETS |
| MISSES |
| SLEEPS |
| IMMEDIATE_GETS |
| IMMEDIATE_MISSES |
| WAITERS_WOKEN |
| WAITS_HOLDING_LATCH |
| SPIN_GETS |
| SLEEP1 |
| SLEEP2 |
| SLEEP3 |
| SLEEP4 |
| SLEEP5 |
| SLEEP6 |
| SLEEP7 |
| SLEEP8 |
| SLEEP9 |
| SLEEP10 |
| SLEEP11 |
| WAIT_TIME |
V_$LATCH_MISSES | PARENT_NAME |
| WHERE |
| NWFAIL_COUNT |
| SLEEP_COUNT |
| WTR_SLP_COUNT |
| LONGHOLD_COUNT |
| LOCATION |
V_$LATCH_PARENT | ADDR |
| LATCH# |
| LEVEL# |
| NAME |
| GETS |
| MISSES |
| SLEEPS |
| IMMEDIATE_GETS |
| IMMEDIATE_MISSES |
| WAITERS_WOKEN |
| WAITS_HOLDING_LATCH |
| SPIN_GETS |
| SLEEP1 |
| SLEEP2 |
| SLEEP3 |
| SLEEP4 |
| SLEEP5 |
| SLEEP6 |
| SLEEP7 |
| SLEEP8 |
| SLEEP9 |
| SLEEP10 |
| SLEEP11 |
| WAIT_TIME |
V_$LIBRARYCACHE | NAMESPACE |
| GETS |
| GETHITS |
| GETHITRATIO |
| PINS |
| PINHITS |
| PINHITRATIO |
| RELOADS |
| INVALIDATIONS |
| DLM_LOCK_REQUESTS |
| DLM_PIN_REQUESTS |
| DLM_PIN_RELEASES |
| DLM_INVALIDATION_REQUESTS |
| DLM_INVALIDATIONS |
V_$LIBRARY_CACHE_MEMORY | LC_NAMESPACE |
| LC_INUSE_MEMORY_OBJECTS |
| LC_INUSE_MEMORY_SIZE |
| LC_FREEABLE_MEMORY_OBJECTS |
| LC_FREEABLE_MEMORY_SIZE |
V_$LICENSE | SESSIONS_MAX |
| SESSIONS_WARNING |
| SESSIONS_CURRENT |
| SESSIONS_HIGHWATER |
| USERS_MAX |
V_$LOADISTAT | OWNER |
| TABNAME |
| INDEXNAME |
| SUBNAME |
| MESSAGE |
V_$LOADPSTAT | OWNER |
| TABNAME |
| PARTNAME |
| LOADED |
V_$LOCK | ADDR |
| KADDR |
| SID |
| TYPE |
| ID1 |
| ID2 |
| LMODE |
| REQUEST |
| CTIME |
| BLOCK |
V_$LOCKED_OBJECT | ORACLE_USERNAME |
| OS_USER_NAME |
| PROCESS |
| LOCKED_MODE |
| XIDUSN |
| XIDSLOT |
| XIDSQN |
| OBJECT_ID |
| SESSION_ID |
V_$LOCKS_WITH_COLLISIONS | LOCK_ELEMENT_ADDR |
V_$LOCK_ACTIVITY | TO_VAL |
| ACTION_VAL |
| COUNTER |
| FROM_VAL |
V_$LOCK_ELEMENT | LOCK_ELEMENT_ADDR |
| INDX |
| CLASS |
| LOCK_ELEMENT_NAME |
| MODE_HELD |
| BLOCK_COUNT |
| RELEASING |
| ACQUIRING |
| INVALID |
| FLAGS |
V_$LOG | GROUP# |
| THREAD# |
| SEQUENCE# |
| BYTES |
| MEMBERS |
| ARCHIVED |
| STATUS |
| FIRST_CHANGE# |
| FIRST_TIME |
V_$LOGFILE | GROUP# |
| STATUS |
| TYPE |
| MEMBER |
V_$LOGHIST | THREAD# |
| SEQUENCE# |
| FIRST_CHANGE# |
| FIRST_TIME |
| SWITCH_CHANGE# |
V_$LOGMNR_CALLBACK | STATE |
| TYPE |
| CAPABILITY |
V_$LOGMNR_CONTENTS | SCN |
| CSCN |
| TIMESTAMP |
| COMMIT_TIMESTAMP |
| THREAD# |
| LOG_ID |
| XIDUSN |
| XIDSLT |
| XIDSQN |
| PXIDUSN |
| PXIDSLT |
| PXIDSQN |
| RBASQN |
| RBABLK |
| RBABYTE |
| UBAFIL |
| UBABLK |
| UBAREC |
| UBASQN |
| ABS_FILE# |
| REL_FILE# |
| DATA_BLK# |
| DATA_OBJ# |
| DATA_OBJD# |
| SEG_OWNER |
| SEG_NAME |
| SEG_TYPE |
| SEG_TYPE_NAME |
| TABLE_SPACE |
| ROW_ID |
| SESSION# |
| SERIAL# |
| USERNAME |
| SESSION_INFO |
| TX_NAME |
| ROLLBACK |
| OPERATION |
| OPERATION_CODE |
| SQL_REDO |
| SQL_UNDO |
| RS_ID |
| SEQUENCE# |
| SSN |
| CSF |
| INFO |
| STATUS |
| REDO_VALUE |
| UNDO_VALUE |
| SQL_COLUMN_TYPE |
| SQL_COLUMN_NAME |
| REDO_LENGTH |
| REDO_OFFSET |
| UNDO_LENGTH |
| UNDO_OFFSET |
V_$LOGMNR_DICTIONARY | TIMESTAMP |
| DB_ID |
| DB_NAME |
| FILENAME |
| DICTIONARY_SCN |
| RESET_SCN |
| RESET_SCN_TIME |
| ENABLED_THREAD_MAP |
| INFO |
| STATUS |
V_$LOGMNR_LOGFILE | LOG_ID |
| FILENAME |
| LOW_TIME |
| NEXT_TIME |
| DB_ID |
| DB_NAME |
| RESET_SCNWRP |
| RESET_SCNBAS |
| RESET_SCN_TIME |
| THREAD_ID |
| THREAD_SQN |
| LOW_SCNWRP |
| LOW_SCNBAS |
| NEXT_SCNWRP |
| NEXT_SCNBAS |
| FILE_STATE |
V_$LOGMNR_LOGS | LOG_ID |
| FILENAME |
| LOW_TIME |
| HIGH_TIME |
| DB_ID |
| DB_NAME |
| RESET_SCN |
| RESET_SCN_TIME |
| THREAD_ID |
| THREAD_SQN |
| LOW_SCN |
| NEXT_SCN |
| DICTIONARY_BEGIN |
| DICTIONARY_END |
| INFO |
| STATUS |
V_$LOGMNR_PARAMETERS | END_SCN |
| INFO |
| STATUS |
| START_DATE |
| END_DATE |
| START_SCN |
V_$LOGMNR_PROCESS | PID |
| SPID |
| ROLE |
| USERNAME |
| SERIAL# |
| LATCHWAIT |
| LATCHSPIN |
V_$LOGMNR_REGION | MEMSTATE |
| STATE |
| OWNING_PROCESS |
V_$LOGMNR_SESSION | SESSION_ID |
| SESSION_NAME |
| SESSION_STATE |
| START_SCNWRP |
| START_SCNBAS |
| END_SCNWRP |
| END_SCNBAS |
| SPILL_SCNWRP |
| SPILL_SCNBAS |
| REQUIRED_SLAVE_NUM |
| EAGER_THRESHOLD |
| STOPMINING_THRESHOLD |
| MEMORY_SIZE |
| CLIENT_ID |
| DB_ID |
| RESET_SCNWRP |
| RESET_SCNBAS |
| CALLBACK_COUNT |
| SLAVE_COUNT |
V_$LOGMNR_STATS | SESSION_ID |
| NAME |
| VALUE |
V_$LOGMNR_TRANSACTION | XIDUSN |
| XIDSLT |
| XIDSQN |
| COMMIT_SCNWRP |
| COMMIT_SCNBAS |
| NUM_CHANGE_RECORD |
| FLAGS |
| CHUNK_INDEX |
| TOTAL_CHUNKS |
V_$LOGSTDBY | SERIAL# |
| LOGSTDBY_ID |
| PID |
| TYPE |
| STATUS_CODE |
| STATUS |
| HIGH_SCN |
V_$LOGSTDBY_STATS | NAME |
| VALUE |
V_$LOG_HISTORY | RECID |
| STAMP |
| THREAD# |
| SEQUENCE# |
| FIRST_CHANGE# |
| FIRST_TIME |
| NEXT_CHANGE# |
V_$MANAGED_STANDBY | PROCESS |
| PID |
| STATUS |
| CLIENT_PROCESS |
| CLIENT_PID |
| CLIENT_DBID |
| GROUP# |
| THREAD# |
| SEQUENCE# |
| BLOCK# |
| BLOCKS |
| DELAY_MINS |
| KNOWN_AGENTS |
| ACTIVE_AGENTS |
V_$MAP_COMP_LIST | ELEM_IDX |
| NUM_COMP |
| COMP1_NAME |
| COMP1_VAL |
| COMP2_NAME |
| COMP2_VAL |
| COMP3_NAME |
| COMP3_VAL |
| COMP4_NAME |
| COMP4_VAL |
| COMP5_NAME |
| COMP5_VAL |
V_$MAP_ELEMENT | ELEM_NAME |
| ELEM_IDX |
| ELEM_CFGID |
| ELEM_TYPE |
| ELEM_SIZE |
| ELEM_NSUBELEM |
| ELEM_DESCR |
| STRIPE_SIZE |
| LIB_IDX |
V_$MAP_EXT_ELEMENT | ELEM_IDX |
| NUM_ATTRB |
| ATTRB1_NAME |
| ATTRB1_VAL |
| ATTRB2_NAME |
| ATTRB2_VAL |
| ATTRB3_NAME |
| ATTRB3_VAL |
| ATTRB4_NAME |
| ATTRB4_VAL |
| ATTRB5_NAME |
| ATTRB5_VAL |
V_$MAP_FILE | FILE_MAP_IDX |
| FILE_CFGID |
| FILE_STATUS |
| FILE_NAME |
| FILE_TYPE |
| FILE_STRUCTURE |
| FILE_SIZE |
| FILE_NEXTS |
| LIB_IDX |
V_$MAP_FILE_EXTENT | FILE_MAP_IDX |
| EXT_NUM |
| EXT_ELEM_OFF |
| EXT_SIZE |
| EXT_FILE_OFF |
| EXT_TYPE |
| ELEM_IDX |
V_$MAP_FILE_IO_STACK | FILE_MAP_IDX |
| DEPTH |
| ELEM_IDX |
| CU_SIZE |
| STRIDE |
| NUM_CU |
| ELEM_OFFSET |
| FILE_OFFSET |
| DATA_TYPE |
| PARITY_POS |
| PARITY_PERIOD |
| ID |
| PARENT_ID |
V_$MAP_LIBRARY | LIB_IDX |
| LIB_NAME |
| VENDOR_NAME |
| PROTOCOL_NUM |
| VERSION_NUM |
| PATH_NAME |
| MAP_FILE |
| FILE_CFGID |
| MAP_ELEM |
| ELEM_CFGID |
| MAP_SYNC |
V_$MAP_SUBELEMENT | CHILD_IDX |
| PARENT_IDX |
| SUB_NUM |
| SUB_SIZE |
| ELEM_OFFSET |
| SUB_FLAGS |
V_$MAX_ACTIVE_SESS_TARGET_MTH | NAME |
V_$MLS_PARAMETERS | NUM |
| NAME |
| TYPE |
| VALUE |
| ISDEFAULT |
| ISSES_MODIFIABLE |
| ISSYS_MODIFIABLE |
| ISMODIFIED |
| ISADJUSTED |
| DESCRIPTION |
| UPDATE_COMMENT |
V_$MTS | MAXIMUM_CONNECTIONS |
| MAXIMUM_SESSIONS |
| SERVERS_STARTED |
| SERVERS_TERMINATED |
| SERVERS_HIGHWATER |
V_$MTTR_TARGET_ADVICE | MTTR_TARGET_FOR_ESTIMATE |
| ADVICE_STATUS |
| DIRTY_LIMIT |
| ESTD_CACHE_WRITES |
| ESTD_CACHE_WRITE_FACTOR |
| ESTD_TOTAL_WRITES |
| ESTD_TOTAL_WRITE_FACTOR |
| ESTD_TOTAL_IOS |
| ESTD_TOTAL_IO_FACTOR |
V_$MVREFRESH | SID |
| SERIAL# |
| CURRMVOWNER |
| CURRMVNAME |
V_$MYSTAT | SID |
| STATISTIC# |
| VALUE |
V_$NLS_PARAMETERS | PARAMETER |
| VALUE |
V_$NLS_VALID_VALUES | PARAMETER |
| VALUE |
V_$OBJECT_DEPENDENCY | FROM_ADDRESS |
| FROM_HASH |
| TO_OWNER |
| TO_NAME |
| TO_ADDRESS |
| TO_HASH |
| TO_TYPE |
V_$OBSOLETE_PARAMETER | NAME |
| ISSPECIFIED |
V_$OFFLINE_RANGE | RECID |
| STAMP |
| FILE# |
| OFFLINE_CHANGE# |
| ONLINE_CHANGE# |
| ONLINE_TIME |
V_$OPEN_CURSOR | SADDR |
| SID |
| USER_NAME |
| ADDRESS |
| HASH_VALUE |
| SQL_TEXT |
V_$OPTION | PARAMETER |
| VALUE |
V_$PARALLEL_DEGREE_LIMIT_MTH | NAME |
V_$PARAMETER | NUM |
| NAME |
| TYPE |
| VALUE |
| ISDEFAULT |
| ISSES_MODIFIABLE |
| ISSYS_MODIFIABLE |
| ISMODIFIED |
| ISADJUSTED |
| DESCRIPTION |
| UPDATE_COMMENT |
V_$PARAMETER2 | NUM |
| NAME |
| TYPE |
| VALUE |
| ISDEFAULT |
| ISSES_MODIFIABLE |
| ISSYS_MODIFIABLE |
| ISMODIFIED |
| ISADJUSTED |
| DESCRIPTION |
| ORDINAL |
| UPDATE_COMMENT |
V_$PGASTAT | NAME |
| VALUE |
| UNIT |
V_$PGA_TARGET_ADVICE | PGA_TARGET_FOR_ESTIMATE |
| PGA_TARGET_FACTOR |
| ADVICE_STATUS |
| BYTES_PROCESSED |
| ESTD_EXTRA_BYTES_RW |
| ESTD_PGA_CACHE_HIT_PERCENTAGE |
| ESTD_OVERALLOC_COUNT |
V_$PGA_TARGET_ADVICE_HISTOGRAM | PGA_TARGET_FOR_ESTIMATE |
| PGA_TARGET_FACTOR |
| ADVICE_STATUS |
| LOW_OPTIMAL_SIZE |
| HIGH_OPTIMAL_SIZE |
| ESTD_OPTIMAL_EXECUTIONS |
| ESTD_ONEPASS_EXECUTIONS |
| ESTD_MULTIPASSES_EXECUTIONS |
| ESTD_TOTAL_EXECUTIONS |
| IGNORED_WORKAREAS_COUNT |
V_$PQ_SESSTAT | STATISTIC |
| LAST_QUERY |
| SESSION_TOTAL |
V_$PQ_SLAVE | SLAVE_NAME |
| STATUS |
| SESSIONS |
| IDLE_TIME_CUR |
| BUSY_TIME_CUR |
| CPU_SECS_CUR |
| MSGS_SENT_CUR |
| MSGS_RCVD_CUR |
| IDLE_TIME_TOTAL |
| BUSY_TIME_TOTAL |
| CPU_SECS_TOTAL |
| MSGS_SENT_TOTAL |
| MSGS_RCVD_TOTAL |
V_$PQ_SYSSTAT | STATISTIC |
| VALUE |
V_$PQ_TQSTAT | DFO_NUMBER |
| TQ_ID |
| SERVER_TYPE |
| NUM_ROWS |
| BYTES |
| OPEN_TIME |
| AVG_LATENCY |
| WAITS |
| TIMEOUTS |
| PROCESS |
| INSTANCE |
V_$PROCESS | ADDR |
| PID |
| SPID |
| USERNAME |
| SERIAL# |
| TERMINAL |
| PROGRAM |
| TRACEID |
| BACKGROUND |
| LATCHWAIT |
| LATCHSPIN |
| PGA_USED_MEM |
| PGA_ALLOC_MEM |
| PGA_FREEABLE_MEM |
| PGA_MAX_MEM |
V_$PROXY_ARCHIVEDLOG | RECID |
| STAMP |
| DEVICE_TYPE |
| HANDLE |
| COMMENTS |
| MEDIA |
| MEDIA_POOL |
| STATUS |
| DELETED |
| THREAD# |
| SEQUENCE# |
| RESETLOGS_CHANGE# |
| RESETLOGS_TIME |
| FIRST_CHANGE# |
| FIRST_TIME |
| NEXT_CHANGE# |
| NEXT_TIME |
| BLOCKS |
| BLOCK_SIZE |
| START_TIME |
| COMPLETION_TIME |
| ELAPSED_SECONDS |
V_$PROXY_DATAFILE | RECID |
| STAMP |
| DEVICE_TYPE |
| HANDLE |
| COMMENTS |
| MEDIA |
| MEDIA_POOL |
| TAG |
| STATUS |
| DELETED |
| FILE# |
| CREATION_CHANGE# |
| CREATION_TIME |
| RESETLOGS_CHANGE# |
| RESETLOGS_TIME |
| CHECKPOINT_CHANGE# |
| CHECKPOINT_TIME |
| ABSOLUTE_FUZZY_CHANGE# |
| RECOVERY_FUZZY_CHANGE# |
| RECOVERY_FUZZY_TIME |
| INCREMENTAL_LEVEL |
| ONLINE_FUZZY |
| BACKUP_FUZZY |
| BLOCKS |
| BLOCK_SIZE |
| OLDEST_OFFLINE_RANGE |
| START_TIME |
| COMPLETION_TIME |
| ELAPSED_SECONDS |
| CONTROLFILE_TYPE |
| KEEP |
| KEEP_UNTIL |
| KEEP_OPTIONS |
V_$PWFILE_USERS | USERNAME |
| SYSDBA |
| SYSOPER |
V_$PX_PROCESS | SERVER_NAME |
| STATUS |
| PID |
| SPID |
| SID |
| SERIAL# |
V_$PX_PROCESS_SYSSTAT | STATISTIC |
| VALUE |
V_$PX_SESSION | SADDR |
| SID |
| SERIAL# |
| QCSID |
| QCSERIAL# |
| QCINST_ID |
| SERVER_GROUP |
| SERVER_SET |
| SERVER# |
| DEGREE |
| REQ_DEGREE |
V_$PX_SESSTAT | SADDR |
| SID |
| SERIAL# |
| QCSID |
| QCSERIAL# |
| QCINST_ID |
| SERVER_GROUP |
| SERVER_SET |
| SERVER# |
| DEGREE |
| REQ_DEGREE |
| STATISTIC# |
| VALUE |
V_$QUEUE | PADDR |
| TYPE |
| QUEUED |
| WAIT |
| TOTALQ |
V_$QUEUEING_MTH | NAME |
V_$RECOVERY_FILE_STATUS | FILENUM |
| FILENAME |
| STATUS |
V_$RECOVERY_LOG | THREAD# |
| SEQUENCE# |
| TIME |
| ARCHIVE_NAME |
V_$RECOVERY_PROGRESS | TYPE |
| ITEM |
| SOFAR |
| TOTAL |
V_$RECOVERY_STATUS | RECOVERY_CHECKPOINT |
| THREAD |
| SEQUENCE_NEEDED |
| SCN_NEEDED |
| TIME_NEEDED |
| PREVIOUS_LOG_NAME |
| PREVIOUS_LOG_STATUS |
| REASON |
V_$RECOVER_FILE | FILE# |
| ONLINE |
| ONLINE_STATUS |
| ERROR |
| CHANGE# |
| TIME |
V_$REPLPROP | SID |
| SERIAL# |
| NAME |
| DBLINK |
| STATE |
| XID |
| SEQUENCE |
V_$REPLQUEUE | TXNS_ENQUEUED |
| CALLS_ENQUEUED |
| TXNS_PURGED |
| LAST_ENQUEUE_TIME |
| LAST_PURGE_TIME |
V_$REQDIST | BUCKET |
| COUNT |
V_$RESERVED_WORDS | KEYWORD |
| LENGTH |
V_$RESOURCE | ADDR |
| TYPE |
| ID1 |
| ID2 |
V_$RESOURCE_LIMIT | RESOURCE_NAME |
| CURRENT_UTILIZATION |
| MAX_UTILIZATION |
| INITIAL_ALLOCATION |
| LIMIT_VALUE |
V_$RESUMABLE | ADDR |
| SID |
| ENABLED |
| STATUS |
| TIMEOUT |
| SUSPEND_TIME |
| RESUME_TIME |
| NAME |
| ERROR_NUMBER |
| ERROR_PARAMETER1 |
| ERROR_PARAMETER2 |
| ERROR_PARAMETER3 |
| ERROR_PARAMETER4 |
| ERROR_PARAMETER5 |
| ERROR_MSG |
V_$RMAN_CONFIGURATION | CONF# |
| NAME |
| VALUE |
V_$ROLLNAME | USN |
| NAME |
V_$ROLLSTAT | USN |
| LATCH |
| EXTENTS |
| RSSIZE |
| WRITES |
| XACTS |
| GETS |
| WAITS |
| OPTSIZE |
| HWMSIZE |
| SHRINKS |
| WRAPS |
| EXTENDS |
| AVESHRINK |
| AVEACTIVE |
| STATUS |
| CUREXT |
| CURBLK |
V_$ROWCACHE | CACHE# |
| TYPE |
| SUBORDINATE# |
| PARAMETER |
| COUNT |
| USAGE |
| FIXED |
| GETS |
| GETMISSES |
| SCANS |
| SCANMISSES |
| SCANCOMPLETES |
| MODIFICATIONS |
| FLUSHES |
| DLM_REQUESTS |
| DLM_CONFLICTS |
| DLM_RELEASES |
V_$ROWCACHE_PARENT | INDX |
| HASH |
| ADDRESS |
| CACHE# |
| CACHE_NAME |
| EXISTENT |
| LOCK_MODE |
| LOCK_REQUEST |
| TXN |
| SADDR |
| INST_LOCK_REQUEST |
| INST_LOCK_RELEASE |
| INST_LOCK_TYPE |
| INST_LOCK_ID1 |
| INST_LOCK_ID2 |
| KEY |
V_$ROWCACHE_SUBORDINATE | INDX |
| HASH |
| ADDRESS |
| CACHE# |
| SUBCACHE# |
| SUBCACHE_NAME |
| EXISTENT |
| PARENT |
| KEY |
V_$RSRC_CONSUMER_GROUP | NAME |
| ACTIVE_SESSIONS |
| EXECUTION_WAITERS |
| REQUESTS |
| CPU_WAIT_TIME |
| CPU_WAITS |
| CONSUMED_CPU_TIME |
| YIELDS |
| QUEUE_LENGTH |
| CURRENT_UNDO_CONSUMPTION |
V_$RSRC_CONSUMER_GROUP_CPU_MTH | NAME |
V_$RSRC_PLAN | NAME |
V_$RSRC_PLAN_CPU_MTH | NAME |
V_$SEGMENT_STATISTICS | OWNER |
| OBJECT_NAME |
| SUBOBJECT_NAME |
| TABLESPACE_NAME |
| TS# |
| OBJ# |
| DATAOBJ# |
| OBJECT_TYPE |
| STATISTIC_NAME |
| STATISTIC# |
| VALUE |
V_$SEGSTAT | TS# |
| OBJ# |
| DATAOBJ# |
| STATISTIC_NAME |
| STATISTIC# |
| VALUE |
V_$SEGSTAT_NAME | STATISTIC# |
| NAME |
| SAMPLED |
V_$SESSION | SADDR |
| SID |
| SERIAL# |
| AUDSID |
| PADDR |
| USER# |
| USERNAME |
| COMMAND |
| OWNERID |
| TADDR |
| LOCKWAIT |
| STATUS |
| SERVER |
| SCHEMA# |
| SCHEMANAME |
| OSUSER |
| PROCESS |
| MACHINE |
| TERMINAL |
| PROGRAM |
| TYPE |
| SQL_ADDRESS |
| SQL_HASH_VALUE |
| PREV_SQL_ADDR |
| PREV_HASH_VALUE |
| MODULE |
| MODULE_HASH |
| ACTION |
| ACTION_HASH |
| CLIENT_INFO |
| FIXED_TABLE_SEQUENCE |
| ROW_WAIT_OBJ# |
| ROW_WAIT_FILE# |
| ROW_WAIT_BLOCK# |
| ROW_WAIT_ROW# |
| LOGON_TIME |
| LAST_CALL_ET |
| PDML_ENABLED |
| FAILOVER_TYPE |
| FAILOVER_METHOD |
| FAILED_OVER |
| RESOURCE_CONSUMER_GROUP |
| PDML_STATUS |
| PDDL_STATUS |
| PQ_STATUS |
| CURRENT_QUEUE_DURATION |
| CLIENT_IDENTIFIER |
V_$SESSION_CONNECT_INFO | SID |
| AUTHENTICATION_TYPE |
| OSUSER |
| NETWORK_SERVICE_BANNER |
V_$SESSION_CURSOR_CACHE | MAXIMUM |
| COUNT |
| OPENED_ONCE |
| OPEN |
| OPENS |
| HITS |
| HIT_RATIO |
V_$SESSION_EVENT | SID |
| EVENT |
| TOTAL_WAITS |
| TOTAL_TIMEOUTS |
| TIME_WAITED |
| AVERAGE_WAIT |
| MAX_WAIT |
| TIME_WAITED_MICRO |
V_$SESSION_LONGOPS | SID |
| SERIAL# |
| OPNAME |
| TARGET |
| TARGET_DESC |
| SOFAR |
| TOTALWORK |
| UNITS |
| START_TIME |
| LAST_UPDATE_TIME |
| TIME_REMAINING |
| ELAPSED_SECONDS |
| CONTEXT |
| MESSAGE |
| USERNAME |
| SQL_ADDRESS |
| SQL_HASH_VALUE |
| QCSID |
V_$SESSION_OBJECT_CACHE | PINS |
| HITS |
| TRUE_HITS |
| HIT_RATIO |
| TRUE_HIT_RATIO |
| OBJECT_REFRESHES |
| CACHE_REFRESHES |
| OBJECT_FLUSHES |
| CACHE_FLUSHES |
| CACHE_SHRINKS |
| CACHED_OBJECTS |
| PINNED_OBJECTS |
| CACHE_SIZE |
| OPTIMAL_SIZE |
| MAXIMUM_SIZE |
V_$SESSION_WAIT | SID |
| SEQ# |
| EVENT |
| P1TEXT |
| P1 |
| P1RAW |
| P2TEXT |
| P2 |
| P2RAW |
| P3TEXT |
| P3 |
| P3RAW |
| WAIT_TIME |
| SECONDS_IN_WAIT |
| STATE |
V_$SESSTAT | SID |
| STATISTIC# |
| VALUE |
V_$SESS_IO | SID |
| BLOCK_GETS |
| CONSISTENT_GETS |
| PHYSICAL_READS |
| BLOCK_CHANGES |
| CONSISTENT_CHANGES |
V_$SGA | NAME |
| VALUE |
V_$SGASTAT | POOL |
| NAME |
| BYTES |
V_$SGA_CURRENT_RESIZE_OPS | COMPONENT |
| OPER_TYPE |
| OPER_MODE |
| PARAMETER |
| INITIAL_SIZE |
| TARGET_SIZE |
| CURRENT_SIZE |
| START_TIME |
| LAST_UPDATE_TIME |
V_$SGA_DYNAMIC_COMPONENTS | COMPONENT |
| CURRENT_SIZE |
| MIN_SIZE |
| MAX_SIZE |
| OPER_COUNT |
| LAST_OPER_TYPE |
| LAST_OPER_MODE |
| LAST_OPER_TIME |
| GRANULE_SIZE |
V_$SGA_DYNAMIC_FREE_MEMORY | CURRENT_SIZE |
V_$SGA_RESIZE_OPS | COMPONENT |
| OPER_TYPE |
| OPER_MODE |
| PARAMETER |
| INITIAL_SIZE |
| TARGET_SIZE |
| FINAL_SIZE |
| STATUS |
| START_TIME |
| END_TIME |
V_$SHARED_POOL_ADVICE | SHARED_POOL_SIZE_FOR_ESTIMATE |
| SHARED_POOL_SIZE_FACTOR |
| ESTD_LC_SIZE |
| ESTD_LC_MEMORY_OBJECTS |
| ESTD_LC_TIME_SAVED |
| ESTD_LC_TIME_SAVED_FACTOR |
| ESTD_LC_MEMORY_OBJECT_HITS |
V_$SHARED_POOL_RESERVED | FREE_SPACE |
| AVG_FREE_SIZE |
| FREE_COUNT |
| MAX_FREE_SIZE |
| USED_SPACE |
| AVG_USED_SIZE |
| USED_COUNT |
| MAX_USED_SIZE |
| REQUESTS |
| REQUEST_MISSES |
| LAST_MISS_SIZE |
| MAX_MISS_SIZE |
| REQUEST_FAILURES |
| LAST_FAILURE_SIZE |
| ABORTED_REQUEST_THRESHOLD |
| ABORTED_REQUESTS |
| LAST_ABORTED_SIZE |
V_$SHARED_SERVER | NAME |
| PADDR |
| STATUS |
| MESSAGES |
| BYTES |
| BREAKS |
| CIRCUIT |
| IDLE |
| BUSY |
| REQUESTS |
V_$SHARED_SERVER_MONITOR | MAXIMUM_CONNECTIONS |
| MAXIMUM_SESSIONS |
| SERVERS_STARTED |
| SERVERS_TERMINATED |
| SERVERS_HIGHWATER |
V_$SORT_SEGMENT | TABLESPACE_NAME |
| SEGMENT_FILE |
| SEGMENT_BLOCK |
| EXTENT_SIZE |
| CURRENT_USERS |
| TOTAL_EXTENTS |
| TOTAL_BLOCKS |
| USED_EXTENTS |
| USED_BLOCKS |
| FREE_EXTENTS |
| FREE_BLOCKS |
| ADDED_EXTENTS |
| EXTENT_HITS |
| FREED_EXTENTS |
| FREE_REQUESTS |
| MAX_SIZE |
| MAX_BLOCKS |
| MAX_USED_SIZE |
| MAX_USED_BLOCKS |
| MAX_SORT_SIZE |
| MAX_SORT_BLOCKS |
| RELATIVE_FNO |
V_$TEMPSEG_USAGE | USERNAME |
V_$SORT_USAGE | USERNAME |
V_$TEMPSEG_USAGE | USER |
V_$SORT_USAGE | USER |
V_$TEMPSEG_USAGE | SESSION_ADDR |
V_$SORT_USAGE | SESSION_ADDR |
V_$TEMPSEG_USAGE | SESSION_NUM |
V_$SORT_USAGE | SESSION_NUM |
V_$TEMPSEG_USAGE | SQLADDR |
V_$SORT_USAGE | SQLADDR |
V_$TEMPSEG_USAGE | SQLHASH |
V_$SORT_USAGE | SQLHASH |
V_$TEMPSEG_USAGE | TABLESPACE |
V_$SORT_USAGE | TABLESPACE |
V_$TEMPSEG_USAGE | CONTENTS |
V_$SORT_USAGE | CONTENTS |
V_$TEMPSEG_USAGE | SEGTYPE |
V_$SORT_USAGE | SEGTYPE |
V_$TEMPSEG_USAGE | SEGFILE# |
V_$SORT_USAGE | SEGFILE# |
V_$TEMPSEG_USAGE | SEGBLK# |
V_$SORT_USAGE | SEGBLK# |
V_$TEMPSEG_USAGE | EXTENTS |
V_$SORT_USAGE | EXTENTS |
V_$TEMPSEG_USAGE | BLOCKS |
V_$SORT_USAGE | BLOCKS |
V_$TEMPSEG_USAGE | SEGRFNO# |
V_$SORT_USAGE | SEGRFNO# |
V_$SPPARAMETER | SID |
| NAME |
| VALUE |
| ISSPECIFIED |
| ORDINAL |
| UPDATE_COMMENT |
V_$SQL | IS_OBSOLETE |
| CHILD_LATCH |
| SQL_TEXT |
| SHARABLE_MEM |
| PERSISTENT_MEM |
| RUNTIME_MEM |
| SORTS |
| LOADED_VERSIONS |
| OPEN_VERSIONS |
| USERS_OPENING |
| FETCHES |
| EXECUTIONS |
| USERS_EXECUTING |
| LOADS |
| FIRST_LOAD_TIME |
| INVALIDATIONS |
| PARSE_CALLS |
| DISK_READS |
| BUFFER_GETS |
| ROWS_PROCESSED |
| COMMAND_TYPE |
| OPTIMIZER_MODE |
| OPTIMIZER_COST |
| PARSING_USER_ID |
| PARSING_SCHEMA_ID |
| KEPT_VERSIONS |
| ADDRESS |
| TYPE_CHK_HEAP |
| HASH_VALUE |
| PLAN_HASH_VALUE |
| CHILD_NUMBER |
| MODULE |
| MODULE_HASH |
| ACTION |
| ACTION_HASH |
| SERIALIZABLE_ABORTS |
| OUTLINE_CATEGORY |
| CPU_TIME |
| ELAPSED_TIME |
| OUTLINE_SID |
| CHILD_ADDRESS |
| SQLTYPE |
| REMOTE |
| OBJECT_STATUS |
| LITERAL_HASH_VALUE |
| LAST_LOAD_TIME |
V_$SQLAREA | SQL_TEXT |
| SHARABLE_MEM |
| PERSISTENT_MEM |
| RUNTIME_MEM |
| SORTS |
| VERSION_COUNT |
| LOADED_VERSIONS |
| OPEN_VERSIONS |
| USERS_OPENING |
| FETCHES |
| EXECUTIONS |
| USERS_EXECUTING |
| LOADS |
| FIRST_LOAD_TIME |
| INVALIDATIONS |
| PARSE_CALLS |
| DISK_READS |
| BUFFER_GETS |
| ROWS_PROCESSED |
| COMMAND_TYPE |
| OPTIMIZER_MODE |
| PARSING_USER_ID |
| PARSING_SCHEMA_ID |
| KEPT_VERSIONS |
| ADDRESS |
| HASH_VALUE |
| MODULE |
| MODULE_HASH |
| ACTION |
| ACTION_HASH |
| SERIALIZABLE_ABORTS |
| CPU_TIME |
| ELAPSED_TIME |
| IS_OBSOLETE |
| CHILD_LATCH |
V_$SQLTEXT | ADDRESS |
| HASH_VALUE |
| COMMAND_TYPE |
| PIECE |
| SQL_TEXT |
V_$SQLTEXT_WITH_NEWLINES | ADDRESS |
| HASH_VALUE |
| COMMAND_TYPE |
| PIECE |
| SQL_TEXT |
V_$SQLXS | SQL_TEXT |
| SHARABLE_MEM |
| SORTS |
| MODULE |
| LOADED_VERSIONS |
| EXECUTIONS |
| LOADS |
| INVALIDATIONS |
| PARSE_CALLS |
| DISK_READS |
| BUFFER_GETS |
| ROWS_PROCESSED |
| ADDRESS |
| HASH_VALUE |
| VERSION_COUNT |
V_$SQL_BIND_DATA | CURSOR_NUM |
| POSITION |
| DATATYPE |
| SHARED_MAX_LEN |
| PRIVATE_MAX_LEN |
| ARRAY_SIZE |
| PRECISION |
| SCALE |
| SHARED_FLAG |
| SHARED_FLAG2 |
| BUF_ADDRESS |
| BUF_LENGTH |
| VAL_LENGTH |
| BUF_FLAG |
| INDICATOR |
| VALUE |
V_$SQL_BIND_METADATA | ADDRESS |
| POSITION |
| DATATYPE |
| MAX_LENGTH |
| ARRAY_LEN |
| BIND_NAME |
V_$SQL_CURSOR | CURNO |
| FLAG |
| STATUS |
| PARENT_HANDLE |
| PARENT_LOCK |
| CHILD_LOCK |
| CHILD_PIN |
| PERS_HEAP_MEM |
| WORK_HEAP_MEM |
| BIND_VARS |
| DEFINE_VARS |
| BIND_MEM_LOC |
| INST_FLAG |
| INST_FLAG2 |
V_$SQL_PLAN | ADDRESS |
| HASH_VALUE |
| CHILD_NUMBER |
| OPERATION |
| OPTIONS |
| OBJECT_NODE |
| OBJECT# |
| OBJECT_OWNER |
| OBJECT_NAME |
| OPTIMIZER |
| ID |
| PARENT_ID |
| DEPTH |
| POSITION |
| SEARCH_COLUMNS |
| COST |
| CARDINALITY |
| BYTES |
| OTHER_TAG |
| PARTITION_START |
| PARTITION_STOP |
| PARTITION_ID |
| OTHER |
| DISTRIBUTION |
| CPU_COST |
| IO_COST |
| TEMP_SPACE |
| ACCESS_PREDICATES |
| FILTER_PREDICATES |
V_$SQL_PLAN_STATISTICS | ADDRESS |
| HASH_VALUE |
| CHILD_NUMBER |
| OPERATION_ID |
| EXECUTIONS |
| LAST_STARTS |
| STARTS |
| LAST_OUTPUT_ROWS |
| OUTPUT_ROWS |
| LAST_CR_BUFFER_GETS |
| CR_BUFFER_GETS |
| LAST_CU_BUFFER_GETS |
| CU_BUFFER_GETS |
| LAST_DISK_READS |
| DISK_READS |
| LAST_DISK_WRITES |
| DISK_WRITES |
| LAST_ELAPSED_TIME |
| ELAPSED_TIME |
V_$SQL_PLAN_STATISTICS_ALL | PARENT_ID |
| DEPTH |
| POSITION |
| SEARCH_COLUMNS |
| COST |
| CARDINALITY |
| BYTES |
| OTHER_TAG |
| PARTITION_START |
| PARTITION_STOP |
| PARTITION_ID |
| OTHER |
| DISTRIBUTION |
| CPU_COST |
| IO_COST |
| TEMP_SPACE |
| ACCESS_PREDICATES |
| FILTER_PREDICATES |
| EXECUTIONS |
| LAST_STARTS |
| STARTS |
| LAST_OUTPUT_ROWS |
| OUTPUT_ROWS |
| LAST_CR_BUFFER_GETS |
| CR_BUFFER_GETS |
| LAST_CU_BUFFER_GETS |
| CU_BUFFER_GETS |
| LAST_DISK_READS |
| DISK_READS |
| LAST_DISK_WRITES |
| DISK_WRITES |
| LAST_ELAPSED_TIME |
| ELAPSED_TIME |
| POLICY |
| ESTIMATED_OPTIMAL_SIZE |
| ESTIMATED_ONEPASS_SIZE |
| LAST_MEMORY_USED |
| LAST_EXECUTION |
| LAST_DEGREE |
| TOTAL_EXECUTIONS |
| OPTIMAL_EXECUTIONS |
| ONEPASS_EXECUTIONS |
| MULTIPASSES_EXECUTIONS |
| ACTIVE_TIME |
| MAX_TEMPSEG_SIZE |
| LAST_TEMPSEG_SIZE |
| ADDRESS |
| HASH_VALUE |
| CHILD_NUMBER |
| OPERATION |
| OPTIONS |
| OBJECT_NODE |
| OBJECT# |
| OBJECT_OWNER |
| OBJECT_NAME |
| OPTIMIZER |
| ID |
V_$SQL_REDIRECTION | ADDRESS |
| PARENT_HANDLE |
| HASH_VALUE |
| CHILD_NUMBER |
| PARSING_USER_ID |
| PARSING_SCHEMA_ID |
| COMMAND_TYPE |
| REASON |
| ERROR_CODE |
| POSITION |
| SQL_TEXT_PIECE |
| ERROR_MESSAGE |
V_$SQL_SHARED_CURSOR | ADDRESS |
| KGLHDPAR |
| UNBOUND_CURSOR |
| SQL_TYPE_MISMATCH |
| OPTIMIZER_MISMATCH |
| OUTLINE_MISMATCH |
| STATS_ROW_MISMATCH |
| LITERAL_MISMATCH |
| SEC_DEPTH_MISMATCH |
| EXPLAIN_PLAN_CURSOR |
| BUFFERED_DML_MISMATCH |
| PDML_ENV_MISMATCH |
| INST_DRTLD_MISMATCH |
| SLAVE_QC_MISMATCH |
| TYPECHECK_MISMATCH |
| AUTH_CHECK_MISMATCH |
| BIND_MISMATCH |
| DESCRIBE_MISMATCH |
| LANGUAGE_MISMATCH |
| TRANSLATION_MISMATCH |
| ROW_LEVEL_SEC_MISMATCH |
| INSUFF_PRIVS |
| INSUFF_PRIVS_REM |
| REMOTE_TRANS_MISMATCH |
| LOGMINER_SESSION_MISMATCH |
| INCOMP_LTRL_MISMATCH |
| OVERLAP_TIME_MISMATCH |
| SQL_REDIRECT_MISMATCH |
| MV_QUERY_GEN_MISMATCH |
| USER_BIND_PEEK_MISMATCH |
| TYPCHK_DEP_MISMATCH |
| NO_TRIGGER_MISMATCH |
| FLASHBACK_CURSOR |
V_$SQL_SHARED_MEMORY | SQL_TEXT |
| HASH_VALUE |
| HEAP_DESC |
| STRUCTURE |
| FUNCTION |
| CHUNK_COM |
| CHUNK_PTR |
| CHUNK_SIZE |
| ALLOC_CLASS |
| CHUNK_TYPE |
| SUBHEAP_DESC |
V_$SQL_WORKAREA | ADDRESS |
| HASH_VALUE |
| CHILD_NUMBER |
| WORKAREA_ADDRESS |
| OPERATION_TYPE |
| OPERATION_ID |
| POLICY |
| ESTIMATED_OPTIMAL_SIZE |
| ESTIMATED_ONEPASS_SIZE |
| LAST_MEMORY_USED |
| LAST_EXECUTION |
| LAST_DEGREE |
| TOTAL_EXECUTIONS |
| OPTIMAL_EXECUTIONS |
| ONEPASS_EXECUTIONS |
| MULTIPASSES_EXECUTIONS |
| ACTIVE_TIME |
| MAX_TEMPSEG_SIZE |
| LAST_TEMPSEG_SIZE |
V_$SQL_WORKAREA_ACTIVE | WORKAREA_ADDRESS |
| OPERATION_TYPE |
| OPERATION_ID |
| POLICY |
| SID |
| QCINST_ID |
| QCSID |
| ACTIVE_TIME |
| WORK_AREA_SIZE |
| EXPECTED_SIZE |
| ACTUAL_MEM_USED |
| MAX_MEM_USED |
| NUMBER_PASSES |
| TEMPSEG_SIZE |
| TABLESPACE |
| SEGRFNO# |
| SEGBLK# |
V_$SQL_WORKAREA_HISTOGRAM | LOW_OPTIMAL_SIZE |
| HIGH_OPTIMAL_SIZE |
| OPTIMAL_EXECUTIONS |
| ONEPASS_EXECUTIONS |
| MULTIPASSES_EXECUTIONS |
| TOTAL_EXECUTIONS |
V_$STANDBY_LOG | GROUP# |
| THREAD# |
| SEQUENCE# |
| BYTES |
| USED |
| ARCHIVED |
| STATUS |
| FIRST_CHANGE# |
| FIRST_TIME |
| LAST_CHANGE# |
| LAST_TIME |
V_$STATISTICS_LEVEL | STATISTICS_NAME |
| DESCRIPTION |
| SESSION_STATUS |
| SYSTEM_STATUS |
| ACTIVATION_LEVEL |
| STATISTICS_VIEW_NAME |
| SESSION_SETTABLE |
V_$STATNAME | STATISTIC# |
| NAME |
| CLASS |
V_$STREAMS_APPLY_COORDINATOR | SID |
| SERIAL# |
| STATE |
| APPLY# |
| APPLY_NAME |
| TOTAL_APPLIED |
| TOTAL_WAIT_DEPS |
| TOTAL_WAIT_COMMITS |
| TOTAL_ADMIN |
| TOTAL_ASSIGNED |
| TOTAL_RECEIVED |
| TOTAL_ERRORS |
| LWM_TIME |
| LWM_MESSAGE_NUMBER |
| LWM_MESSAGE_CREATE_TIME |
| HWM_TIME |
| HWM_MESSAGE_NUMBER |
| HWM_MESSAGE_CREATE_TIME |
| STARTUP_TIME |
| ELAPSED_SCHEDULE_TIME |
V_$STREAMS_APPLY_READER | SID |
| SERIAL# |
| APPLY# |
| APPLY_NAME |
| STATE |
| TOTAL_MESSAGES_DEQUEUED |
| DEQUEUE_TIME |
| DEQUEUED_MESSAGE_NUMBER |
| DEQUEUED_MESSAGE_CREATE_TIME |
| SGA_USED |
| ELAPSED_DEQUEUE_TIME |
| ELAPSED_SCHEDULE_TIME |
V_$STREAMS_APPLY_SERVER | SID |
| SERIAL# |
| APPLY# |
| APPLY_NAME |
| SERVER_ID |
| STATE |
| XIDUSN |
| XIDSLT |
| XIDSQN |
| COMMITSCN |
| DEP_XIDUSN |
| DEP_XIDSLT |
| DEP_XIDSQN |
| DEP_COMMITSCN |
| MESSAGE_SEQUENCE |
| TOTAL_ASSIGNED |
| TOTAL_ADMIN |
| TOTAL_MESSAGES_APPLIED |
| APPLY_TIME |
| APPLIED_MESSAGE_NUMBER |
| APPLIED_MESSAGE_CREATE_TIME |
| ELAPSED_DEQUEUE_TIME |
| ELAPSED_APPLY_TIME |
V_$STREAMS_CAPTURE | SID |
| SERIAL# |
| CAPTURE# |
| CAPTURE_NAME |
| STARTUP_TIME |
| STATE |
| TOTAL_MESSAGES_CAPTURED |
| CAPTURE_TIME |
| CAPTURE_MESSAGE_NUMBER |
| CAPTURE_MESSAGE_CREATE_TIME |
| TOTAL_MESSAGES_ENQUEUED |
| ENQUEUE_TIME |
| ENQUEUE_MESSAGE_NUMBER |
| ENQUEUE_MESSAGE_CREATE_TIME |
| ELAPSED_CAPTURE_TIME |
| ELAPSED_RULE_TIME |
| ELAPSED_ENQUEUE_TIME |
| ELAPSED_LCR_TIME |
V_$SUBCACHE | OWNER_NAME |
| NAME |
| TYPE |
| HEAP_NUM |
| CACHE_ID |
| CACHE_CNT |
| HEAP_SZ |
| HEAP_ALOC |
| HEAP_USED |
V_$SYSSTAT | STATISTIC# |
| NAME |
| CLASS |
| VALUE |
V_$SYSTEM_CURSOR_CACHE | OPENS |
| HITS |
| HIT_RATIO |
V_$SYSTEM_EVENT | EVENT |
| TOTAL_WAITS |
| TOTAL_TIMEOUTS |
| TIME_WAITED |
| AVERAGE_WAIT |
| TIME_WAITED_MICRO |
V_$SYSTEM_PARAMETER | NUM |
| NAME |
| TYPE |
| VALUE |
| ISDEFAULT |
| ISSES_MODIFIABLE |
| ISSYS_MODIFIABLE |
| ISMODIFIED |
| ISADJUSTED |
| DESCRIPTION |
| UPDATE_COMMENT |
V_$SYSTEM_PARAMETER2 | NUM |
| NAME |
| TYPE |
| VALUE |
| ISDEFAULT |
| ISSES_MODIFIABLE |
| ISSYS_MODIFIABLE |
| ISMODIFIED |
| ISADJUSTED |
| DESCRIPTION |
| ORDINAL |
| UPDATE_COMMENT |
V_$TABLESPACE | TS# |
| NAME |
| INCLUDED_IN_DATABASE_BACKUP |
V_$TEMPFILE | FILE# |
| CREATION_CHANGE# |
| CREATION_TIME |
| TS# |
| RFILE# |
| STATUS |
| ENABLED |
| BYTES |
| BLOCKS |
| CREATE_BYTES |
| BLOCK_SIZE |
| NAME |
V_$TEMPORARY_LOBS | SID |
| CACHE_LOBS |
| NOCACHE_LOBS |
V_$TEMPSTAT | FILE# |
| PHYRDS |
| PHYWRTS |
| PHYBLKRD |
| PHYBLKWRT |
| SINGLEBLKRDS |
| READTIM |
| WRITETIM |
| SINGLEBLKRDTIM |
| AVGIOTIM |
| LSTIOTIM |
| MINIOTIM |
| MAXIORTM |
| MAXIOWTM |
V_$TEMPSTATXS | TSNAME |
| FILENAME |
| PHYRDS |
| PHYWRTS |
| READTIM |
| WRITETIM |
| PHYBLKRD |
| PHYBLKWRT |
| WAIT_COUNT |
| TIME |
V_$TEMP_CACHE_TRANSFER | X_2_NULL_FORCED_STALE |
| X_2_S |
| X_2_S_FORCED_WRITE |
| S_2_NULL |
| S_2_NULL_FORCED_STALE |
| RBR |
| RBR_FORCED_WRITE |
| NULL_2_X |
| S_2_X |
| NULL_2_S |
| FILE_NUMBER |
| X_2_NULL |
| X_2_NULL_FORCED_WRITE |
V_$TEMP_EXTENT_MAP | TABLESPACE_NAME |
| FILE_ID |
| BLOCK_ID |
| BYTES |
| BLOCKS |
| OWNER |
| RELATIVE_FNO |
V_$TEMP_EXTENT_POOL | TABLESPACE_NAME |
| FILE_ID |
| EXTENTS_CACHED |
| EXTENTS_USED |
| BLOCKS_CACHED |
| BLOCKS_USED |
| BYTES_CACHED |
| BYTES_USED |
| RELATIVE_FNO |
V_$TEMP_PING | FILE_NUMBER |
| FREQUENCY |
| X_2_NULL |
| X_2_NULL_FORCED_WRITE |
| X_2_NULL_FORCED_STALE |
| X_2_S |
| X_2_S_FORCED_WRITE |
| X_2_SSX |
| X_2_SSX_FORCED_WRITE |
| S_2_NULL |
| S_2_NULL_FORCED_STALE |
| SS_2_NULL |
| SS_2_RLS |
| WRB |
| WRB_FORCED_WRITE |
| RBR |
| RBR_FORCED_WRITE |
| RBR_FORCED_STALE |
| CBR |
| CBR_FORCED_WRITE |
| NULL_2_X |
| S_2_X |
| SSX_2_X |
| NULL_2_S |
| NULL_2_SS |
| OP_2_SS |
V_$TEMP_SPACE_HEADER | TABLESPACE_NAME |
| FILE_ID |
| BYTES_USED |
| BLOCKS_USED |
| BYTES_FREE |
| BLOCKS_FREE |
| RELATIVE_FNO |
V_$THREAD | THREAD# |
| STATUS |
| ENABLED |
| GROUPS |
| INSTANCE |
| OPEN_TIME |
| CURRENT_GROUP# |
| SEQUENCE# |
| CHECKPOINT_CHANGE# |
| CHECKPOINT_TIME |
| ENABLE_CHANGE# |
| ENABLE_TIME |
| DISABLE_CHANGE# |
| DISABLE_TIME |
V_$TIMER | HSECS |
V_$TIMEZONE_NAMES | TZNAME |
| TZABBREV |
V_$TRANSACTION | ADDR |
| XIDUSN |
| XIDSLOT |
| XIDSQN |
| UBAFIL |
| UBABLK |
| UBASQN |
| UBAREC |
| STATUS |
| START_TIME |
| START_SCNB |
| START_SCNW |
| START_UEXT |
| START_UBAFIL |
| START_UBABLK |
| START_UBASQN |
| START_UBAREC |
| SES_ADDR |
| FLAG |
| SPACE |
| RECURSIVE |
| NOUNDO |
| PTX |
| NAME |
| PRV_XIDUSN |
| PRV_XIDSLT |
| PRV_XIDSQN |
| PTX_XIDUSN |
| PTX_XIDSLT |
| PTX_XIDSQN |
| DSCN-B |
| DSCN-W |
| USED_UBLK |
| USED_UREC |
| LOG_IO |
| PHY_IO |
| CR_GET |
| CR_CHANGE |
V_$TRANSACTION_ENQUEUE | ADDR |
| KADDR |
| SID |
| TYPE |
| ID1 |
| ID2 |
| LMODE |
| REQUEST |
| CTIME |
| BLOCK |
V_$TYPE_SIZE | COMPONENT |
| TYPE |
| DESCRIPTION |
| TYPE_SIZE |
V_$UNDOSTAT | BEGIN_TIME |
| END_TIME |
| UNDOTSN |
| UNDOBLKS |
| TXNCOUNT |
| MAXQUERYLEN |
| MAXCONCURRENCY |
| UNXPSTEALCNT |
| UNXPBLKRELCNT |
| UNXPBLKREUCNT |
| EXPSTEALCNT |
| EXPBLKRELCNT |
| EXPBLKREUCNT |
| SSOLDERRCNT |
| NOSPACEERRCNT |
V_$VERSION | BANNER |
V_$VPD_POLICY | ADDRESS |
| PARADDR |
| SQL_HASH |
| CHILD_NUMBER |
| OBJECT_OWNER |
| OBJECT_NAME |
| POLICY_GROUP |
| POLICY |
| POLICY_FUNCTION_OWNER |
| PREDICATE |
V_$WAITSTAT | CLASS |
| COUNT |
| TIME |
V_$_LOCK | LADDR |
| KADDR |
| SADDR |
| RADDR |
| LMODE |
| REQUEST |
| CTIME |
| BLOCK |