oracle管理账号查询,Oracle管理查询管用的sql语句_MySQL

Oracle日常管理用到的一些sql语句

表空间及容量&＃xff1a;

select tablespace_name,sum(bytes)/1024/1024/1024 from dba_data_files group by tablespace_name;

表空间的空闲容量&＃xff1a;

select tablespace_name,sum(bytes) from dba_free_space group by tablespace_name;

系统表空间&＃xff1a;

select tablespace_name from dba_tablespaces;

系统数据文件&＃xff1a;

select file_name from dba_data_files;

系统控制文件&＃xff1a;

select value from v$parameter where name&＃61;’control_files’;

系统重做日志文件&＃xff1a;

select member from v$logfile;

归档日志文件&＃xff1a;

select value from v$parameter where name&＃61;’log_archive_dest’

本文原创发布php中文网&＃xff0c;转载请注明出处&＃xff0c;感谢您的尊重&＃xff01;