Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: statspack report shows low execute to parse%
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
![]() |
![]() |