Questions tagged [awr]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
27 views

AWR dbms_workload_repository ash_global_report_text extract text from output

I want to build a scheduled job in Enterprise Manager to trigger every hour the following query: SELECT output FROM TABLE(dbms_workload_repository.ash_global_report_text(584958394, Null, SYSDATE-1/24, ...
0
votes
1answer
20 views

Oracle DB not generating AWR

Sysaux tablespace is almost full . Could this be the reason AWR snapshot is not generated ? Although I do have the AutoExtend ON for SYSAUX tablespace.
0
votes
1answer
113 views

How to find historical sql_id executed by users

I'm trying to find historical sql_id executed by users within interval between snapshot_id from AWR. I'm using the view DBA_HIST_ACTIVE_SESS_HISTORY,DBA_USERS and DBA_HIST_SNAPSHOTS to try find the ...
1
vote
1answer
27 views

Best way to know if my environment has workload repository license

Usually, when I need to use something that use some resource from awr, I look for LAST_USAGE_DATE at dba_feature_usage_statistics with feature name Automatic Workload Repository, but I'm almost sure ...
1
vote
1answer
108 views

ORA-13506 An attempt was made to perform operation with an invalid Start/End Snapshot Pair during AWR report creation

When I create an AWR Report, the following error occurs: ORA-13506 Cause: An attempt was made to perform operation with an invalid Start/End Snapshot Pair. What does this mean, and what should ...
1
vote
0answers
740 views

DB CPU parameter in AWR - Oracle

What is the significance of DB CPU paramater in Automatic Workload Repository? Say in my case it's always above 100. Does it have benchmark metric as such to say that so and so number is the right ...
0
votes
1answer
4k views

Oracle average active sessions high threshold

I am trying make sense of the DB load from the AWR report for a period handed over to me by DBA. Researching a bit, I see the "Average active sessions" is a metric widely used to measure DB load. It ...
0
votes
1answer
3k views

How to interpret undo statistics in Oracle AWR report? [closed]

How can I use undo statistics in oracle AWR report for tuning Oracle? which indicators are important to identify that size of undo segments needs to be increased?
2
votes
1answer
3k views

In Oracle AWR report how to use “Latch statistics” section in analysis

Latch statistics in AWR report contain following sections 1.Latch Activity 2.Latch Sleep Breakdown 3.Latch Miss Sources 4.Parent Latch Statistics 5.Child Latch Statistics How can I use these ...
1
vote
2answers
2k views

What useful information can I get from ASH report which I cannot get from AWR report?

What useful information can I get from ASH report which I cannot get from AWR report? What are the common scenarios in which its better to get information from ASH than from AWR?
2
votes
3answers
45k views

Finding all sql id, sql text, number of executions, execution time between two AWR snap ids in oracle

The AWR report provides the SQL information for top 10-20 SQL statements. Is it possible to get information on SQL statements that do not make it to the top list? How do we find all sql id, sql text, ...
1
vote
1answer
314 views

How to measure improvement after splitting tablespaces into multiple disk volumes? (Oracle 10g AWR)

I have a recently released 10 000 user analytical application that is suffering from performance issues because of excessive amount of transactions. Apart from re writing many of the SQLs in the ...
2
votes
1answer
2k views

When is a row added to DBA_HIST_SQLSTAT?

I don't understand the criteria that entails an additional record in the dba_hist_sqlstat view. I have expected there to be at most one entry per sql_id and snap_id, that is, the following statement ...
5
votes
1answer
916 views

Oracle AWR shows missing stats for SQL ID as top elapsed statement

Why SQL ID has null number of executions and elapsed time / execution in AWR report. SQL ID is among top elapsed command on AWR but no details stats whoing time / execution. Would it be because shared ...