Oracle PL/SQL/System Tables Views/dba views

Query dba_views table

 
SQL>
SQL> set heading off
SQL> set long 99999999
SQL> set feedback off
SQL> set linesize 1000
SQL> set trimspool on
SQL> set verify off
SQL> set termout off
SQL> set embedded on
SQL>
SQL> select text
  2    from dba_views
  3   where rownum < 50
  4  /
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
select "FILE_MAP_IDX","FILE_CFGID","FILE_STATUS","FILE_NAME","FILE_TYPE","FILE_STRUCTURE","FILE_SIZE","FILE_NEXTS","LIB_IDX" from v$map_file
select "FILE_MAP_IDX","EXT_NUM","EXT_ELEM_OFF","EXT_SIZE","EXT_FILE_OFF","EXT_TYPE","ELEM_IDX" from v$map_file_extent
select "ELEM_NAME","ELEM_IDX","ELEM_CFGID","ELEM_TYPE","ELEM_SIZE","ELEM_NSUBELEM","ELEM_DESCR","STRIPE_SIZE","LIB_IDX" from v$map_element
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
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
select "CHILD_IDX","PARENT_IDX","SUB_NUM","SUB_SIZE","ELEM_OFFSET","SUB_FLAGS" from v$map_subelement
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
select "ADDRESS","PARENT_HANDLE","HASH_VALUE","SQL_ID","CHILD_NUMBER","PARSING_USER_ID","PARSING_SCHEMA_ID","COMMAND_TYPE","REASON","ERROR_CODE","POSITION","SQL_TEXT_PIECE","ERROR_MESSAGE" from v$sql_redirection
select "ADDRESS","HASH_VALUE","SQL_ID","PLAN_HASH_VALUE","CHILD_ADDRESS","CHILD_NUMBER","TIMESTAMP","OPERATION","OPTIONS","OBJECT_NODE","OBJECT#","OBJECT_OWNER","OBJECT_NAME","OBJECT_ALIAS","OBJECT_TYPE","OPTIMIZER","ID","PARENT_ID","DEPTH","POSITION","SEARCH_COLUMNS","COST","CARDINALITY","BYTES","O
THER_TAG","PARTITION_START","PARTITION_STOP","PARTITION_ID","OTHER","DISTRIBUTION","CPU_COST","IO_COST","TEMP_SPACE","ACCESS_PREDICATES","FILTER_PREDICATES","PROJECTION","TIME","QBLOCK_NAME","REMARKS","OTHER_XML" from v$sql_plan
select "ADDRESS","HASH_VALUE","SQL_ID","PLAN_HASH_VALUE","CHILD_ADDRESS","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
select "ADDRESS","HASH_VALUE","SQL_ID","PLAN_HASH_VALUE","CHILD_ADDRESS","CHILD_NUMBER","TIMESTAMP","OPERATION","OPTIONS","OBJECT_NODE","OBJECT#","OBJECT_OWNER","OBJECT_NAME","OBJECT_ALIAS","OBJECT_TYPE","OPTIMIZER","ID","PARENT_ID","DEPTH","POSITION","SEARCH_COLUMNS","COST","CARDINALITY","BYTES","O
THER_TAG","PARTITION_START","PARTITION_STOP","PARTITION_ID","OTHER","DISTRIBUTION","CPU_COST","IO_COST","TEMP_SPACE","ACCESS_PREDICATES","FILTER_PREDICATES","PROJECTION","TIME","QBLOCK_NAME","REMARKS","OTHER_XML","EXECUTIONS","LAST_STARTS","STARTS","LAST_OUTPUT_ROWS","OUTPUT_ROWS","LAST_CR_BUFFER_GE
TS","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_EXEC
UTIONS","ONEPASS_EXECUTIONS","MULTIPASSES_EXECUTIONS","ACTIVE_TIME","MAX_TEMPSEG_SIZE","LAST_TEMPSEG
_SIZE" from v$sql_plan_statistics_all
select "ADDRESS","HASH_VALUE","SQL_ID","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
select "SQL_HASH_VALUE","SQL_ID","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
select "LOW_OPTIMAL_SIZE","HIGH_OPTIMAL_SIZE","OPTIMAL_EXECUTIONS","ONEPASS_EXECUTIONS","MULTIPASSES_EXECUTIONS","TOTAL_EXECUTIONS" from v$sql_workarea_histogram
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
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
select "NAME","VALUE","UNIT" from v$pgastat
select "ID","NAME","ISDEFAULT","VALUE","DEFAULT_VALUE" from v$sys_optimizer_env
select "SID","ID","NAME","ISDEFAULT","VALUE" from v$ses_optimizer_env
select "ADDRESS","HASH_VALUE","SQL_ID","CHILD_ADDRESS","CHILD_NUMBER","ID","NAME","ISDEFAULT","VALUE" from v$sql_optimizer_env
select "STATISTIC#","NAME","VALUE" from v$dlm_misc
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
select "INST_ID","CONVERT_TYPE","AVERAGE_CONVERT_TIME","CONVERT_COUNT" from v$dlm_convert_local
select "INST_ID","CONVERT_TYPE","AVERAGE_CONVERT_TIME","CONVERT_COUNT" from v$dlm_convert_remote
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_DU
BVALUE","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
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_DU
BVALUE","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
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
select "HV_ID","CURRENT_MASTER","PREVIOUS_MASTER","REMASTER_CNT" from v$hvmaster_info
select "HV_ID","CURRENT_MASTER","PREVIOUS_MASTER","REMASTER_CNT" from v$gcshvmaster_info
select "FILE_ID","OBJECT_ID","CURRENT_MASTER","PREVIOUS_MASTER","REMASTER_CNT" from v$gcspfmaster_info
select "INST_ID","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 gv$dlm_traffic_controller
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
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_D
UBVALUE","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
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_D
UBVALUE","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
select "GC_ELEMENT_ADDR","INDX","CLASS","GC_ELEMENT_NAME","MODE_HELD","BLOCK_COUNT","RELEASING","ACQUIRING","WRITING","RECOVERING","LOCAL","FLAGS" from v$gc_element
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","LI
GHT_WORKS","ERRORS" from v$cr_block_server
select "PIN1","PIN10","PIN100","PIN1000","PIN10000","FLUSH1","FLUSH10","FLUSH100","FLUSH1000","FLUSH10000","WRITE1","WRITE10","WRITE100","WRITE1000","WRITE10000" from v$current_block_server
select "GC_ELEMENT_ADDR" from v$gc_elements_with_collisions
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
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
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","CR_TRANSFER","CURRENT_TRANSFER" from v$class_cache_transfer
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
select "LOCK_ELEMENT_ADDR","INDX","CLASS","LOCK_ELEMENT_NAME","MODE_HELD","BLOCK_COUNT","RELEASING","ACQUIRING","INVALID","FLAGS" from v$lock_element
select "LOCK_ELEMENT_ADDR" from v$locks_with_collisions
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_W
RITE","NULL_2_X","S_2_X","SSX_2_X","NULL_2_S","NULL_2_SS","OP_2_SS" from v$file_ping
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_W
RITE","NULL_2_X","S_2_X","SSX_2_X","NULL_2_S","NULL_2_SS","OP_2_SS" from v$temp_ping
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
select "INSTANCE","CLASS","CR_BLOCK","CR_BUSY","CR_CONGESTED","CURRENT_BLOCK","CURRENT_BUSY","CURRENT_CONGESTED" from v$instance_cache_transfer
SQL>
SQL> set termout on
SQL> set heading on
SQL> set feedback on
SQL> set verify on
SQL>
SQL>