DBWR

I have been reading two different Oracle books in the process of preparing for my OCP examination. One book says that the DBWR background process reads data from datafiles and eventually writes data to datafiles. The other book says that a "Foreground Server" process (not the DBWR) reads the data from datafiles and then the DBWR process writes any modified data back to the datafiles.

The questions is : Which process READS from datafiles? Is it the DBWR or a "Foreground Server" process ? And does this change with an MTS configuration ? And finally if a "Foreground Server" process does read from datafiles, then what is the name of this process ?

Any insight into this will be appreciated.

Thanks to all,
Gus
P.S. Can future responses to this question be also copied to shahwan1_at_hotmail.com Received on Sat Jan 29 2000 - 00:00:00 CST