Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

BACKGROUND_DUMP_DEST

Parameter type

String

Syntax

BACKGROUND_DUMP_DEST = {pathname | directory}

Default value

Operating system-dependent

Parameter class

Dynamic: ALTER SYSTEM

Range of values

Any valid local path, directory, or disk

BACKGROUND_DUMP_DEST specifies the pathname (directory or disc) where debugging trace files for the background processes (LGWR, DBWn, and so on) are written during Oracle operations.

An alert file in the directory specified by BACKGROUND_DUMP_DEST logs significant database events and messages. Anything that affects the database instance or global database is recorded here. The alert file is a normal text file. Its filename is operating system-dependent. For platforms that support multiple instances, it takes the form alert_sid.log, where sid is the system identifier. This file grows slowly, but without limit, so you might want to delete it periodically. You can delete the file even when the database is running.

See Also:
  • Oracle9i Database Administrator's Guide for more information on setting this parameter and on alert files
  • Your operating system-specific Oracle documentation for the default value of this parameter
  • "USER_DUMP_DEST" for information on setting a destination for server process trace files