Oracle PL/SQL/System Tables Views/dba views

Query dba_views table

   <source lang="sql">

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>

</source>