ORACLE中常到的SQL

1.查看各参数配置情况

select   *   from   v$system_parameter;

2.查看数据库文件情况

select name from v$datafile;

3.查看日志文件情况

select member from v$logfile;

4.查看控制文件情况 

select name from v$controlfile;

转载于:https://blog.51cto.com/38554/192132