| Napster |
Posted: Jan 23, 2008 12:15:34 AM |
Total Post: 6
Joined: Jan, 2008
|
Hi,
I would like to know which process reads in to datafiles to place it in database buffer cache.
Also does ARCn create or write archived log files or does both?????
thanks |
|
|
 Napster |
| Posted: Jan 23, 2008 12:30:00 AM |  |
|
Total Post: 6
Joined: Jan, 2008
|
hi,
also i would like to know what CKPT actually does...
to which files does it write ?????
thanks
|
|
|
|
|
| Orcl.sg |
| Posted: Jan 23, 2008 10:58:57 AM | |
|
Total Post: 12
Joined: Dec, 2007
|
DBWR ,yes ARCH process does both .when a checkpoint occurs
Every dirty block in the buffer cache is written to the data files,DBWR writes all modified databaseblocks of disk and SCN is updated in header
|
|
|
|
|
| dbavinod |
| Posted: Feb 07, 2008 05:36:16 AM | |
|
Total Post: 90
Joined: Sep, 2006
|
Sorry , read carefully
The database writer process (DBWn) writes the contents of buffers to datafiles.
Server processes 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
The log writer process (LGWR) is responsible for redo log buffer management—writing the redo log buffer to a redo log file on disk
The archiver process (ARCn) copies redo log files to a designated storage device after a log switch has occurred
Vinod
|
|
|
|
|
| moni |
| Posted: Jul 01, 2008 06:22:04 AM | |
|
Total Post: 6
Joined: Jul, 2008
|
Yes Vinod is right. Server process reads the blocks from the datafile and puts that into the DB Cache if its not allready there.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
