GeekInterview.com
Series: Subject: Topic:
Question: 174 of 250

What process writes from data files to buffer cache?

Asked by: Interview Candidate | Asked on: Aug 4th, 2005
Showing Answers 1 - 12 of 12 Answers
vinodkumar

Answered On : Mar 21st, 2005

server process

Yes  1 User has rated as useful.
  
Login to rate this answer.
Amit

Answered On : May 7th, 2005

Server Process

Yes  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

Yes  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.
baala

Answered On : Aug 11th, 2008

View all answers by baala

DBWR only writes to the data files. So the answer is Server Process.

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

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.