Home » RDBMS Server » Server Administration » buffer cache
buffer cache [message #464437] Thu, 08 July 2010 01:55 Go to next message
dalu
Messages: 7
Registered: June 2010
Junior Member
can anyone help me ,which bgprocesses reads the data from datafile to the buffer cache in sga .

Thanks in advance

Report message to a moderator

Re: buffer cache [message #464443 is a reply to message #464437] Thu, 08 July 2010 02:07 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Why not reading oracle documents?
read the concepts you can easily understand.and one more it is not bg/back ground process..its a memory process.

sriram Smile

Report message to a moderator

Re: buffer cache [message #464444 is a reply to message #464443] Thu, 08 July 2010 02:08 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
or search for the oracle architechture as keyword on Internet.

Report message to a moderator

Re: buffer cache [message #464457 is a reply to message #464437] Thu, 08 July 2010 02:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
which bgprocesses reads the data from datafile to the buffer cache in sga .

None (unless one needs it).

Database Concepts

Regards
Michel

[Updated on: Thu, 08 July 2010 02:29]

Report message to a moderator

Re: buffer cache [message #464464 is a reply to message #464444] Thu, 08 July 2010 02:37 Go to previous messageGo to next message
dalu
Messages: 7
Registered: June 2010
Junior Member
"DBWR is responsible for writing dirty data blocks from the database block buffers to disk." this part is clear to me ,

but the reverse 'which process is responsible for reading the data block from disk to database block buffers in case the db block buffer is not having the data block.'

i went through some website there it is written "the process" -- which process i could not find out . if any link is provided it would be helpful.

Thanks in advance
dalu

Report message to a moderator

Re: buffer cache [message #464470 is a reply to message #464464] Thu, 08 July 2010 02:44 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
The dedicated/shared server associated to your session is the process that reads from file.

The link was already provided, the section is the first one before the one you quote: Server Processes.

Regards
Michel

Report message to a moderator

Previous Topic: Estimated dB size if BLOB data type is included
Next Topic: 'defaulted/pointed' to the right tablespace
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 13:12:15 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.