Database Reference
In-Depth Information
EODA@ORA12CR1> show parameter dump_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string /home/ora12cr1/app/ora12cr1/di
ag/rdbms/ora12cr1/ora12cr1/tra
ce
core_dump_dest string /home/ora12cr1/app/ora12cr1/di
ag/rdbms/ora12cr1/ora12cr1/cdu
mp
user_dump_dest string /home/ora12cr1/app/ora12cr1/di
ag/rdbms/ora12cr1/ora12cr1/tra
ce
This shows the three dump (trace) destinations. The background dump destination is used by any “server”
process (see Chapter 5 for a comprehensive list of Oracle background processes and their functions). The core dump
destination is used for a “core dump” (very detailed process diagnostic information) when a serious problem arises,
such as a process crash. The user dump destination is used by dedicated and shared server connections (covered in
Chapter 2) when they generate a trace file.
To continue with the various methods of examining these dump destinations, let's take a look at the
V$
tables
available:
EODA@ORA12CR1> select name, value
2 from v$parameter
3 where name like '%dump_dest%';
NAME VALUE
------------------------------ ------------------------------
background_dump_dest /home/ora12cr1/app/ora12cr1/di
ag/rdbms/ora12cr1/ora12cr1/tra
ce
user_dump_dest /home/ora12cr1/app/ora12cr1/di
ag/rdbms/ora12cr1/ora12cr1/tra
ce
core_dump_dest /home/ora12cr1/app/ora12cr1/di
ag/rdbms/ora12cr1/ora12cr1/cdu
mp
We could, of course, use the
DBMS_UTILITY
package we put in our earlier
SCOTT.GET_PARAM
function to query the
V$PARAMETER
table as well:
EODA@ORA12CR1> set serveroutput on
EODA@ORA12CR1> exec dbms_output.put_line( scott.get_param( 'user_dump_dest' ) )
/home/ora12cr1/app/ora12cr1/diag/rdbms/ora12cr1/ora12cr1/trace
PL/SQL procedure successfully completed.
In Oracle 11
g
, a new facility, the ADR, was added. As part of this new facility, there's a new
V$
view—
V$DIAG_INFO
.