Checking the background_dump_dest for alert log files and user_dump_dest for trace files and errors are going to be a past.
I was excited to know about the new oracle11g initialization parameter DIAGNOSTIC_DEST which replaced BACKGROUND_DUMP_DEST, USER_DUMP_DEST and CORE_DUMP_DEST parameters.
All the trace informations are stored in a single location specified using DIAGNOSTIC_DEST. This helps the Oracle 11g database advisors to have a single point of contact for all the information required to auto tune the SQL or database.
If we do not specify a location for this initialization parameter then it will default to the $ORACLE_BASE/diag
No comments:
Post a Comment