Stack Overflow
Stack Overflow

Questions tagged [awr]

42 questions
4
votes
4 answers

Oracle AWR - high SQL Parse Calls but 0 Executions

I'm trying to understand what is causing an open query on an Oracle (10) database. On AWR it shows a very high number of parse calls (e.g. 15,000+ in a 1 hour period), but 0 executions. How it can the query not be executed, but then parsed 15000…
Baron Ludwig
  • 41
  • 1
  • 2
3
votes
1 answer

Oracle 11g - AWR report Analysis help

I am a newbie to Oracle and I created an AWR report from the enterprise Manager. Here is a small snapshot of the report. Logons: 0.01 per second - 0.02 per transaction In-memory Sort % 100.00 Executes 19.0 per second - 27.7 per transaction…
Aniket
  • 163
  • 1
  • 2
  • 5
2
votes
2 answers

how to do SQL tuning on below update sql

everyone,Recently I was involved one SQL tuning task for oracle, I had a very difficult problem I think,I could even say I was scared by this question, I get the AWR report from DBA,and seems the red line SQL from the AMR need do some adjustment(I…
Tom
  • 121
  • 2
  • 14
2
votes
1 answer

Cost Of Simple count Query

I have a query of simple count on a table. As per below screenshot, there is no primary key on the table except a single index is on different column. How can I reduce the cost of this query? Actual query is : No difference in the cost even…
Nitesh Kumar
  • 875
  • 4
  • 20
  • 39
2
votes
4 answers

SQL ordered by Elapsed Time in AWR report

I was trying to analyze the AWR report generated for a particular process with a duration of one hour. I am trying to find out which query is taking much time to while running the process. When I have gone through the report, I can see SQL ordered…
Nidheesh
  • 4,390
  • 29
  • 87
  • 150
2
votes
4 answers

Performance report for Postgresql

Oracle creates nicely HTML-formatted workload reports (AWR) that list things like instance statistics, wait events, the top ten heavy SQL statements (by number of executions, number of disk reads, and so on). Is there a similar tool for Postgresql?
Thilo
  • 257,207
  • 101
  • 511
  • 656
2
votes
2 answers

Customize Oracle AWR report

Oracle creates nicely HTML-formatted workload reports (AWR) that list things like instance statistics, wait events, the top ten heavy SQL statements (by number of executions, number of disk reads, and so on). Are there (easy) ways to customize this…
Thilo
  • 257,207
  • 101
  • 511
  • 656
1
vote
1 answer

Get list of SQL_IDs between begin snapshot and end snapshot time in Oracle

I want to get the list of SQL_Id executed between a beginning snapshot and the end snapshot time in Oracle. We can get the list from the AWR report but I need a SQL query which will return all the SQL IDs. SQL Id is present in the V$SQL table but…
abhi
  • 11
  • 2
1
vote
2 answers

Three basic requirements that determine AWR snapshot usability

I am a newbie to Oracle and I know that oracle uses two AWR snapshots to create an AWR report. What are three basic requirements that determine whether an AWR snapshot is usable? Or in other words a snapshot can be used for generating an AWR…
blackrose
  • 11
  • 1
1
vote
1 answer

Tuning PGA_AGGREGATE_TARGET in 11.2

I have attached output of AWR report from our server which has been experiencing performance issues. Attached is PGA Advisory from AWR report. Does it indicates that there is shortage of PGA?
oradbanj
  • 551
  • 7
  • 23
1
vote
0 answers

Incomplete AWR snapshots

I have a question regarding Oracle AWR reports. At the end of the AWR Report there is a Warning: Warnings The optimal memory target for the instance could not be determined because of incomplete AWR snapshots. The complete end of the report…
Jack
  • 19
  • 4
1
vote
3 answers

Interpreting Row Lock Contention in AWR Report

My AWR report shows the following : Event Waits Total Wait Time(s) enq: TX - row lock contention 30 10,694 Does 10,694 represents clock time ? Or does it represents total time spent by all sessions which…
oradbanj
  • 551
  • 7
  • 23
1
vote
4 answers

How do you create an Oracle Automatic Workload Repository (AWR) report?

How do you create an Oracle Automatic Workload Repository (AWR) report?
Aldur
  • 3,025
  • 5
  • 21
  • 14
1
vote
3 answers

Total DB time vs Elapsed Time vs CPU time?

In Oracle AWR report i see mention of three terms i.e. DB time , Elapses Time , CPU time but i am not sure what does they actually mean Say i have got the AWR report for 15 mins i.e 900 seconds. There are two cores. Statement1 took 20 seconds to…
emilly
  • 10,060
  • 33
  • 97
  • 172
1
vote
1 answer

.ini file not being modified/updated when doing an upgrade with installshield since some folders are not being deleted when upgrading

Not too long ago I got a new job working on a tool that the company created to make people's lives easier when working on AWR. I have successfully done multiple fixes and improvements which I was able to distribute via HotFix installers (simply…
RaptorSD
  • 33
  • 4
1
2 3