Oracle trace files location

I recently found  a way to locate the trace files easily. Just query the V$DIAG_INFO table, which has the location details of trace files.

SET LINES 300
COLUMN NAME FORMAT A30
COLUMN VALUE FORMAT A70
SELECT NAME, VALUE FROM V$DIAG_INFO;

NAME                                   VALUE
—————————— ———————————————————————-
Diag Enabled                    TRUE
ADR Base                          /orabase
ADR Home                       /orabase/diag/rdbms/v0010n1c/v0010n1c
Diag Trace                         /orabase/diag/rdbms/v0010n1c/v0010n1c/trace
Diag Alert                          /orabase/diag/rdbms/v0010n1c/v0010n1c/alert
Diag Incident                   /orabase/diag/rdbms/v0010n1c/v0010n1c/incident
Diag Cdump                     /orabase/diag/rdbms/v0010n1c/v0010n1c/cdump
Health Monitor               /orabase/diag/rdbms/v0010n1c/v0010n1c/hm
Default Trace File           /orabase/diag/rdbms/v0010n1c/v0010n1c/trace/v0010n1c_ora_23500.trc
Active Problem Count   0
Active Incident Count   0

11 rows selected.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s