Oracle日常治理用到的一些sql语句
继续添加中
表空间及容量:
select tablespace_name,sum(bytes)/1024/1024/1024 from dba_data_files group by tablespace_name;
表空间的空闲容量:
select tablespace_name,sum(bytes) from dba_free_space group by tablespace_name;
系统表空间:
select tablespace_name from dba_tablespaces;
系统数据文件:
select file_name from dba_data_files;
系统控制文件:
select value from v$parameter where name='control_files';
系统重做日志文件:
select member from v$logfile;
归档日志文件:
select value from v$parameter where name='log_archive_dest';