本文共 2695 字，大约阅读时间需要 8 分钟。
SQL> show parameter audit_file_dest;
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_file_dest string /u01/app/oracle/admin/orcl/adump SQL> SQL> SQL> show parameter audit_file_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_file_dest string /u01/app/oracle/admin/orcl/adump SQL> show parameter audit_trail; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_trail string DB SQL> show parameter compatible; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ compatible string 11.2.0.4.0 SQL> show parameter control_files; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_files string /u01/app/oracle/oradata/orcl/control01.ctl, /u01/app/oracle/fast_recovery_area/orcl/control02.ctl SQL> show parameter db_block_size; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_block_size integer 8192 SQL> show parameter db_name; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_name string orcl SQL> show parameter db_file_name_convert; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_file_name_convert stringSQL> show parameter db_file_name_convert;
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_file_name_convert string SQL> SQL> show parameter db_file_name; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_file_name_convert string SQL> show parameter log_file_name; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_file_name_convert string SQL>以及：
SQL> column name format a50;
SQL> select file# as filenum, name from v$datafile; FILENUM NAME ------- -------------------------------------------------- 1 /u01/app/oracle/oradata/orcl/system01.dbf 2 /u01/app/oracle/oradata/orcl/sysaux01.dbf 3 /u01/app/oracle/oradata/orcl/undotbs01.dbf 4 /u01/app/oracle/oradata/orcl/users01.dbf 5 /u01/app/oracle/oradata/orcl/example01.dbf SQL>SQL> column member format a50;
SQL> select group#,member from v$logfile; GROUP# MEMBER ---------- -------------------------------------------------- 3 /u01/app/oracle/oradata/orcl/redo03.log 2 /u01/app/oracle/oradata/orcl/redo02.log 1 /u01/app/oracle/oradata/orcl/redo01.log SQL>******************************************
本文转自健哥的数据花园博客园博客，原文链接：http://www.cnblogs.com/gaojian/p/3665435.html，如需转载请自行联系原作者