To really see what DBWR, LGWR, and other backgound processes are doing set event 10046 level 12 for the background processes. DO NOT do this on a production database.
Find the PID
SELECT * FROM v$process WHERE background is not null;
ORADEBUG SETORAPID 5
ORADEBUG EVENT 10046 trace name context forever, level 12
Turn off tracing with:
oradebug event 10046 trace name context off
The trace file will be in the DAIG_TRACE directory for all processes. The SET EVENT command can have serious consequences in a database. Events should NOT be set except at the direction of Oracle Support.
In Oracle Database 11g, all trace files are located in the Automatic Diagnostics Repository, a set of directories. The default location for traces file is $ORACLE_BASE/diag/rdbms/<db_name>/<instance_name>/trace.
I will post another article very soon How to read SQL trace file.
---------------------------------------------------------------------------
Related links:
---------------------------------------------------------------------------
Related links:
HOME
No comments:
Post a Comment