df_tbs

# --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/