00048.Oracle诊断文件定位

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.