Home » RDBMS Server » Server Administration » Elapsed time in AWR report (Oracle,11.1.0.2,Unix)
Elapsed time in AWR report [message #530361] Mon, 07 November 2011 22:20 Go to next message
vattigunta
Messages: 32
Registered: August 2011
Location: India
Member
Hi can anybody explain this
I have an AWR report based on two snapshots one an one hour time window, under the "SQL ordered by Elapsed Time" section, there is a query having Elapsed Time = 7012 seconds, which is almost two hours, how is this possible?
I have been told that this i aggregate value of all sessions, if it is so, could somebody explain it.
Re: Elapsed time in AWR report [message #530363 is a reply to message #530361] Mon, 07 November 2011 22:24 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

In the future please use COPY & PASTE so we can see exactly what you claim exists.

How many CPUs & cores are inside the DB Server system?
Is Oracle doing any parallel processing?
Re: Elapsed time in AWR report [message #530364 is a reply to message #530363] Mon, 07 November 2011 22:27 Go to previous messageGo to next message
vattigunta
Messages: 32
Registered: August 2011
Location: India
Member
Hey thanxs for your reply my question is how oracle generally calculates elapsed time in awr report.
1)If supppose all queries running in serial mode then how it does calculation
2)If some queries running in parallel mode then how does it calculates elapsed time.
Re: Elapsed time in AWR report [message #530402 is a reply to message #530364] Tue, 08 November 2011 01:12 Go to previous message
Michel Cadot
Messages: 58934
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The elapsed time is the time between the start and the end of the statement.
If you have 10 concurrent sessions on one CPU executing a 1 second statement and assuming they start and end the statement at the same time (and use only CPU) then each statement will last 10 seconds and the total of elapsed time is 10*10 = 100 seconds in 10 seconds of real time.

Regards
Michel
Previous Topic: Large trace files generated in udump
Next Topic: Database Rename
Goto Forum:
  


Current Time: Fri Aug 29 09:58:36 CDT 2014

Total time taken to generate the page: 0.15219 seconds