V$views

[sher...@gmail.com]

OWNER VIEW_NAME TEXT_LENGTH TEXT TYPE_TEXT_LENGTH TYPE_TEXT
OID_TEXT_LENGTH OID_TEXT VIEW_TYPE_OWNER VIEW_TYPE SUPERVIEW_NAME
SYS V$OBJECT_USAGE 351 "select io.name, t.name,
decode(bitand(i.flags, 65536), 0, 'NO', 'YES'),
decode(bitand(ou.flags, 1), 0, 'NO', 'YES'),
ou.start_monitoring,
ou.end_monitoring
from sys.obj$ io, sys.obj$ t, sys.ind$ i, sys.object_usage ou
where io.owner# = userenv('SCHEMAID')
and i.obj# = ou.obj#
and io.obj# = ou.obj#
and t.obj# = i.bo#"
SYS V$OLAP_ALTER_SESSION 125 "SELECT U.NAME ROLE, O.TEXT CLAUSE_TEXT
FROM SYS.USER$ U, OLAP$ALTER_SESSION O
WHERE U.USER# = O.ROLE#
WITH READ ONLY"
SYS V_$ACCESS 50 select "SID","OWNER","OBJECT","TYPE" from v
$access
SYS V_$ACTIVE_INSTANCES 56 select "INST_NUMBER","INST_NAME" from v
$active_instances
SYS V_$ACTIVE_SESS_POOL_MTH 41 select "NAME" from v
$active_sess_pool_mth
SYS V_$AQ 81 "select QID, WAITING, READY, EXPIRED, TOTAL_WAIT,
AVERAGE_WAIT from v$aq1"
SYS V_$AQ1 97 select
"QID","WAITING","READY","EXPIRED","TOTAL_CONSUMERS","TOTAL_WAIT","AVERAGE_WAIT"
from v$aq1
SYS V_$ARCHIVE 90 select
"GROUP#","THREAD#","SEQUENCE#","ISCURRENT","CURRENT","FIRST_CHANGE#"
from v$archive
SYS V_$ARCHIVED_LOG 389 select
"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#"
from v$archived_log
SYS V_$ARCHIVE_DEST 407 select
"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"
from v$archive_dest
SYS V_$ARCHIVE_DEST_STATUS 266 select
"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"
from v$archive_dest_status
SYS V_$ARCHIVE_GAP 68 select
"THREAD#","LOW_SEQUENCE#","HIGH_SEQUENCE#" from v$archive_gap
SYS V_$ARCHIVE_PROCESSES 73 select
"PROCESS","STATUS","LOG_SEQUENCE","STATE" from v
$archive_processes
SYS V_$AW_CALC 206 select
"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"
from v$aw_calc
SYS V_$AW_OLAP 167 select
"SESSION_ID","AW_NUMBER","ATTACH_MODE","GENERATION","TEMP_SPACE_PAGES","TEMP_SPACE_READS","LOB_READS","POOL_CHANGED_PAGES","POOL_UNCHANGED_PAGES"
from v$aw_olap
SYS V_$AW_SESSION_INFO 278 select
"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"
from v$aw_session_info
SYS V_$BACKUP 54 select "FILE#","STATUS","CHANGE#","TIME" from v
$backup
SYS V_$BACKUP_ASYNC_IO 392 select
"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"
from v$backup_async_io
SYS V_$BACKUP_CORRUPTION 162 select
"RECID","STAMP","SET_STAMP","SET_COUNT","PIECE#","FILE#","BLOCK#","BLOCKS","CORRUPTION_CHANGE#","MARKED_CORRUPT","CORRUPTION_TYPE"
from v$backup_corruption
SYS V_$BACKUP_DATAFILE 408 select
"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"
from v$backup_datafile
SYS V_$BACKUP_DEVICE 55 select "DEVICE_TYPE","DEVICE_NAME" from v
$backup_device
SYS V_$BACKUP_PIECE 221 select
"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"
from v$backup_piece
SYS V_$BACKUP_REDOLOG 205 select
"RECID","STAMP","SET_STAMP","SET_COUNT","THREAD#","SEQUENCE#","RESETLOGS_CHANGE#","RESETLOGS_TIME","FIRST_CHANGE#","FIRST_TIME","NEXT_CHANGE#","NEXT_TIME","BLOCKS","BLOCK_SIZE"
from v$backup_redolog
SYS V_$BACKUP_SET 250 select
"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"
from v$backup_set
SYS V_$BACKUP_SPFILE 113 select
"RECID","STAMP","SET_STAMP","SET_COUNT","MODIFICATION_TIME","BYTES","COMPLETION_TIME"
from v$backup_spfile
SYS V_$BACKUP_SYNC_IO 324 select
"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"
from v$backup_sync_io
SYS V_$BGPROCESS 60 select "PADDR","NAME","DESCRIPTION","ERROR" from v
$bgprocess
SYS V_$BH 207 select
"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#"
from v$bh
SYS V_$BSP 332 select
"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"
from v$bsp
SYS V_$BUFFER_POOL 202 select
"ID","NAME","BLOCK_SIZE","RESIZE_STATE","CURRENT_SIZE","BUFFERS","TARGET_SIZE","TARGET_BUFFERS","PREV_SIZE","PREV_BUFFERS","LO_BNUM","HI_BNUM","LO_SETID","HI_SETID","SET_COUNT"
from v$buffer_pool
SYS V_$BUFFER_POOL_STATISTICS 339 select
"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"
from v$buffer_pool_statistics
SYS V_$CIRCUIT 185 select
"CIRCUIT","DISPATCHER","SERVER","WAITER","SADDR","STATUS","QUEUE","MESSAGE0","MESSAGE1","MESSAGE2","MESSAGE3","MESSAGES","BYTES","BREAKS","PRESENTATION","PCIRCUIT"
from v$circuit
SYS V_$CLASS_CACHE_TRANSFER 195 select
"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"
from v$class_cache_transfer
SYS V_$CLASS_PING 273 select
"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"
from v$class_ping
SYS V_$COMPATIBILITY 61 select "TYPE_ID","RELEASE","DESCRIPTION" from v
$compatibility
SYS V_$COMPATSEG 53 select "TYPE_ID","RELEASE","UPDATED" from v
$compatseg
SYS V_$CONTEXT 125 "select SUBSTR(namespace,1,30) ""NAMESPACE"",
SUBSTR(attribute,1,30) ""ATTRIBUTE"",
value ""VALUE"" from v$context"
SYS V_$CONTROLFILE 41 select "STATUS","NAME" from v$controlfile
SYS V_$CONTROLFILE_RECORD_SECTION 132 select
"TYPE","RECORD_SIZE","RECORDS_TOTAL","RECORDS_USED","FIRST_INDEX","LAST_INDEX","LAST_RECID"
from v$controlfile_record_section
SYS V_$COPY_CORRUPTION 153 select
"RECID","STAMP","COPY_RECID","COPY_STAMP","FILE#","BLOCK#","BLOCKS","CORRUPTION_CHANGE#","MARKED_CORRUPT","CORRUPTION_TYPE"
from v$copy_corruption
SYS V_$CR_BLOCK_SERVER 342 select
"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"
from v$cr_block_server
SYS V_$DATABASE 589 select
"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"
from v$database
SYS V_$DATABASE_BLOCK_CORRUPTION 107 "select
""FILE#"",""BLOCK#"",""BLOCKS"",""CORRUPTION_CHANGE#"",""CORRUPTION_TYPE""
from
v$database_block_corruption"
SYS V_$DATABASE_INCARNATION 123 "select
""RESETLOGS_CHANGE#"",""RESETLOGS_TIME"",""PRIOR_RESETLOGS_CHANGE#"",""PRIOR_RESETLOGS_TIME""
from
v$database_incarnation"
SYS V_$DATAFILE 351 select
"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"
from v$datafile
SYS V_$DATAFILE_COPY 505 select
"RECID","STAMP","NAME","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"
from v$datafile_copy
SYS V_$DATAFILE_HEADER 268 select
"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"
from v$datafile_header
SYS V_$DATAGUARD_STATUS 121 select
"FACILITY","SEVERITY","DEST_ID","MESSAGE_NUM","ERROR_CODE","CALLOUT","TIMESTAMP","MESSAGE"
from v$dataguard_status
SYS V_$DBFILE 35 select "FILE#","NAME" from v$dbfile
SYS V_$DBLINK 150 select
"DB_LINK","OWNER_ID","LOGGED_ON","HETEROGENEOUS","PROTOCOL","OPEN_CURSORS","IN_TRANSACTION","UPDATE_SENT","COMMIT_POINT_STRENGTH"
from v$dblink
SYS V_$DB_CACHE_ADVICE 177 select
"ID","NAME","BLOCK_SIZE","ADVICE_STATUS","SIZE_FOR_ESTIMATE","SIZE_FACTOR","BUFFERS_FOR_ESTIMATE","ESTD_PHYSICAL_READ_FACTOR","ESTD_PHYSICAL_READS"
from v$db_cache_advice
SYS V_$DB_OBJECT_CACHE 145 select
"OWNER","NAME","DB_LINK","NAMESPACE","TYPE","SHARABLE_MEM","LOADS","EXECUTIONS","LOCKS","PINS","KEPT","CHILD_LATCH"
from v$db_object_cache
SYS V_$DB_PIPES 58 select "OWNERID","NAME","TYPE","PIPE_SIZE" from v
$db_pipes
SYS V_$DELETED_OBJECT 95 select
"RECID","STAMP","TYPE","OBJECT_RECID","OBJECT_STAMP","OBJECT_DATA"
from v$deleted_object
SYS V_$DISPATCHER 150 select
"NAME","NETWORK","PADDR","STATUS","ACCEPT","MESSAGES","BYTES","BREAKS","OWNED","CREATED","IDLE","BUSY","LISTENER","CONF_INDX"
from v$dispatcher
SYS V_$DISPATCHER_RATE 1212 select
"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","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"
from v$dispatcher_rate
SYS V_$DLM_ALL_LOCKS 503 select
"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"
from v$dlm_all_locks
SYS V_$DLM_CONVERT_LOCAL 95 select
"INST_ID","CONVERT_TYPE","AVERAGE_CONVERT_TIME","CONVERT_COUNT" from v
$dlm_convert_local
SYS V_$DLM_CONVERT_REMOTE 96 select
"INST_ID","CONVERT_TYPE","AVERAGE_CONVERT_TIME","CONVERT_COUNT" from v
$dlm_convert_remote
SYS V_$DLM_LATCH 279 select
"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"
from v$dlm_latch
SYS V_$DLM_LOCKS 499 select
"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"
from v$dlm_locks
SYS V_$DLM_MISC 50 select "STATISTIC#","NAME","VALUE" from v$dlm_misc
SYS V_$DLM_RESS 151 select
"RESP","RESOURCE_NAME","ON_CONVERT_Q","ON_GRANT_Q","PERSISTENT_RES","MASTER_NODE","NEXT_CVT_LEVEL","VALUE_BLK_STATE","VALUE_BLK"
from v$dlm_ress
SYS V_$DLM_TRAFFIC_CONTROLLER 252 select
"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"
from v$dlm_traffic_controller
SYS V_$ENABLEDPRIVS 40 select "PRIV_NUMBER" from v$enabledprivs
SYS V_$ENQUEUE_LOCK 100 select
"ADDR","KADDR","SID","TYPE","ID1","ID2","LMODE","REQUEST","CTIME","BLOCK"
from v$enqueue_lock
SYS V_$ENQUEUE_STAT 115 select
"INST_ID","EQ_TYPE","TOTAL_REQ#","TOTAL_WAIT#","SUCC_REQ#","FAILED_REQ#","CUM_WAIT_TIME"
from v$enqueue_stat
SYS V_$EVENT_NAME 79 select
"EVENT#","NAME","PARAMETER1","PARAMETER2","PARAMETER3" from v
$event_name
SYS V_$EXECUTION 91 select
"PID","DEPTH","FUNCTION","TYPE","NVALS","VAL1","VAL2","SEQH","SEQL"
from v$execution
SYS V_$FAST_START_SERVERS 63 select "STATE","UNDOBLOCKSDONE","PID"
from v$fast_start_servers
SYS V_$FAST_START_TRANSACTIONS 150 select
"USN","SLT","SEQ","STATE","UNDOBLOCKSDONE","UNDOBLOCKSTOTAL","PID","CPUTIME","PARENTUSN","PARENTSLT","PARENTSEQ"
from v$fast_start_transactions
SYS V_$FILESTAT 180 select
"FILE#","PHYRDS","PHYWRTS","PHYBLKRD","PHYBLKWRT","SINGLEBLKRDS","READTIM","WRITETIM","SINGLEBLKRDTIM","AVGIOTIM","LSTIOTIM","MINIOTIM","MAXIORTM","MAXIOWTM"
from v$filestat
SYS V_$FILESTATXS 395 "select ts.name tsname
, df.name filename
, fs.phyrds
, fs.phywrts
, fs.readtim
, fs.writetim
, fs.phyblkrd
, fs.phyblkwrt
, fw.count wait_count
, fw.time time
from x$kcbfwait fw
, v$filestat fs
, v$tablespace ts
, v$datafile df
where ts.ts# = df.ts#
and fs.file# = df.file#
and fw.indx+1 = df.file#"
SYS V_$FILE_CACHE_TRANSFER 275 select
"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"
from v$file_cache_transfer
SYS V_$FILE_PING 384 select
"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"
from v$file_ping
SYS V_$FIXED_TABLE 63 select "NAME","OBJECT_ID","TYPE","TABLE_NUM"
from v$fixed_table
SYS V_$FIXED_VIEW_DEFINITION 65 select "VIEW_NAME","VIEW_DEFINITION"
from v$fixed_view_definition
SYS V_$GCSHVMASTER_INFO 88 select
"HV_ID","CURRENT_MASTER","PREVIOUS_MASTER","REMASTER_CNT" from v
$gcshvmaster_info
SYS V_$GCSPFMASTER_INFO 90 select
"FILE_ID","CURRENT_MASTER","PREVIOUS_MASTER","REMASTER_CNT" from v
$gcspfmaster_info
SYS V_$GC_ELEMENT 164 select
"GC_ELEMENT_ADDR","INDX","CLASS","GC_ELEMENT_NAME","MODE_HELD","BLOCK_COUNT","RELEASING","ACQUIRING","WRITING","RECOVERING","LOCAL","FLAGS"
from v$gc_element
SYS V_$GC_ELEMENTS_W_COLLISIONS 59 select "GC_ELEMENT_ADDR" from v
$gc_elements_with_collisions
SYS V_$GES_BLOCKING_ENQUEUE 507 select
"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"
from v$ges_blocking_enqueue
SYS V_$GES_ENQUEUE 498 select
"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"
from v$ges_enqueue
SYS V_$GLOBALCONTEXT 230 "select SUBSTR(namespace,1,30) ""NAMESPACE"",
SUBSTR(attribute,1,30) ""ATTRIBUTE"",
value ""VALUE"",
SUBSTR(username,1,30) ""USERNAME"",
clientidentifier ""CLIENT_IDENTIFIER""
from v$globalcontext"
SYS V_$GLOBAL_BLOCKED_LOCKS 100 select
"ADDR","KADDR","SID","TYPE","ID1","ID2","LMODE","REQUEST","CTIME" from
v$global_blocked_locks
SYS V_$GLOBAL_TRANSACTION 129 select
"FORMATID","GLOBALID","BRANCHID","BRANCHES","REFCOUNT","PREPARECOUNT","STATE","FLAGS","COUPLING"
from v$global_transaction
SYS V_$HS_AGENT 126 select
"AGENT_ID","MACHINE","PROCESS","PROGRAM","OSUSER","STARTTIME","AGENT_TYPE","FDS_CLASS_ID","FDS_INST_ID"
from v$hs_agent
SYS V_$HS_PARAMETER 77 select
"HS_SESSION_ID","PARAMETER","VALUE","SOURCE","ENV" from v$hs_parameter
SYS V_$HS_SESSION 95 select
"HS_SESSION_ID","AGENT_ID","SID","DB_LINK","DB_LINK_OWNER","STARTTIME"
from v$hs_session
SYS V_$HVMASTER_INFO 85 select
"HV_ID","CURRENT_MASTER","PREVIOUS_MASTER","REMASTER_CNT" from v
$hvmaster_info
SYS V_$INDEXED_FIXED_COLUMN 94 select
"TABLE_NAME","INDEX_NUMBER","COLUMN_NAME","COLUMN_POSITION" from v
$indexed_fixed_column
SYS V_$INSTANCE 229 select
"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"
from v$instance
SYS V_$INSTANCE_RECOVERY 265 select
"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"
from v$instance_recovery
SYS V_$KCCDI 492 SELECT
"ADDR","INDX","INST_ID","DIDFV","DIDFC","DICTS","DIDBN","DIRDB","DICCT","DIFLG","DIIRS","DIRLS","DIRLC","DIRLC_I","DIPRS","DIPRC","DIPRC_I","DIRDV","DIRDC","DINDF","DINOF","DICPT","DISCN","DINET","DINOT","DIOTH","DIOTT","DIETB","DIMLM","DIMDM","DIARH","DIART","DIPRT","DIFAS","DICKP_SCN","DICKP_TIM","DICSQ","DIDBI","DISSC_SCN","DISSC_TIM","DISFP","DIBSC","DIPOFB","DIPNFB","DICOFB","DICNFB","DIVTS","DICID","DIDOR","DISLH","DISLT","DIRAE","DIACID","DIARS","DISOS","DIDGD"
FROM x$kccdi
SYS V_$KCCFE 447 SELECT
"ADDR","INDX","INST_ID","FENUM","FECSZ","FEBSZ","FESTA","FECRC_SCN","FECRC_TIM","FECRC_THR","FECRC_RBA_SEQ","FECRC_RBA_BNO","FECRC_RBA_BOF","FECRC_ETB","FECPS","FECPT","FECPC","FESTS","FESTT","FEBSC","FEFNH","FEFNT","FEDUP","FEURS","FEURT","FEOFS","FEONC_SCN","FEONC_TIM","FEONC_THR","FEONC_RBA_SEQ","FEONC_RBA_BNO","FEONC_RBA_BOF","FEONC_ETB","FEPOR","FETSN","FETSI","FERFN","FEPFT","FEDOR","FEPDI","FEFDB","FEPLG_SCN","FEPAX"
FROM x$kccfe
SYS V_$LATCH 275 select
"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"
from v$latch
SYS V_$LATCHHOLDER 52 select "PID","SID","LADDR","NAME" from v
$latchholder
SYS V_$LATCHNAME 39 select "LATCH#","NAME" from v$latchname
SYS V_$LATCH_CHILDREN 293 select
"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"
from v$latch_children
SYS V_$LATCH_MISSES 121 select
"PARENT_NAME","WHERE","NWFAIL_COUNT","SLEEP_COUNT","WTR_SLP_COUNT","LONGHOLD_COUNT","LOCATION"
from v$latch_misses
SYS V_$LATCH_PARENT 282 select
"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"
from v$latch_parent
SYS V_$LIBRARYCACHE 232 select
"NAMESPACE","GETS","GETHITS","GETHITRATIO","PINS","PINHITS","PINHITRATIO","RELOADS","INVALIDATIONS","DLM_LOCK_REQUESTS","DLM_PIN_REQUESTS","DLM_PIN_RELEASES","DLM_INVALIDATION_REQUESTS","DLM_INVALIDATIONS"
from v$librarycache
SYS V_$LIBRARY_CACHE_MEMORY 153 select
"LC_NAMESPACE","LC_INUSE_MEMORY_OBJECTS","LC_INUSE_MEMORY_SIZE","LC_FREEABLE_MEMORY_OBJECTS","LC_FREEABLE_MEMORY_SIZE"
from v$library_cache_memory
SYS V_$LICENSE 107 select
"SESSIONS_MAX","SESSIONS_WARNING","SESSIONS_CURRENT","SESSIONS_HIGHWATER","USERS_MAX"
from v$license
SYS V_$LOADISTAT 73 select
"OWNER","TABNAME","INDEXNAME","SUBNAME","MESSAGE" from v$loadistat
SYS V_$LOADPSTAT 61 select "OWNER","TABNAME","PARTNAME","LOADED" from v
$loadpstat
SYS V_$LOCK 92 select
"ADDR","KADDR","SID","TYPE","ID1","ID2","LMODE","REQUEST","CTIME","BLOCK"
from v$lock
SYS V_$LOCKED_OBJECT 137 select
"XIDUSN","XIDSLOT","XIDSQN","OBJECT_ID","SESSION_ID","ORACLE_USERNAME","OS_USER_NAME","PROCESS","LOCKED_MODE"
from v$locked_object
SYS V_$LOCKS_WITH_COLLISIONS 55 select "LOCK_ELEMENT_ADDR" from v
$locks_with_collisions
SYS V_$LOCK_ACTIVITY 70 select
"FROM_VAL","TO_VAL","ACTION_VAL","COUNTER" from v$lock_activity
SYS V_$LOCK_ELEMENT 149 select
"LOCK_ELEMENT_ADDR","INDX","CLASS","LOCK_ELEMENT_NAME","MODE_HELD","BLOCK_COUNT","RELEASING","ACQUIRING","INVALID","FLAGS"
from v$lock_element
SYS V_$LOG 115 select
"GROUP#","THREAD#","SEQUENCE#","BYTES","MEMBERS","ARCHIVED","STATUS","FIRST_CHANGE#","FIRST_TIME"
from v$log
SYS V_$LOGFILE 55 select "GROUP#","STATUS","TYPE","MEMBER" from v
$logfile
SYS V_$LOGHIST 89 select
"THREAD#","SEQUENCE#","FIRST_CHANGE#","FIRST_TIME","SWITCH_CHANGE#"
from v$loghist
SYS V_$LOGMNR_CALLBACK 57 select "STATE","TYPE","CAPABILITY" from v
$logmnr_callback
SYS V_$LOGMNR_CONTENTS 632 select
"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"
from v$logmnr_contents
SYS V_$LOGMNR_DICTIONARY 155 select
"TIMESTAMP","DB_ID","DB_NAME","FILENAME","DICTIONARY_SCN","RESET_SCN","RESET_SCN_TIME","ENABLED_THREAD_MAP","INFO","STATUS"
from v$logmnr_dictionary
SYS V_$LOGMNR_LOGFILE 228 select
"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"
from v$logmnr_logfile
SYS V_$LOGMNR_LOGS 213 select
"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"
from v$logmnr_logs
SYS V_$LOGMNR_PARAMETERS 93 select
"START_DATE","END_DATE","START_SCN","END_SCN","INFO","STATUS" from v
$logmnr_parameters
SYS V_$LOGMNR_PROCESS 93 select
"PID","SPID","ROLE","USERNAME","SERIAL#","LATCHWAIT","LATCHSPIN" from v
$logmnr_process
SYS V_$LOGMNR_REGION 63 select "MEMSTATE","STATE","OWNING_PROCESS"
from v$logmnr_region
SYS V_$LOGMNR_SESSION 315 select
"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"
from v$logmnr_session
SYS V_$LOGMNR_STATS 54 select "SESSION_ID","NAME","VALUE" from v
$logmnr_stats
SYS V_$LOGMNR_TRANSACTION 148 select
"XIDUSN","XIDSLT","XIDSQN","COMMIT_SCNWRP","COMMIT_SCNBAS","NUM_CHANGE_RECORD","FLAGS","CHUNK_INDEX","TOTAL_CHUNKS"
from v$logmnr_transaction
SYS V_$LOGSTDBY 93 select
"SERIAL#","LOGSTDBY_ID","PID","TYPE","STATUS_CODE","STATUS","HIGH_SCN"
from v$logstdby
SYS V_$LOGSTDBY_STATS 43 select "NAME","VALUE" from v$logstdby_stats
SYS V_$LOG_HISTORY 107 select
"RECID","STAMP","THREAD#","SEQUENCE#","FIRST_CHANGE#","FIRST_TIME","NEXT_CHANGE#"
from v$log_history
SYS V_$MANAGED_STANDBY 191 select
"PROCESS","PID","STATUS","CLIENT_PROCESS","CLIENT_PID","CLIENT_DBID","GROUP#","THREAD#","SEQUENCE#","BLOCK#","BLOCKS","DELAY_MINS","KNOWN_AGENTS","ACTIVE_AGENTS"
from v$managed_standby
SYS V_$MAP_COMP_LIST 174 select
"ELEM_IDX","NUM_COMP","COMP1_NAME","COMP1_VAL","COMP2_NAME","COMP2_VAL","COMP3_NAME","COMP3_VAL","COMP4_NAME","COMP4_VAL","COMP5_NAME","COMP5_VAL"
from v$map_comp_list
SYS V_$MAP_ELEMENT 138 select
"ELEM_NAME","ELEM_IDX","ELEM_CFGID","ELEM_TYPE","ELEM_SIZE","ELEM_NSUBELEM","ELEM_DESCR","STRIPE_SIZE","LIB_IDX"
from v$map_element
SYS V_$MAP_EXT_ELEMENT 187 select
"ELEM_IDX","NUM_ATTRB","ATTRB1_NAME","ATTRB1_VAL","ATTRB2_NAME","ATTRB2_VAL","ATTRB3_NAME","ATTRB3_VAL","ATTRB4_NAME","ATTRB4_VAL","ATTRB5_NAME","ATTRB5_VAL"
from v$map_ext_element
SYS V_$MAP_FILE 140 select
"FILE_MAP_IDX","FILE_CFGID","FILE_STATUS","FILE_NAME","FILE_TYPE","FILE_STRUCTURE","FILE_SIZE","FILE_NEXTS","LIB_IDX"
from v$map_file
SYS V_$MAP_FILE_EXTENT 117 select
"FILE_MAP_IDX","EXT_NUM","EXT_ELEM_OFF","EXT_SIZE","EXT_FILE_OFF","EXT_TYPE","ELEM_IDX"
from v$map_file_extent
SYS V_$MAP_FILE_IO_STACK 179 select
"FILE_MAP_IDX","DEPTH","ELEM_IDX","CU_SIZE","STRIDE","NUM_CU","ELEM_OFFSET","FILE_OFFSET","DATA_TYPE","PARITY_POS","PARITY_PERIOD","ID","PARENT_ID"
from v$map_file_io_stack
SYS V_$MAP_LIBRARY 160 select
"LIB_IDX","LIB_NAME","VENDOR_NAME","PROTOCOL_NUM","VERSION_NUM","PATH_NAME","MAP_FILE","FILE_CFGID","MAP_ELEM","ELEM_CFGID","MAP_SYNC"
from v$map_library
SYS V_$MAP_SUBELEMENT 100 select
"CHILD_IDX","PARENT_IDX","SUB_NUM","SUB_SIZE","ELEM_OFFSET","SUB_FLAGS"
from v$map_subelement
SYS V_$MAX_ACTIVE_SESS_TARGET_MTH 47 select "NAME" from v
$max_active_sess_target_mth
SYS V_$MLS_PARAMETERS 181 "select
""NUM"",""NAME"",""TYPE"",""VALUE"",""ISDEFAULT"",""ISSES_MODIFIABLE"",""ISSYS_MODIFIABLE"",""ISMODIFIED"",""ISADJUSTED"",""DESCRIPTION"",""UPDATE_COMMENT""
from v$parameter
where name like 'mls%'"
SYS V_$MTS 135 select
"MAXIMUM_CONNECTIONS","MAXIMUM_SESSIONS","SERVERS_STARTED","SERVERS_TERMINATED","SERVERS_HIGHWATER"
from v$shared_server_monitor
SYS V_$MTTR_TARGET_ADVICE 224 "select
""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""
from
v$mttr_target_advice"
SYS V_$MVREFRESH 66 select "SID","SERIAL#","CURRMVOWNER","CURRMVNAME"
from v$mvrefresh
SYS V_$MYSTAT 47 select "SID","STATISTIC#","VALUE" from v$mystat
SYS V_$NLS_PARAMETERS 48 select "PARAMETER","VALUE" from v
$nls_parameters
SYS V_$NLS_VALID_VALUES 50 select "PARAMETER","VALUE" from v
$nls_valid_values
SYS V_$OBJECT_DEPENDENCY 112 select
"FROM_ADDRESS","FROM_HASH","TO_OWNER","TO_NAME","TO_ADDRESS","TO_HASH","TO_TYPE"
from v$object_dependency
SYS V_$OBSOLETE_PARAMETER 53 select "NAME","ISSPECIFIED" from v
$obsolete_parameter
SYS V_$OFFLINE_RANGE 100 select
"RECID","STAMP","FILE#","OFFLINE_CHANGE#","ONLINE_CHANGE#","ONLINE_TIME"
from v$offline_range
SYS V_$OPEN_CURSOR 85 select
"SADDR","SID","USER_NAME","ADDRESS","HASH_VALUE","SQL_TEXT" from v
$open_cursor
SYS V_$OPTION 40 select "PARAMETER","VALUE" from v$option
SYS V_$PARALLEL_DEGREE_LIMIT_MTH 46 select "NAME" from v
$parallel_degree_limit_mth
SYS V_$PARAMETER 158 select
"NUM","NAME","TYPE","VALUE","ISDEFAULT","ISSES_MODIFIABLE","ISSYS_MODIFIABLE","ISMODIFIED","ISADJUSTED","DESCRIPTION","UPDATE_COMMENT"
from v$parameter
SYS V_$PARAMETER2 169 select
"NUM","NAME","TYPE","VALUE","ISDEFAULT","ISSES_MODIFIABLE","ISSYS_MODIFIABLE","ISMODIFIED","ISADJUSTED","DESCRIPTION","ORDINAL","UPDATE_COMMENT"
from v$parameter2
SYS V_$PGASTAT 43 select "NAME","VALUE","UNIT" from v$pgastat
SYS V_$PGA_TARGET_ADVICE 188 select
"PGA_TARGET_FOR_ESTIMATE","PGA_TARGET_FACTOR","ADVICE_STATUS","BYTES_PROCESSED","ESTD_EXTRA_BYTES_RW","ESTD_PGA_CACHE_HIT_PERCENTAGE","ESTD_OVERALLOC_COUNT"
from v$pga_target_advice
SYS V_$PGA_TARGET_ADVICE_HISTOGRAM 274 select
"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"
from v$pga_target_advice_histogram
SYS V_$PQ_SESSTAT 65 select "STATISTIC","LAST_QUERY","SESSION_TOTAL"
from v$pq_sesstat
SYS V_$PQ_SLAVE 223 select
"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"
from v$pq_slave
SYS V_$PQ_SYSSTAT 44 select "STATISTIC","VALUE" from v$pq_sysstat
SYS V_$PQ_TQSTAT 143 select
"DFO_NUMBER","TQ_ID","SERVER_TYPE","NUM_ROWS","BYTES","OPEN_TIME","AVG_LATENCY","WAITS","TIMEOUTS","PROCESS","INSTANCE"
from v$pq_tqstat
SYS V_$PROCESS 194 select
"ADDR","PID","SPID","USERNAME","SERIAL#","TERMINAL","PROGRAM","TRACEID","BACKGROUND","LATCHWAIT","LATCHSPIN","PGA_USED_MEM","PGA_ALLOC_MEM","PGA_FREEABLE_MEM","PGA_MAX_MEM"
from v$process
SYS V_$PROXY_ARCHIVEDLOG 307 select
"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"
from v$proxy_archivedlog
SYS V_$PROXY_DATAFILE 513 select
"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"
from v$proxy_datafile
SYS V_$PWFILE_USERS 56 select "USERNAME","SYSDBA","SYSOPER" from v
$pwfile_users
SYS V_$PX_PROCESS 76 select
"SERVER_NAME","STATUS","PID","SPID","SID","SERIAL#" from v$px_process
SYS V_$PX_PROCESS_SYSSTAT 52 select "STATISTIC","VALUE" from v
$px_process_sysstat
SYS V_$PX_SESSION 140 select
"SADDR","SID","SERIAL#","QCSID","QCSERIAL#","QCINST_ID","SERVER_GROUP","SERVER_SET","SERVER#","DEGREE","REQ_DEGREE"
from v$px_session
SYS V_$PX_SESSTAT 161 select
"SADDR","SID","SERIAL#","QCSID","QCSERIAL#","QCINST_ID","SERVER_GROUP","SERVER_SET","SERVER#","DEGREE","REQ_DEGREE","STATISTIC#","VALUE"
from v$px_sesstat
SYS V_$QUEUE 59 select "PADDR","TYPE","QUEUED","WAIT","TOTALQ" from v
$queue
SYS V_$QUEUEING_MTH 33 select "NAME" from v$queueing_mth
SYS V_$RECOVERY_FILE_STATUS 64 select "FILENUM","FILENAME","STATUS"
from v$recovery_file_status
SYS V_$RECOVERY_LOG 70 select
"THREAD#","SEQUENCE#","TIME","ARCHIVE_NAME" from v$recovery_log
SYS V_$RECOVERY_PROGRESS 61 select "TYPE","ITEM","SOFAR","TOTAL" from v
$recovery_progress
SYS V_$RECOVERY_STATUS 156 select
"RECOVERY_CHECKPOINT","THREAD","SEQUENCE_NEEDED","SCN_NEEDED","TIME_NEEDED","PREVIOUS_LOG_NAME","PREVIOUS_LOG_STATUS","REASON"
from v$recovery_status
SYS V_$RECOVER_FILE 84 select
"FILE#","ONLINE","ONLINE_STATUS","ERROR","CHANGE#","TIME" from v
$recover_file
SYS V_$REPLPROP 79 select
"SID","SERIAL#","NAME","DBLINK","STATE","XID","SEQUENCE" from v
$replprop
SYS V_$REPLQUEUE 108 select
"TXNS_ENQUEUED","CALLS_ENQUEUED","TXNS_PURGED","LAST_ENQUEUE_TIME","LAST_PURGE_TIME"
from v$replqueue
SYS V_$REQDIST 38 select "BUCKET","COUNT" from v$reqdist
SYS V_$RESERVED_WORDS 47 select "KEYWORD","LENGTH" from v
$reserved_words
SYS V_$RESOURCE 48 select "ADDR","TYPE","ID1","ID2" from v$resource
SYS V_$RESOURCE_LIMIT 119 select
"RESOURCE_NAME","CURRENT_UTILIZATION","MAX_UTILIZATION","INITIAL_ALLOCATION","LIMIT_VALUE"
from v$resource_limit
SYS V_$RESUMABLE 223 select
"ADDR","SID","ENABLED","STATUS","TIMEOUT","SUSPEND_TIME","RESUME_TIME","NAME","ERROR_NUMBER","ERROR_PARAMETER1","ERROR_PARAMETER2","ERROR_PARAMETER3","ERROR_PARAMETER4","ERROR_PARAMETER5","ERROR_MSG"
from v$resumable
SYS V_$RMAN_CONFIGURATION 55 select "CONF#","NAME","VALUE" from v
$rman_configuration
SYS V_$ROLLNAME 121 "select x$kturd.kturdusn usn,undo$.name
from x$kturd, undo$
where x$kturd.kturdusn=undo$.us# and x$kturd.kturdsiz!=0"
SYS V_$ROLLSTAT 186 select
"USN","LATCH","EXTENTS","RSSIZE","WRITES","XACTS","GETS","WAITS","OPTSIZE","HWMSIZE","SHRINKS","WRAPS","EXTENDS","AVESHRINK","AVEACTIVE","STATUS","CUREXT","CURBLK"
from v$rollstat
SYS V_$ROWCACHE 217 select
"CACHE#","TYPE","SUBORDINATE#","PARAMETER","COUNT","USAGE","FIXED","GETS","GETMISSES","SCANS","SCANMISSES","SCANCOMPLETES","MODIFICATIONS","FLUSHES","DLM_REQUESTS","DLM_CONFLICTS","DLM_RELEASES"
from v$rowcache
SYS V_$ROWCACHE_PARENT 222 select
"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"
from v$rowcache_parent
SYS V_$ROWCACHE_SUBORDINATE 121 select
"INDX","HASH","ADDRESS","CACHE#","SUBCACHE#","SUBCACHE_NAME","EXISTENT","PARENT","KEY"
from v$rowcache_subordinate
SYS V_$RSRC_CONSUMER_GROUP 188 select
"NAME","ACTIVE_SESSIONS","EXECUTION_WAITERS","REQUESTS","CPU_WAIT_TIME","CPU_WAITS","CONSUMED_CPU_TIME","YIELDS","QUEUE_LENGTH","CURRENT_UNDO_CONSUMPTION"
from v$rsrc_consumer_group
SYS V_$RSRC_CONSUMER_GROUP_CPU_MTH 48 select "NAME" from v
$rsrc_consumer_group_cpu_mth
SYS V_$RSRC_PLAN 30 select "NAME" from v$rsrc_plan
SYS V_$RSRC_PLAN_CPU_MTH 38 select "NAME" from v$rsrc_plan_cpu_mth
SYS V_$SEGMENT_STATISTICS 165 select
"OWNER","OBJECT_NAME","SUBOBJECT_NAME","TABLESPACE_NAME","TS#","OBJ#","DATAOBJ#","OBJECT_TYPE","STATISTIC_NAME","STATISTIC#","VALUE"
from v$segment_statistics
SYS V_$SEGSTAT 83 select
"TS#","OBJ#","DATAOBJ#","STATISTIC_NAME","STATISTIC#","VALUE" from v
$segstat
SYS V_$SEGSTAT_NAME 56 select "STATISTIC#","NAME","SAMPLED" from v
$segstat_name
SYS V_$SESSION 635 select
"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"
from v$session
SYS V_$SESSION_CONNECT_INFO 96 select
"SID","AUTHENTICATION_TYPE","OSUSER","NETWORK_SERVICE_BANNER" from v
$session_connect_info
SYS V_$SESSION_CURSOR_CACHE 100 select
"MAXIMUM","COUNT","OPENED_ONCE","OPEN","OPENS","HITS","HIT_RATIO" from
v$session_cursor_cache
SYS V_$SESSION_EVENT 132 select
"SID","EVENT","TOTAL_WAITS","TOTAL_TIMEOUTS","TIME_WAITED","AVERAGE_WAIT","MAX_WAIT","TIME_WAITED_MICRO"
from v$session_event
SYS V_$SESSION_LONGOPS 242 select
"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"
from v$session_longops
SYS V_$SESSION_OBJECT_CACHE 252 select
"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"
from v$session_object_cache
SYS V_$SESSION_WAIT 151 select
"SID","SEQ#","EVENT","P1TEXT","P1","P1RAW","P2TEXT","P2","P2RAW","P3TEXT","P3","P3RAW","WAIT_TIME","SECONDS_IN_WAIT","STATE"
from v$session_wait
SYS V_$SESSTAT 48 select "SID","STATISTIC#","VALUE" from v$sesstat
SYS V_$SESS_IO 116 select
"SID","BLOCK_GETS","CONSISTENT_GETS","PHYSICAL_READS","BLOCK_CHANGES","CONSISTENT_CHANGES"
from sys.v$sess_io
SYS V_$SGA 32 select "NAME","VALUE" from v$sga
SYS V_$SGASTAT 43 select "POOL","NAME","BYTES" from v$sgastat
SYS V_$SGA_CURRENT_RESIZE_OPS 160 select
"COMPONENT","OPER_TYPE","OPER_MODE","PARAMETER","INITIAL_SIZE","TARGET_SIZE","CURRENT_SIZE","START_TIME","LAST_UPDATE_TIME"
from v$sga_current_resize_ops
SYS V_$SGA_DYNAMIC_COMPONENTS 164 select
"COMPONENT","CURRENT_SIZE","MIN_SIZE","MAX_SIZE","OPER_COUNT","LAST_OPER_TYPE","LAST_OPER_MODE","LAST_OPER_TIME","GRANULE_SIZE"
from v$sga_dynamic_components
SYS V_$SGA_DYNAMIC_FREE_MEMORY 52 select "CURRENT_SIZE" from v
$sga_dynamic_free_memory
SYS V_$SGA_RESIZE_OPS 151 select
"COMPONENT","OPER_TYPE","OPER_MODE","PARAMETER","INITIAL_SIZE","TARGET_SIZE","FINAL_SIZE","STATUS","START_TIME","END_TIME"
from v$sga_resize_ops
SYS V_$SHARED_POOL_ADVICE 208 select
"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"
from v$shared_pool_advice
SYS V_$SHARED_POOL_RESERVED 317 select
"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"
from v$shared_pool_reserved
SYS V_$SHARED_SERVER 114 select
"NAME","PADDR","STATUS","MESSAGES","BYTES","BREAKS","CIRCUIT","IDLE","BUSY","REQUESTS"
from v$shared_server
SYS V_$SHARED_SERVER_MONITOR 135 select
"MAXIMUM_CONNECTIONS","MAXIMUM_SESSIONS","SERVERS_STARTED","SERVERS_TERMINATED","SERVERS_HIGHWATER"
from v$shared_server_monitor
SYS V_$SORT_SEGMENT 363 select
"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"
from v$sort_segment
SYS V_$SORT_USAGE 176 select
"USERNAME","USER","SESSION_ADDR","SESSION_NUM","SQLADDR","SQLHASH","TABLESPACE","CONTENTS","SEGTYPE","SEGFILE#","SEGBLK#","EXTENTS","BLOCKS","SEGRFNO#"
from v$sort_usage
SYS V_$SPPARAMETER 87 select
"SID","NAME","VALUE","ISSPECIFIED","ORDINAL","UPDATE_COMMENT" from v
$spparameter
SYS V_$SQL 692 select
"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","IS_OBSOLETE","CHILD_LATCH"
from v$sql
SYS V_$SQLAREA 524 select
"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"
from v$sqlarea
SYS V_$SQLTEXT 78 select
"ADDRESS","HASH_VALUE","COMMAND_TYPE","PIECE","SQL_TEXT" from v
$sqltext
SYS V_$SQLTEXT_WITH_NEWLINES 92 select
"ADDRESS","HASH_VALUE","COMMAND_TYPE","PIECE","SQL_TEXT" from v
$sqltext_with_newlines
SYS V_$SQLXS 628 "select max(sql_text) sql_text
, sum(sharable_mem) sharable_mem
, sum(sorts) sorts
, min(module) module
, sum(loaded_versions) loaded_versions
, sum(executions) executions
, sum(loads) loads
, sum(invalidations) invalidations
, sum(parse_calls) parse_calls
, sum(disk_reads) disk_reads
, sum(buffer_gets) buffer_gets
, sum(rows_processed) rows_processed
, address address
, hash_value hash_value
, count(1) version_count
from v$sql
group by hash_value, address"
SYS V_$SQL_BIND_DATA 230 select
"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"
from v$sql_bind_data
SYS V_$SQL_BIND_METADATA 100 select
"ADDRESS","POSITION","DATATYPE","MAX_LENGTH","ARRAY_LEN","BIND_NAME"
from v$sql_bind_metadata
SYS V_$SQL_CURSOR 201 select
"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"
from v$sql_cursor
SYS V_$SQL_PLAN 388 select
"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"
from v$sql_plan
SYS V_$SQL_PLAN_STATISTICS 332 select
"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"
from v$sql_plan_statistics
SYS V_$SQL_PLAN_STATISTICS_ALL 897 select
"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","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"
from v$sql_plan_statistics_all
SYS V_$SQL_REDIRECTION 202 select
"ADDRESS","PARENT_HANDLE","HASH_VALUE","CHILD_NUMBER","PARSING_USER_ID","PARSING_SCHEMA_ID","COMMAND_TYPE","REASON","ERROR_CODE","POSITION","SQL_TEXT_PIECE","ERROR_MESSAGE"
from v$sql_redirection
SYS V_$SQL_SHARED_CURSOR 715 select
"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"
from v$sql_shared_cursor
SYS V_$SQL_SHARED_MEMORY 169 select
"SQL_TEXT","HASH_VALUE","HEAP_DESC","STRUCTURE","FUNCTION","CHUNK_COM","CHUNK_PTR","CHUNK_SIZE","ALLOC_CLASS","CHUNK_TYPE","SUBHEAP_DESC"
from v$sql_shared_memory
SYS V_$SQL_WORKAREA 363 select
"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"
from v$sql_workarea
SYS V_$SQL_WORKAREA_ACTIVE 264 select
"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#"
from v$sql_workarea_active
SYS V_$SQL_WORKAREA_HISTOGRAM 161 select
"LOW_OPTIMAL_SIZE","HIGH_OPTIMAL_SIZE","OPTIMAL_EXECUTIONS","ONEPASS_EXECUTIONS","MULTIPASSES_EXECUTIONS","TOTAL_EXECUTIONS"
from v$sql_workarea_histogram
SYS V_$STANDBY_LOG 147 select
"GROUP#","THREAD#","SEQUENCE#","BYTES","USED","ARCHIVED","STATUS","FIRST_CHANGE#","FIRST_TIME","LAST_CHANGE#","LAST_TIME"
from v$standby_log
SYS V_$STATISTICS_LEVEL 159 "select
""STATISTICS_NAME"",""DESCRIPTION"",""SESSION_STATUS"",""SYSTEM_STATUS"",""ACTIVATION_LEVEL"",""STATISTICS_VIEW_NAME"",""SESSION_SETTABLE""
from
v$statistics_level"
SYS V_$STATNAME 50 select "STATISTIC#","NAME","CLASS" from v$statname
SYS V_$STREAMS_APPLY_COORDINATOR 358 select
"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"
from v$streams_apply_coordinator
SYS V_$STREAMS_APPLY_READER 236 select
"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"
from v$streams_apply_reader
SYS V_$STREAMS_APPLY_SERVER 373 select
"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"
from v$streams_apply_server
SYS V_$STREAMS_CAPTURE 371 select
"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"
from v$streams_capture
SYS V_$SUBCACHE 117 select
"OWNER_NAME","NAME","TYPE","HEAP_NUM","CACHE_ID","CACHE_CNT","HEAP_SZ","HEAP_ALOC","HEAP_USED"
from v$subcache
SYS V_$SYSSTAT 57 select "STATISTIC#","NAME","CLASS","VALUE" from v
$sysstat
SYS V_$SYSTEM_CURSOR_CACHE 60 select "OPENS","HITS","HIT_RATIO" from v
$system_cursor_cache
SYS V_$SYSTEM_EVENT 114 select
"EVENT","TOTAL_WAITS","TOTAL_TIMEOUTS","TIME_WAITED","AVERAGE_WAIT","TIME_WAITED_MICRO"
from v$system_event
SYS V_$SYSTEM_PARAMETER 165 select
"NUM","NAME","TYPE","VALUE","ISDEFAULT","ISSES_MODIFIABLE","ISSYS_MODIFIABLE","ISMODIFIED","ISADJUSTED","DESCRIPTION","UPDATE_COMMENT"
from v$system_parameter
SYS V_$SYSTEM_PARAMETER2 176 select
"NUM","NAME","TYPE","VALUE","ISDEFAULT","ISSES_MODIFIABLE","ISSYS_MODIFIABLE","ISMODIFIED","ISADJUSTED","DESCRIPTION","ORDINAL","UPDATE_COMMENT"
from v$system_parameter2
SYS V_$TABLESPACE 67 select "TS#","NAME","INCLUDED_IN_DATABASE_BACKUP"
from v$tablespace
SYS V_$TEMPFILE 151 select
"FILE#","CREATION_CHANGE#","CREATION_TIME","TS#","RFILE#","STATUS","ENABLED","BYTES","BLOCKS","CREATE_BYTES","BLOCK_SIZE","NAME"
from v$tempfile
SYS V_$TEMPORARY_LOBS 62 select "SID","CACHE_LOBS","NOCACHE_LOBS" from
v$temporary_lobs
SYS V_$TEMPSTAT 180 select
"FILE#","PHYRDS","PHYWRTS","PHYBLKRD","PHYBLKWRT","SINGLEBLKRDS","READTIM","WRITETIM","SINGLEBLKRDTIM","AVGIOTIM","LSTIOTIM","MINIOTIM","MAXIORTM","MAXIOWTM"
from v$tempstat
SYS V_$TEMPSTATXS 398 "select ts.name tsname
, tf.name filename
, tm.phyrds
, tm.phywrts
, tm.readtim
, tm.writetim
, tm.phyblkrd
, tm.phyblkwrt
, fw.count wait_count
, fw.time time
from x$kcbfwait fw
, v$tempstat tm
, v$tablespace ts
, v$tempfile tf
where ts.ts# = tf.ts#
and tm.file# = tf.file#
and fw.indx+1 = tf.file#"
SYS V_$TEMP_CACHE_TRANSFER 225 select
"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","NULL_2_X","S_2_X","NULL_2_S"
from v$temp_cache_transfer
SYS V_$TEMP_EXTENT_MAP 108 select
"TABLESPACE_NAME","FILE_ID","BLOCK_ID","BYTES","BLOCKS","OWNER","RELATIVE_FNO"
from v$temp_extent_map
SYS V_$TEMP_EXTENT_POOL 163 select
"TABLESPACE_NAME","FILE_ID","EXTENTS_CACHED","EXTENTS_USED","BLOCKS_CACHED","BLOCKS_USED","BYTES_CACHED","BYTES_USED","RELATIVE_FNO"
from v$temp_extent_pool
SYS V_$TEMP_PING 384 select
"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"
from v$temp_ping
SYS V_$TEMP_SPACE_HEADER 128 select
"TABLESPACE_NAME","FILE_ID","BYTES_USED","BLOCKS_USED","BYTES_FREE","BLOCKS_FREE","RELATIVE_FNO"
from v$temp_space_header
SYS V_$THREAD 213 select
"THREAD#","STATUS","ENABLED","GROUPS","INSTANCE","OPEN_TIME","CURRENT_GROUP#","SEQUENCE#","CHECKPOINT_CHANGE#","CHECKPOINT_TIME","ENABLE_CHANGE#","ENABLE_TIME","DISABLE_CHANGE#","DISABLE_TIME"
from v$thread
SYS V_$TIMER 27 select "HSECS" from v$timer
SYS V_$TIMEZONE_NAMES 48 select "TZNAME","TZABBREV" from v
$timezone_names
SYS V_$TRANSACTION 436 select
"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" from
v$transaction
SYS V_$TRANSACTION_ENQUEUE 107 select
"ADDR","KADDR","SID","TYPE","ID1","ID2","LMODE","REQUEST","CTIME","BLOCK"
from v$transaction_enqueue
SYS V_$TYPE_SIZE 68 select
"COMPONENT","TYPE","DESCRIPTION","TYPE_SIZE" from v$type_size
SYS V_$UNDOSTAT 230 select
"BEGIN_TIME","END_TIME","UNDOTSN","UNDOBLKS","TXNCOUNT","MAXQUERYLEN","MAXCONCURRENCY","UNXPSTEALCNT","UNXPBLKRELCNT","UNXPBLKREUCNT","EXPSTEALCNT","EXPBLKRELCNT","EXPBLKREUCNT","SSOLDERRCNT","NOSPACEERRCNT"
from v$undostat
SYS V_$VERSION 30 select "BANNER" from v$version
SYS V_$VPD_POLICY 159 select
"ADDRESS","PARADDR","SQL_HASH","CHILD_NUMBER","OBJECT_OWNER","OBJECT_NAME","POLICY_GROUP","POLICY","POLICY_FUNCTION_OWNER","PREDICATE"
from v$vpd_policy
SYS V_$WAITSTAT 45 select "CLASS","COUNT","TIME" from v$waitstat
SYS V_$_LOCK 85 select
"LADDR","KADDR","SADDR","RADDR","LMODE","REQUEST","CTIME","BLOCK" from
v$_lock