Re: statspack report shows low execute to parse%

clement rajappa wrote:
> Hi
> I am attaching the full list of wait events:
> Wait Events for DB: ORCSAW Instance: orcsaw Snaps: 2 -3
> -> cs - centisecond - 100th of a second
> -> ms - millisecond - 1000th of a second
> -> ordered by wait time desc, waits desc (idle events last)
>
> Avg
> Total Wait wait
> Waits
> Event Waits Timeouts Time (cs) (ms)
> /txn
> ---------------------------- ------------ ---------- ----------- ------
> ------
> SQL*Net message from dblink 1,134 0 4,058 36
> 9.9
> db file scattered read 510 0 141 3
> 4.4
> db file sequential read 513 0 126 2
> 4.5
> SQL*Net break/reset to clien 44 0 67 15
> 0.4
> direct path read 247 0 20 1
> 2.1
> log file sync 111 0 17 2
> 1.0
> latch free 40 25 14 4
> 0.3
> direct path write 79 0 13 2
> 0.7
> control file sequential read 37 0 10 3
> 0.3
> refresh controlfile command 6 0 4 7
> 0.1
> log file parallel write 160 0 3 0
> 1.4
> SQL*Net message to dblink 1,133 0 0 0
> 9.9
> SQL*Net more data to client 465 0 0 0
> 4.0
> control file parallel write 233 0 0 0
> 2.0
> db file parallel write 66 0 0 0
> 0.6
> file open 5 0 0 0
> 0.0
> SQL*Net message from client 5,472 0 1,138,103 2080
> 47.6
> SQL*Net message to client 5,471 0 2 0
> 47.6
> -------------------------------------------------------------
> i hope this info will help.
> thks and regards
> clement

Hi,

Are you sure you really have a performance issue with the database. Or you are just trying to eliminate all the wait event ?

amit Received on Sat Sep 10 2005 - 23:29:19 CDT