Initialization Parameter

[sammy]

What is the functionality of the initialization parameter BACKGROUND_DUMP_DEST in oracle.If someone could give a example it would be of great help.

[oracleobsessed]

background_dump_dest parameter specifies the location where oracle will be placing traces for oracle background processes, typically the directory by default is oracle_home/admin/bdump

following this path if you open up this directory u will find many traces ending with extensions .trc, these trace files related to processes like DBWR,CKPT,ARCH,LGWR indicate any errors that these background processes wud hav encountered while database activity.

[Angela]

In short sammy the initialization parameter DB_BACKGROUND_DUMP_DEST is used to set the Alert file and Background Trace file locations.