OraFAQ Forum: Server Administration » Elapsed time in AWR report

Home » RDBMS Server » Server Administration » Elapsed time in AWR report (Oracle,11.1.0.2,Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Elapsed time in AWR report [message #530361]

Mon, 07 November 2011 22:20

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.

Report message to a moderator

Re: Elapsed time in AWR report [message #530363 is a reply to message #530361]

Mon, 07 November 2011 22:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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?

Report message to a moderator

Re: Elapsed time in AWR report [message #530364 is a reply to message #530363]

Mon, 07 November 2011 22:27

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.

Report message to a moderator

Re: Elapsed time in AWR report [message #530402 is a reply to message #530364]

Tue, 08 November 2011 01:12

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Large trace files generated in udump
Next Topic:	Database Rename

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 04:32:07 CST 2024