Top 5 Events

[liverdba]

Hi,

I'm installing a test DB running on Network Storage (NETAPP), there is no activity yet but when I see the Top 5 events these two event is very high :
direct path read
direct path write


What is that mean ?

[chao_ping]

Hi,
No matter how your database behave, the tatal value for wait event will always be 100%.
So, don't worry if you performance is ok.

[liverdba]

Hi Chao_ping,

I don't understand what you mean with "the total value for wait event will always be 100%" .I'm using statspack to capture the TOP5 Event and here is the complete result. I think there is something wrong with the performance , but I couldn't find the meaning of these 2 events.

Top 5 Wait Events
~~~~~~~~~~~~~~~~~
Wait % Total
Event Waits Time (cs) Wt Time
-------------------------------- ------------ ------------ -------
direct path read 352 86 46.49
direct path write 291 67 36.22

[Shestakov]

Probably u have some problems with sort operations.
because:
direct path read
direct path write
are direct i/o operations from pga to a disk (without buffer cache) and in most cases oracle use this method when u have small sort_area_size.
try to get i/o statistics from a temporary tablespace(es).

another possible problem is asynchronous i/o, ur os, i guess, can not use asynchronous read/write.