1 / 22

Diagnostic Sources

Diagnostic Sources. Objectives. After completing this lesson, you should be able to do the following: Use various files for diagnostic purposes Alert Log Trace files Core files System logs Use Enterprise Manager to view alerts Adjust thresholds for tracked metrics

rainer
Download Presentation

Diagnostic Sources

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Diagnostic Sources

  2. Objectives • After completing this lesson, you should be able to do the following: • Use various files for diagnostic purposes • Alert Log • Trace files • Core files • System logs • Use Enterprise Manager to view alerts • Adjust thresholds for tracked metrics • Control the size and location of trace files

  3. Diagnostic Files • The alert.log file • Trace files • Core dump files • System log files

  4. The Alert Log • The Alert Log contains: • All internal errors • Administrative operations, such as CREATE, ALTER, and DROP statements • Shared server errors • Materialized view refresh errors • Initialization parameter values

  5. What Is in the alert.log File • Every instance generates a file called alert.log, which logs the following information: • Diagnostic data from background and foreground processes • Summary information regarding errors and pointers to trace files for detailed information • Information since database creation (unless purged) that might be useful in backtracking a problem

  6. Viewing Recent Alert Log Entries

  7. Alert Models Architecture Subscribingclients Serveralerts EMalerts Thirdparty EM Console AutomaticPushedNotification EMD Pollstatistics Datadictionary Serveralertsqueue Server monitors itself Oracle database(SGA) AWR MMON

  8. Server-Generated Alert Types Metric-based 97% Critical Cleared Threshold(stateful)alerts 85% Warning Cleared MMON DBA_OUTSTANDING_ALERTS DBA_ALERT_HISTORY Recovery Area Low On Free Space ResumableSessionSuspended SnapshotToo Old Nonthreshold (stateless)alerts Alert Event-based

  9. Viewing Alerts with Enterprise Manager • Alert General View

  10. Viewing Alerts with Enterprise Manager • Alert Details

  11. Alerts Notification

  12. Alert Log Monitoring Configuration

  13. Editing Thresholds

  14. Viewing Initialization Parameters

  15. Trace Files • Every server process, on encountering an exception, writes diagnostic data to a trace file • The trace file header contains the following information: • OS and version • Oracle version and options installed • Instance name • Process ID

  16. Specifying the Location of Trace Files • Initialization parameters controlling the location and size of trace files include: • BACKGROUND_DUMP_DEST • USER_DUMP_DEST • MAX_DUMP_FILE_SIZE

  17. Controlling Trace File Size • Using Enterprise Manager

  18. Controlling Trace File Writes • Trace files are usually generated by a server process upon encountering an error. • Some background processes like ARCn, have parameters that control the amount and type of trace information generated. • In some instances, trace files can be generated for server processes at user request. SQL> ALTER SESSION SET SQL_TRACE TRUE;

  19. Using Enterprise Manager to Enable and View SQL Tracing SQL> SELECT * FROM dba_enabled_traces;

  20. System Log Files • System log files capture error messages and exceptions encountered at the OS level • These would be useful if a hardware or OS problem is suspected

  21. Summary • In this lesson, you should have learned how to: • Use various files for diagnostic purposes • Alert Log • Trace files • Core files • System logs • Use Enterprise Manager to view alerts • Adjust thresholds for tracked metrics • Control the size and location of trace files

  22. Practice 7 Overview: Diagnosing Problems • These practices cover the following topics: • Setup server-generated alerts • Monitor server-generated alerts

More Related