| |
GeekInterview.com > Interview Questions > Oracle > Database Administration
| Print | |
Question: Dump Destination
Answer: What is dump destination? What are bdump, cdump and udump? Explain in detail. |
| July 07, 2009 10:06:17 |
#3 |
| aravindhreturns |
Member Since: July 2009 Total Comments: 5 |
RE: Dump Destination
|
UDUMP is specifying the user dump directory where all user error logs (trace files) will be placed.
BDUMP is specifying the background dump directory where all database error logs (trace files) will be placed.
CDUMP is specifying the core dump directory where all OS error logs (core dump files) will be placed.
Default location is ( ORACLE_BASE/admin/<SID> )
Login as root:
SYNTAX : sqlplus "/ as sysdba"
Then issue this command
SYNTAX : show parameters dump_dest
It'll show you all the bdump, cdump and udump directories wherever it is currently located.
You can change your parameters in init.ora by creating spfile from pfile.
SYNTAX : Create SPFILE from PFILE
Guess this is what you need :) |
| |
Back To Question | |
