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.