Which action takes place when a file checkpoint occurs?
A.
The checkpoint position is advanced in the checkpoint queue.
B.
The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log
files.
C.
All buffers for a checkpointed file that were modified before a specific SCN are written to
disk by DBWn and the SCN is stored in the control file.
D.
The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data
files.
la C is correct.
http://oracleinaction.com/checkpoints/
FILE CHECKPOINT
When a tablespace is put into backup mode or take it offline, Oracle writes all the dirty blocks from the tablespace to disk before changing the state of the tablespace.
– Writes block images to the database for all dirty buffers for all files of a tablespace from all instances
– Statistics updated
. DBWR checkpoints
. DBWR tablespace checkpoint buffers written
. DBWR checkpoint buffers written
– Caused by :
. Alter tablespace xxx offline
. Alter tablespace xxx begin backup
. Alter tablespace xxx read only
– Controlfile and datafile headers are updated
. Checkpoint_change#
D is correct
C
D
I have noticed you don’t monetize your page,
don’t waste your traffic, you can earn additional cash every month because you’ve got
hi quality content. If you want to know how to make extra $$$, search for: Boorfe’s tips best adsense alternative
Hello, is anybody here interested in online working?
It’s simple survey filling. Even 10$ per survey (10
minutes duration). If you are interested, send me e-mail to
hans.orloski[at]gmail.com