| v$instance |
数据库实例的基本信息 |
select * from v$instance; |
| v$datafile |
数据文件的基本信息 |
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 |
数据库的基本信息 |
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 |
日志文件参数信息 |
show parameter log_archive_dest; |
| v$parameter |
访问参数文件 |
select num,name,description,type,value,display_value, isdefault,isses_modifiable, issys_modifiable,isinstance_modifiable from v$parameter; |
| v$bgprocess |
后台进程信息 |
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 用户的所有的触发器的基本信息 |
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 用户的所有的区的基本信息 |
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 |
当前用户可以访问的所有的基表 |
select table_name from cat; |
| system.tab |
当前用户可以访问的所有的基表，视图，同义词 |
select tname,tabtype,clusterid from system.tab; |
| dict |
构成数据字典的所有的表信息 |
select table_name,comments from dict; |
| dba_tablespaces/dba_free_space |
查询关于表空间的一些基本的数据字典 |
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 |
归档状态的一些基本信息 |
select name,dest_id,blocks,block_size, archived,status,backup_count from v$archived_log; |
| v$sga |
关于内存结构的一些信息 |
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; |
