This is it, i have elasped time without many wait events... Top 5 Timed Events Avg %Total ~~~~~~~~~~~~~~~~~~ wait Call Event Waits Time (s) (ms) Time Wait Class ------------------------------ ------------ ----------- ------ ------ ---------- db file sequential read 1,502,562 5,311 4 3.2 User I/O CPU time 2,304 1.4 db file scattered read 709,287 1,235 2 0.8 User I/O control file parallel write 15,040 115 8 0.1 System I/O SQL*Net more data to client 2,185,044 72 0 0.0 Network 2011/9/29 Chitale, Hemant Krishnarao <Hemant.Chitale@xxxxxx> > Can you post the Load Profile and the Top 5 Timed Events sections of the > AWR ? > > > Hemant K Chitale > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of thierry gascard > Sent: Thursday, September 29, 2011 3:40 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: Elapsed time for Stored Procedure and Time model > > Hello; > I try to understand why so much elapsed times with a stored procedure > 124,037 s elapsed time against 968 s of Cpu time. > There isn't very much SQL activity, but with Time Model Statistics this > 89.5 > % of DB Time !!! > > <deleted> > > Thank you. > > > -- > //www.freelists.org/webpage/oracle-l > > > > This email and any attachments are confidential and may also be privileged. > If you are not the addressee, do not disclose, copy, circulate or in any > other way use or rely on the information contained in this email or any > attachments. If received in error, notify the sender immediately and delete > this email and any attachments from your system. Emails cannot be > guaranteed to be secure or error free as the message and any attachments > could be intercepted, corrupted, lost, delayed, incomplete or amended. > Standard Chartered PLC and its subsidiaries do not accept liability for > damage caused by this email or any attachments and may monitor email > traffic. > > Standard Chartered PLC is incorporated in England with limited liability > under company number 966425 and has its registered office at 1 Aldermanbury > Square, London, EC2V 7SB. > > Standard Chartered Bank ("SCB") is incorporated in England with limited > liability by Royal Charter 1853, under reference ZC18. The Principal Office > of SCB is situated in England at 1 Aldermanbury Square, London EC2V 7SB. In > the United Kingdom, SCB is authorised and regulated by the Financial > Services Authority under FSA register number 114276. > > If you are receiving this email from SCB outside the UK, please click > http://www.standardchartered.com/global/email_disclaimer.html to refer to > the information on other jurisdictions. > -- //www.freelists.org/webpage/oracle-l