Identifying and Managing Long Running EBS Sessions using DBA Blitz Reports

Customer September 26, 2025 at 1:50 pm

We are struggling with system stability caused by intermittent long running database sessions initiated by poor ad-hoc queries, sometimes running for hours and consuming critical resources. Our requirement is to Kill Long Running Sessions automatically or at least have a robust alert mechanism that identifies these runaway queries instantly so a DBA can intervene manually. How can we continuously monitor database session activity, especially those associated with EBS concurrent requests, to flag any query running beyond a predefined threshold, such as sixty minutes, and retrieve the full SQL text for analysis?

Viewing 6 reply threads

Author
Replies
- Support September 26, 2025 at 4:23 pm
  While directly automating the killing of sessions requires specific database setup, the necessary monitoring and deep diagnostics are streamlined using the DBA Blitz Reports toolkit. These reports leverage Oracle performance data to pinpoint resource-intensive sessions effectively.
- Customer September 26, 2025 at 7:47 pm
  Which specific Blitz Report diagnostic tool is best suited for identifying long-running sessions, and does it require constant real-time monitoring, or can it use existing historical data collected by Oracle?
- Support September 26, 2025 at 10:51 pm
  You should utilize the DBA AWR Blitz Reports, which analyze historical snapshots from the Automatic Workload Repository. This allows you to identify problematic SQL statements and their execution context over specific time periods, helping you target tuning efforts rather than reacting only in real-time.
- Customer September 27, 2025 at 2:03 am
  Once a long-running SQL is identified through these reports, how easily can the DBA identify which functional EBS module or concurrent program initiated that query?
- Support September 27, 2025 at 7:27 am
  The AWR Blitz Reports automatically correlate the technical SQL details with the corresponding functional names and responsibilities within the Oracle EBS programs. This essential link turns raw database data into actionable information for both DBA and functional teams, improving collaboration in SQL Tuning Advisory.
- Customer September 27, 2025 at 1:16 pm
  Can we configure the output of these DBA reports to be delivered automatically to the DBA team’s inbox, isolating only sessions that meet the ‘long running’ criteria?
- Support September 27, 2025 at 7:14 pm
  Yes, like all Blitz Reports, these diagnostic views can be scheduled as standard concurrent requests using parameters to filter for specific resource usage thresholds. The results, detailing the session and resource usage, can then be automatically emailed to the DBA team on a periodic basis.
Author
Replies

Viewing 6 reply threads

You must be logged in to reply to this post.