> From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kevin
> As an aside, and as usual for the sake of history, the idea of
multiple writers (processes that build their own write batches) was not
considered until the dawn of NUMA systems in the mid-to-late 90s. See,
having a single writer build batches and task slaves is absolute murder
on a NUMA system. All dbwr latching activity had to take place in the L3
of the building block where dbwr happened to be running. It was, um,
horrible. So, Tirthanker Lahiri listened to our findings and analysis of
our bus traces and implemented multiple true database writers...how
nice. There is more info about that in James Morle's book...
Is it known what exactly is the difference between Oracle's dbwr
"master-slaves" and "mutiple dbwr"? As far as I understand it is about
making access to LRU *parallel* by adding multiply LRU lists, isn't it?
Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 06 2006 - 12:19:55 CDT
