Chapter 14. Troubleshooting
When trouble strikes in your Oracle database, there are many places to turn for clues about what is causing the problem. The approach you take to troubleshooting the database will depend, in part, on whether a few users complain or you get hundreds of phone calls and e-mail messages from irate users.
The alert log file can give you clues about global database errors, and the system trace files can tell you about problems with the background processes. When individual users are having problems with their sessions, and the error messages they are receiving in their SQL*Plus session aren't very descriptive, the user trace files may provide additional clues to the problem.
For Oracle9i, you can also use the Event Manager ...
Get Oracle Database Foundations 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.
