db file scattered and sequential read wait events ? [message #190732] |
Fri, 01 September 2006 01:12 |
tridentadm
Messages: 142 Registered: March 2006
|
Senior Member |
|
|
[B]]Note that db file scattered and sequential read are generally the top wait events when the instance is tuned well and not OPS/RAC. [/B
i read this in a statspack doc.
is this true ??
in what way is RAC affected for sequential/scattered reads ??
|
|
|
Re: db file scattered and sequential read wait events ? [message #190759 is a reply to message #190732] |
Fri, 01 September 2006 02:39 |
kimant
Messages: 201 Registered: August 2006 Location: Denmark
|
Senior Member |
|
|
Hi
Not sure about the exact context this was taken from, so maybe I am not fully correct.
In my mind, the statement *CAN* be true - it depends.
- You can also see a lot of wait for fx. Pl/sql lock timer.
I guess what Your document means is that RAC introduces a number of extra wait events, some of which can go quite high on the list.
Br
Kim
|
|
|