-
What is the function of checkpoint (CKPT)?
The Checkpoint (CKPT) process is responsible for signaling DBWR at checkpoints and updating all the data files and control files of the database.
gyanudba
- Feb 6th, 2009
Ckpt (checkpoint) is a background process. It synchronize SCN?of all the database files like?datafiles, control files and redo log files.
taya_ronak
- Feb 2nd, 2009
checkpoint is backgroud process. it'll occur in some situations like during log switch, or on the basis of log_checkpoint_interval or log_checkpoint_timeout parameter in parameter file. ...
-
What are the components of SGA ?
Database buffers, Redo Log Buffer the Shared Pool and Cursors.
Nagaraj OCP
- Dec 27th, 2011
SGA has six parts on it
Shared pool
JAVA POOL
Stream Pool
Large Pool
Data Buffer cache - MRU, LRU
Redo log buffersaihaan
- Jul 2nd, 2009
Yes. they are part of SGA. Sharedpool comprises of Library cache and data dictionary cache.
