Troubleshooting the Database
Oracle Database 11g offers new ways of diagnosing the health of your database. This chapter contains several recipes that show how to use the database’s built-in diagnostic infrastructure to resolve database performance issues. You’ll learn how to use ADRCI, the Automatic Diagnostic Repository Command Interpreter, to perform various tasks such as checking the database alert log, creating a diagnostic package for sending to Oracle Support engineers, and running a proactive health check of the database.
KeywordsHealth Check Diagnostic Data Trace File Temporary Segment Sort Operation
Unable to display preview. Download preview PDF.