Question : I am trying make sense of the DB load from the AWR report for a period handed over […]
Tag: awr
Oracle average active sessions high threshold
Question : I am trying make sense of the DB load from the AWR report for a period handed over […]
In Oracle AWR report how to use “Latch statistics” section in analysis
Question : Latch statistics in AWR report contain following sections 1.Latch Activity 2.Latch Sleep Breakdown 3.Latch Miss Sources 4.Parent Latch […]
What useful information can I get from ASH report which I cannot get from AWR report?
Question : What useful information can I get from ASH report which I cannot get from AWR report? What are […]
AWR dbms_workload_repository ash_global_report_text extract text from output
Question : I want to build a scheduled job in Enterprise Manager to trigger every hour the following query: SELECT […]
How to interpret undo statistics in Oracle AWR report? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Oracle AWR shows missing stats for SQL ID as top elapsed statement
Question : Why SQL ID has null number of executions and elapsed time / execution in AWR report. SQL ID […]
In Oracle AWR report how to use “Latch statistics” section in analysis
Question : Latch statistics in AWR report contain following sections 1.Latch Activity 2.Latch Sleep Breakdown 3.Latch Miss Sources 4.Parent Latch […]
How to interpret undo statistics in Oracle AWR report? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
When is a row added to DBA_HIST_SQLSTAT?
Question : I don’t understand the criteria that entails an additional record in the dba_hist_sqlstat view. I have expected there […]