| v$instance |
數(shù)據(jù)庫實例的基本信息 |
select * from v$instance; |
| v$datafile |
數(shù)據(jù)文件的基本信息 |
select * from v$datafile; |
| dba_data_files |
dba_data_files |
select file_name,file_id,tablespace_name,bytes,blocks,status,online_status from dba_data_files; |
| dba_temp_files |
臨時文件的基本信息 |
select file_name,file_id,tablespace_name,status, bytes/1024/1024 大小MB from dba_temp_files; |
| v$controlfile |
控制文件的基本信息 |
select name,status,is_recovery_dest_file, block_size,file_size_blks from v$controlfile; |
| v$logfile |
日志文件的基本信息 |
select group#,status,type,member,is_recovery_dest_file from v$logfile; |
| v$database |
數(shù)據(jù)庫的基本信息 |
select dbid,name,created熙涤，resetlogs_time,log_mode, open_mode,checkpoint_change#,archive_change#, controlfile_created,controlfile_type, controlfile_sequence#,controlfile_change#, controlfile_time,protection_mode,database_role from v$database; |
| log_archive_dest |
日志文件參數(shù)信息 |
show parameter log_archive_dest; |
| v$parameter |
訪問參數(shù)文件 |
select num,name,description,type,value,display_value, isdefault,isses_modifiable, issys_modifiable,isinstance_modifiable from v$parameter; |
| v$bgprocess |
后臺進(jìn)程信息 |
select paddr,pserial#,name,description,error from v$bgprocess; |
| dba_tables |
DBA 用戶的所有的表的基本信息 |
select owner,table_name,column_name,data_type,data_length, global_stats,data_upgraded,histogram from dba_tab_columns; |
| dba_views |
DBA 用戶的所有的視圖的基本信息 |
select owner,view_name,read_only from dba_views; |
| dba_synonyms |
DBA 用戶的所有的同義詞的基本信息 |
select owner,synonym_name,table_owner, table_name,db_link from dba_synonyms; |
| dba_sequences |
DBA 用戶的所有的序列的信息 |
select sequence_owner,sequence_name,min_value,max_value, cycle_flag from dba_sequences; |
| dba_constraints |
DBA 用戶的所有的約束的信息 |
select owner,constraint_name,constraint_type, table_name,status from dba_constraints; |
| dba_indexes |
DBA 用戶的所有的索引的基本信息 |
select owner,index_name,index_type,table_owner,table_name, table_type,uniqueness,compression,logging,status from dba_indexes; |
| dba_triggers |
DBA 用戶的所有的觸發(fā)器的基本信息 |
select owner,trigger_name,trigger_type, table_owner,table_name,column_name from dba_triggers; |
| dba_source |
DBA 用戶的所有的存儲過程的基本信息 |
select owner,name,type,line,text from dba_source; |
| dba_segments |
DBA 用戶的所有的段的基本信息 |
select owner,segment_name,segment_type, tablespace_name,blocks,extents from dba_segments; |
| dba_extents |
DBA 用戶的所有的區(qū)的基本信息 |
select owner,segment_name,segment_type, tablespace_name,extent_id,file_id,blocks from dba_extents; |
| dba_objects |
DBA 用戶的所有的對象的基本信息 |
select owner,object_name,subobject_name, object_id,data_object_id,object_type, created,status,namespace from dba_objects; |
| cat |
當(dāng)前用戶可以訪問的所有的基表 |
select table_name from cat; |
| system.tab |
當(dāng)前用戶可以訪問的所有的基表阁苞，視圖，同義詞 |
select tname,tabtype,clusterid from system.tab; |
| dict |
構(gòu)成數(shù)據(jù)字典的所有的表信息 |
select table_name,comments from dict; |
| dba_tablespaces/dba_free_space |
查詢關(guān)于表空間的一些基本的數(shù)據(jù)字典 |
select tablespace_name,block_size,status, logging,extent_management from dba_tablespaces; select tablespace_name,file_id,block_id, bytes/1024/1024 大小MB,blocks,relative_fno from dba_free_space; |
| v$archived_log |
歸檔狀態(tài)的一些基本信息 |
select name,dest_id,blocks,block_size, archived,status,backup_count from v$archived_log; |
| v$sga |
關(guān)于內(nèi)存結(jié)構(gòu)的一些信息 |
select name,value/1024/1024 大小MB from v$sga; |
| v$sgastat |
|
select pool,name,bytes from v$sgastat; |
| v$db_object_cache |
|
select owner,name,db_link,type,namespace,locks from v$db_object_cache; |
| $sql |
|
select sql_text,sql_id,cpu_time from v$sql; |
