| 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
![]() |
![]() |