Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: statspack report shows low execute to parse%

Re: statspack report shows low execute to parse%

From: clement rajappa <clement.rajappa_at_gmail.com>
Date: 7 Sep 2005 12:00:35 -0700
Message-ID: <1126119635.080906.248810@g47g2000cwa.googlegroups.com>

poddar wrote:
> Hi,
>
> Could you post the wait event part of statspack also ?
>
> amit

Hi amit
I am indicating the top 5 wait events:

Event                         Waits   WaitTime(cs) %total wait
                                                    time
Sql*Net message from dblink    1,134   4,058         90.72
db file scattered read           510     141          3.15
db file sequential read          513     126          2.82
Sql*Net break/reset to client     44      67          1.5
Direct Path Read                 247      20           .45

I dont the complete listing as of now, as the next 2 days are off. In the meanwhile i hope this info will help. thks and regds
clement Received on Wed Sep 07 2005 - 14:00:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US