Return
-
Title
Where are trace files stored that are listed under SQL Analyze Trace | Trace Files ? -
Description
Where are the trace files stored that are listed under SQL Analyze Trace | Trace Files ?
-
Resolution
These files are not generated by Spotlight, but are Oracle trace files that are stored on your database server. The exact location depends upon your Oracle Database parameter user_dump_dest.
To check this parameter:
1. open a SQL Plus and connect as sys to the database
2. type: show parameter user_dump_dest
OR select value from v$parameter where name = 'user_dump_dest';
==> For Oracle 10 the udump default is for example: 'C:\ORACLE\PRODUCT\10.2.0\ADMIN\<ORACLE_SID>\UDUMP'