Home » RDBMS Server » Performance Tuning » db file scattered and sequential read wait events ?
db file scattered and sequential read wait events ? [message #190732] Fri, 01 September 2006 01:12 Go to next message
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 Go to previous message
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
Previous Topic: how to calculate shared pool size ??
Next Topic: Cursor time out error(open cursor on bottleneck)
Goto Forum:
  


Current Time: Tue Dec 06 02:21:18 CST 2016

Total time taken to generate the page: 0.06983 seconds