DBA Alert Log – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Database Administration · all Database Administration reports
Overview
V$DIAG_ALERT_EXT shows the contents of the XML-based alert log in the Automatic Diagnostic Repository (ADR) for the current container (PDB). You could schedule it, for example, in incremental mode to send an email with errors that occured since the last scheduled report run.
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
Report Parameters
Message Text includes, Message Type, Message Level, History Days, Date From, Exceptions and ORA-% only, Incremental Mode
Oracle EBS Tables Used
Report Categories
Related Reports
DBA Trace File Contents, DBA Database Parameter Validation, QA Collection Plan Upload, ALR Alerts
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | DBA Alert Log - Default 08-Mar-2024 094258.xlsx |
| Blitz Report™ XML Import | DBA_Alert_Log.xml |
| SQL Source | DBA Alert Log.sql |
| Full Report on Enginatics | www.enginatics.com/reports/dba-alert-log/ |
Executive Summary
The DBA Alert Log report provides a direct interface to the Oracle Database’s XML-based Alert Log, located within the Automatic Diagnostic Repository (ADR). The Alert Log is the primary chronological record of messages and errors for the database. This report allows DBAs to query, filter, and export these critical system messages without needing to log in to the database server OS.
Business Challenge
- Proactive Monitoring: “Did any critical errors (ORA-00600, ORA-07445) occur last night?”
- Accessibility: Developers and functional support often need to see if a process failed due to a database error, but they don’t have SSH access to the server.
- Audit: Reviewing the history of database startups, shutdowns, and parameter changes.
Solution
This report queries the V$DIAG_ALERT_EXT view to present the alert log contents in a tabular format.
Key Features:
- Incremental Mode: Can be scheduled to run periodically (e.g., every hour) and report only new messages since the last run.
- Filtering: Parameters allow filtering by Message Text (e.g., “ORA-“), Message Level, or Timeframe.
- Unified View: In a RAC environment, it can potentially show alerts from the local instance (or all, depending on the view definition).
Architecture
The report leverages the ADR infrastructure introduced in Oracle 11g.
Key Tables:
V$DIAG_ALERT_EXT: The external table view that parses the XML alert log file.
Impact
- Uptime: Enables faster detection and resolution of critical database errors.
- Security: Provides read-only access to logs without granting OS privileges.
- Efficiency: Automates the daily check of the alert log via scheduled email delivery.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH