Files - Expert Oracle Database Architecture - page 91

■ V$DIAG_INFO is a view available in Oracle 11 g (and above) and is not available in older releases. it is an easier
interface to the trace information used by the new aDr facility.

Note

For readability purposes, in the following query against V$DIAG_INFO , I've factored out the long path name to the
ADR Home directory, replacing it with $home$ in the output. This just makes it easier to read the output in the topic; it
is not something you need to do:

EODA@ORA12CR1> with home
2 as
3 (select value home
4 from v$diag_info
5 where name = 'ADR Home'
6 )
7 select name,
8 case when value <> home.home
9 then replace(value,home.home,'$home$')
10 else value
11 end value
12 from v$diag_info, home
13 /

NAME VALUE
------------------------------ ------------------------------
Diag Enabled TRUE
ADR Base /home/ora12cr1/app/ora12cr1
ADR Home /home/ora12cr1/app/ora12cr1/di
ag/rdbms/ora12cr1/ora12cr1

Diag Trace $home$/trace
Diag Alert $home$/alert
Diag Incident $home$/incident
Diag Cdump $home$/cdump
Health Monitor $home$/hm
Default Trace File $home$/trace/ora12cr1_ora_2231
9.trc

Active Problem Count 0
Active Incident Count 0

11 rows selected.

As you can see, the rows contain paths to the locations of various trace files. Oracle 11 g revamped where many
files are stored by default, organizing them a bit better to ease the support process when you log a service request with
Oracle Support. The most important rows are

• Diag Trace : This is where the trace files—both background and user dump destinations—go to
in Oracle 11 g and above.

• Default Trace File : This is the name of your current session's trace file. In earlier releases, this
file name could be tricky to figure out (we'll see how next). In Oracle 11 g and above , a simple
query against V$DIAG_INFO returns the fully qualified file name.