Re: Elapsed time for Stored Procedure and Time model

From: thierry gascard <tgascard_at_gmail.com>
Date: Thu, 29 Sep 2011 10:47:23 +0200
Message-ID: <CAJrMwWTZytoFhK=7noiq11LFfQ__3fbGbg2_WLU4=wv7Rr98fQ_at_mail.gmail.com>

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_at_sc.com>

> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of thierry gascard
> Sent: Thursday, September 29, 2011 3:40 PM
> To: oracle-l_at_freelists.org
> 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.
>
>
> --
> http://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.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 29 2011 - 03:47:23 CDT