CORE_DUMP_DEST

Property	Description
Parameter type	String
Syntax	CORE_DUMP_DEST = directory
Default value	ORACLE_HOME/DBS
Modifiable	ALTER SYSTEM
Basic	No

CORE_DUMP_DEST is primarily a UNIX parameter and may not be supported on your platform. It specifies the directory where Oracle dumps core files.

Note:

1. This parameter is ignored by the new diagnosability infrastructure introduced in Oracle Database 11g Release 1, which places trace and core files in a location controlled by the DIAGNOSTIC_DEST initialization parameter.

2. Related: SHADOW_CORE_DUMP, BACKGROUND_CORE_DUMP

This parameter was made dynamic via ALTER SYSTEM in Oracle 8.1.

CORE_DUMP_DEST should point to the directory where core dumps from the Oracle server will be placed. The above "Related" parameters determine the size of the core dumps. A core dump is a memory image of the Oracle shadow process produced when an unexpected , unrecoverable or invalid condition occurs.

Note that Oracle should always try to write a trace file before producing a core dump. Always check USER_DUMP_DEST and BACKGROUND_DUMP_DEST locations for tracefiles first.

In some cases this parameter may not have been read when a core file is produced. In this case the core dump is typically written to thedefault location ($ORACLE_HOME/dbs).

CORE_DUMP_DEST should have WRITE permission for the Oracle user.

3. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘CORE_DUMP_DEST’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
core_dump_dest	/oracle/admin/mydb/cdump	FALSE	FALSE	IMMEDIATE	TRUE	FALSE	Core dump directory

Oracle initializatoin parameters