Oracle Support: You should distribute your log groups to multiple disks to avoid contention.
Me: But doesn't Oracle write to only one group at a time?
Oracle Support: No, we're multi-threaded.
Me: So you're telling me that Oracle writes to more than one redo log group at a time?
Oracle Support: Yes.
Me: Please close this TAR, I'll open another one.
Saturday, November 28, 2009
New to the "Top 5" list
A new entry to my all-time Top 5 list of bad advice I got from Oracle Support:
Subscribe to:
Post Comments (Atom)
3 comments:
groups/members, hey who needs to know the difference anyway!
of course the reading of the previous log groups to archive them *could* give you contention...
Niall
Narh: it's all "multi-threaded"!...
ROTFL Oracle support is on the verge of setting new standards and teaching free of cost some under the hood changes like this ;-).
Aman....
Post a Comment