Friday, December 9, 2011

When Oracle writes to trace file

1. Background process always writes information into trace file
2. When database encounters any critical error, the server process writes the incident into trace files
3. By setting the initialization parameter SQL_TRACE = TRUE 


setting the SQL tracing can cause performance issues.

No comments:

Post a Comment