-
Top 5 Events
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 ?
-
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.
www.cnoug.org
-
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
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|