What process writes from data files to buffer cache?

  • Interview Candidate
  • 12
  • 4439

Showing Answers 1 - 12 of 12 Answers

Sushma

  • Aug 4th, 2005
 

DBWR

  Was this answer useful?  Yes

Sushma

  • Aug 4th, 2005
 

Yes, it is server process not DBWR

  Was this answer useful?  Yes

guru

  • Feb 16th, 2006
 

i agree it is database writer..thanks for the reply

  Was this answer useful?  Yes

Nirmal

  • 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.

  Was this answer useful?  Yes

Harsh

  • Nov 9th, 2006
 

Its server process not DBWR,

DBWR writes from database buffer cache to datafiles.

  Was this answer useful?  Yes

ravi saluja

  • 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

  Was this answer useful?  Yes

Guest

  • 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

MUneef

  • Apr 13th, 2007
 

It's Server Process and not DBWR

  Was this answer useful?  Yes

kirankumar c.s

  • May 26th, 2012
 

server process

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions