查询表空间的位置

select t.file_name,t.tablespace_name from dba_data_files t;

查看临时表空间的位置

select t.file_name,t.tablespace_name from dba_temp_files t;

select t.NAME from v$controlfile t;

select t.MEMBER from v$logfile t;

select t.DBID,t.NAME,t.LOG_MODE from v$database t;

select t.NAME,t.VALUE,t.ISMODIFIED from v$parameter t;
show parameter;

select t.NAME,t.VALUE,t.ISMODIFIED from v$parameter t where t.Name='lock_name_space';
show parameter lock_name_space;

select t.NAME,t.VALUE from v$parameter t where t.NAME='background_dump_dest';

select t.NAME,t.VALUE from v$parameter t where t.NAME='user_dump_dest';