ITPub博客

首页 > Linux操作系统 > Linux操作系统 > df_tbs

df_tbs

原创 Linux操作系统 作者:tthero00boo 时间:2013-11-09 22:17:23 0 删除 编辑

# --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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-06-30

  • 博文量
    31
  • 访问量
    142151