http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2Fdba_views
Oracle PL/SQL/System Tables Views/dba views - История изменений
2026-04-05T04:58:45Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/dba_views&diff=2180&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:19Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/dba_views&diff=2181&oldid=prev
Admin: 1 версия
2010-05-26T10:01:07Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Query dba_views table==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> set heading off<br />
SQL> set long 99999999<br />
SQL> set feedback off<br />
SQL> set linesize 1000<br />
SQL> set trimspool on<br />
SQL> set verify off<br />
SQL> set termout off<br />
SQL> set embedded on<br />
SQL><br />
SQL> select text<br />
2 from dba_views<br />
3 where rownum < 50<br />
4 /<br />
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<br />
select "FILE_MAP_IDX","FILE_CFGID","FILE_STATUS","FILE_NAME","FILE_TYPE","FILE_STRUCTURE","FILE_SIZE","FILE_NEXTS","LIB_IDX" from v$map_file<br />
select "FILE_MAP_IDX","EXT_NUM","EXT_ELEM_OFF","EXT_SIZE","EXT_FILE_OFF","EXT_TYPE","ELEM_IDX" from v$map_file_extent<br />
select "ELEM_NAME","ELEM_IDX","ELEM_CFGID","ELEM_TYPE","ELEM_SIZE","ELEM_NSUBELEM","ELEM_DESCR","STRIPE_SIZE","LIB_IDX" from v$map_element<br />
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<br />
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<br />
select "CHILD_IDX","PARENT_IDX","SUB_NUM","SUB_SIZE","ELEM_OFFSET","SUB_FLAGS" from v$map_subelement<br />
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<br />
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<br />
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<br />
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<br />
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",<br />
"DISK_WRITES","LAST_ELAPSED_TIME","ELAPSED_TIME" from v$sql_plan_statistics<br />
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<br />
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<br />
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<br />
UTIONS","ONEPASS_EXECUTIONS","MULTIPASSES_EXECUTIONS","ACTIVE_TIME","MAX_TEMPSEG_SIZE","LAST_TEMPSEG<br />
_SIZE" from v$sql_plan_statistics_all<br />
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",<br />
"ACTIVE_TIME","MAX_TEMPSEG_SIZE","LAST_TEMPSEG_SIZE" from v$sql_workarea<br />
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<br />
select "LOW_OPTIMAL_SIZE","HIGH_OPTIMAL_SIZE","OPTIMAL_EXECUTIONS","ONEPASS_EXECUTIONS","MULTIPASSES_EXECUTIONS","TOTAL_EXECUTIONS" from v$sql_workarea_histogram<br />
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<br />
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<br />
select "NAME","VALUE","UNIT" from v$pgastat<br />
select "ID","NAME","ISDEFAULT","VALUE","DEFAULT_VALUE" from v$sys_optimizer_env<br />
select "SID","ID","NAME","ISDEFAULT","VALUE" from v$ses_optimizer_env<br />
select "ADDRESS","HASH_VALUE","SQL_ID","CHILD_ADDRESS","CHILD_NUMBER","ID","NAME","ISDEFAULT","VALUE" from v$sql_optimizer_env<br />
select "STATISTIC#","NAME","VALUE" from v$dlm_misc<br />
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<br />
select "INST_ID","CONVERT_TYPE","AVERAGE_CONVERT_TIME","CONVERT_COUNT" from v$dlm_convert_local<br />
select "INST_ID","CONVERT_TYPE","AVERAGE_CONVERT_TIME","CONVERT_COUNT" from v$dlm_convert_remote<br />
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<br />
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<br />
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<br />
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<br />
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<br />
select "HV_ID","CURRENT_MASTER","PREVIOUS_MASTER","REMASTER_CNT" from v$hvmaster_info<br />
select "HV_ID","CURRENT_MASTER","PREVIOUS_MASTER","REMASTER_CNT" from v$gcshvmaster_info<br />
select "FILE_ID","OBJECT_ID","CURRENT_MASTER","PREVIOUS_MASTER","REMASTER_CNT" from v$gcspfmaster_info<br />
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<br />
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<br />
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<br />
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<br />
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<br />
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<br />
select "GC_ELEMENT_ADDR","INDX","CLASS","GC_ELEMENT_NAME","MODE_HELD","BLOCK_COUNT","RELEASING","ACQUIRING","WRITING","RECOVERING","LOCAL","FLAGS" from v$gc_element<br />
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<br />
GHT_WORKS","ERRORS" from v$cr_block_server<br />
select "PIN1","PIN10","PIN100","PIN1000","PIN10000","FLUSH1","FLUSH10","FLUSH100","FLUSH1000","FLUSH10000","WRITE1","WRITE10","WRITE100","WRITE1000","WRITE10000" from v$current_block_server<br />
select "GC_ELEMENT_ADDR" from v$gc_elements_with_collisions<br />
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<br />
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<br />
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<br />
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<br />
select "LOCK_ELEMENT_ADDR","INDX","CLASS","LOCK_ELEMENT_NAME","MODE_HELD","BLOCK_COUNT","RELEASING","ACQUIRING","INVALID","FLAGS" from v$lock_element<br />
select "LOCK_ELEMENT_ADDR" from v$locks_with_collisions<br />
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<br />
RITE","NULL_2_X","S_2_X","SSX_2_X","NULL_2_S","NULL_2_SS","OP_2_SS" from v$file_ping<br />
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<br />
RITE","NULL_2_X","S_2_X","SSX_2_X","NULL_2_S","NULL_2_SS","OP_2_SS" from v$temp_ping<br />
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<br />
select "INSTANCE","CLASS","CR_BLOCK","CR_BUSY","CR_CONGESTED","CURRENT_BLOCK","CURRENT_BUSY","CURRENT_CONGESTED" from v$instance_cache_transfer<br />
SQL><br />
SQL> set termout on<br />
SQL> set heading on<br />
SQL> set feedback on<br />
SQL> set verify on<br />
SQL><br />
SQL> <br />
</source></div>
Admin