vinodkumar
Answered On : Mar 21st, 2005
server process

1 User has rated as useful.
Login to rate this answer.
Amit
Answered On : May 7th, 2005
Server Process

3 Users have rated as useful.
Login to rate this answer.
Sushma
Answered On : Aug 4th, 2005
DBWR
Login to rate this answer.
Sushma
Answered On : Aug 4th, 2005
Yes, it is server process not DBWR
Login to rate this answer.
guru
Answered On : Feb 16th, 2006
i agree it is database writer..thanks for the reply
Login to rate this answer.
Nirmal
Answered On : Apr 9th, 2006
If the data is not contained in the data buffer cache, it is the server process's responsibility to read the desired data block from a file on disk and place it in the data buffer cache.
Login to rate this answer.
Harsh
Answered On : Nov 9th, 2006
Its server process not DBWR,
DBWR writes from database buffer cache to datafiles.
Login to rate this answer.
ravi saluja
Answered On : Dec 27th, 2006
please read the question carefully. Then Ans.
Is it server process or DBWR
If it is server process kindly explain how a server process writes from datafile to buffer cache.
Please read oracle architecture
I am sure it is DBWR not the server process.
Thanks
Login to rate this answer.
Guest
Answered On : Jan 17th, 2007
please dont give wrong answer
Server Processes
Oracle creates server processes to handle the requests of user processes connected to the instance. In some situations when the application and Oracle operate on the same machine, it is possible to combine the user process and corresponding server process into a single process to reduce system overhead. However, when the application and Oracle operate on different machines, a user process always communicates with Oracle through a separate server process.
Server processes (or the server portion of combined user/server processes) created on behalf of each user's application can perform one or more of the following:
Parse and run SQL statements issued through the application
Read necessary data blocks from datafiles on disk into the shared database buffers of the SGA, if the blocks are not already present in the SGA
Return results in such a way that the application can process the information

1 User has rated as useful.
Login to rate this answer.
MUneef
Answered On : Apr 13th, 2007
It's Server Process and not DBWR
Login to rate this answer.
DBWR only writes to the data files. So the answer is Server Process.

1 User has rated as useful.
Login to rate this answer.
kirankumar c.s
Answered On : May 26th, 2012
server process
Login to rate this answer.