Diagnosing performance issues using the alert log
To diagnose certain performance issues, even the alert log can be used successfully.
Getting ready
There are some parameters to look at in the init.ora
file of our database instance.
The parameter BACKGROUND_DUMP_DEST
indicates the directory in which the alert log is located. If the parameter LOG_CHECKPOINTS_TO_ALERT
is set to TRUE
, we will find even checkpoint information in the alert log. By default this parameter is set to FALSE
.
Before starting, we can issue the following command:
ALTER SYSTEM SET LOG_CHECKPOINTS_TO_ALERT = TRUE; SHOW PARAMETER BACKGROUND_DUMP_DEST
This writes checkpoint information to the alert log and shows the directory in which we will find the alert log file (named alert_<instance_name>.log ...
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.