BACKGROUND_CORE_DUMP

Property	Description
Parameter type	String
Syntax	BACKGROUND_CORE_DUMP = { partial | full }
Default value	partial
Modifiable	No
Basic	No

BACKGROUND_CORE_DUMP specifies whether Oracle includes the SGA in the core file for Oracle background processes.

Values:

· partial

Oracle does not include the SGA in the core dump.

· full

Oracle includes the SGA in the core dump.

Note:

1. Related:

This parameter can significantly affect the size of the dumped core files. In order to dump FULL core dumps any Unix limits (eg: the Unix coredumpsize OS limit) should also be sufficiently large to dump the Oracle image with the SGA attached.

2. 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) = 'BACKGROUND_CORE_DUMP';

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
background_core_dump	partial	TRUE	FALSE	FALSE	FALSE	FALSE	Core Size for Background Processes

Oracle initializatoin parameters