00048.Oracle诊断文件定位

来源：互联网发布：淘宝上苹果6二手能买吗编辑：程序博客网时间：2024/05/18 07:52

SQL> col namefor a30

SQL> col valuefor a45

SQL> set line 1000

SQL> set pagesize 30

SQL> select name,value from v$parameter where name like '%_dest';

NAME VALUE

--------------------------------------------------------------------------------

log_archive_dest

log_archive_duplex_dest

log_archive_min_succeed_dest 1

standby_archive_dest ?/dbs/arch

db_create_file_dest

db_recovery_file_dest /home/oracle/oracle/recovery_area

background_dump_dest /home/oracle/oracle/diag/rdbms/mdsp/mdsp/trace

user_dump_dest /home/oracle/oracle/diag/rdbms/mdsp/mdsp/trace

core_dump_dest /home/oracle/oracle/diag/rdbms/mdsp/mdsp/cdump

audit_file_dest /home/oracle/oracle/admin/mdsp/adump

diagnostic_dest /home/oracle/oracle

11 rows selected.

SQL> exit

Disconnected fromOracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With thePartitioning, OLAP, Data Mining and Real Application Testing options

oracle@mdsps1:

~/diag/rdbms/mdsp/mdsp/trace> cd/home/oracle/oracle/diag/rdbms/mdsp/mdsp/trace

oracle@mdsps1:~/diag/rdbms/mdsp/mdsp/trace>ls | grep log

alert_mdsp.log

oracle@mdsps1:~/diag/rdbms/mdsp/mdsp/trace>ls | grep .trc

SQL> alter session setsql_trace=true;

Session altered.

SQL> alter session setsql_trace=false;

Session altered.