# --dict 数据字典视图 dba_,gv$,v$
# --v$fixed_table 基表 x$,gv$,v$
select * from dict;
select * from dict_column;
select * from v$fixed_table;
select * from v$fixed_view_definition;
select NAME,LOG_MODE,OPEN_MODE from v$database; --这里OPEN_MODE才能体现read only
select instance_name,version,status,archiver,database_status from v$instance;
select * from v$controlfile;
col name for a50
select a.file#,a.TS#,a.BYTES/1024/1024 size_M,a.NAME,status from v$datafile a order by a.ts#;
select * from v$tempfile;
select * from v$logfile; --需结合v$log查询current select * from v$log;
select * from v$archived_log;
select * from v$backup;
select * from v$tablespace;
show parameter dump;
show parameter arch;
show parameter control_file;
show parameter diag;
show parameter listen;
select * from dba_data_files;
select * from dba_tablespaces;
select * from dba_segments;
select * from dba_extents;
select * from dba_objects a where a.OBJECT_TYPE = 'TABLE';
select * from dba_views;
select * from dba_tables;
select * from dba_tab_cols;
select * from dba_indexes;
select * from dba_ind_columns;
select * from dba_users;
select * from dba_profiles;
select * from dba_roles;
select * from dba_role_privs;
select * from dba_rollback_segs;
select * from v$rollname;
select * from v$rollstat;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28859270/viewspace-776215/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28859270/viewspace-776215/