| Checkpoints [message #63371] |
Thu, 30 September 2004 02:13  |
satish
Messages: 112
Registered: September 2000
|
Senior Member |
|
|
Hi,
Any body can explain me how many types of checkpoints
1)when a logswitch occurs it generates a database level checkpoint, and this checkpoint any thing related to log_checkpoint_interval.
My confusion is with log_checkpoint_interval and database level.
If u have any documents related to this please give me the link.
Thanks & Regards
Satish
|
|
|
|
| Re: Checkpoints [message #63403 is a reply to message #63371] |
Sat, 02 October 2004 00:17  |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
Checkpoint happens in the following situations :
1) Log switch occurs
2) Shutdown N/T/I
3) Tablespace - Read only/offline/Begin Backup
and when Checkpoint happens, it does following:
- Signals DBWn to rite dirty buffers to the disk
- Updates Datafiles headers with Checkpoint Information (if ckpt is due to Log switch)
- Updates control files with CKPT information
Information about CKPT can be written to Alert log if u make LOG_CHECKPOINT_TO_ALERT=TRUE
U havent told which version of Oracle ur using if its 9i, then u shudnt use LOG_CHECKPOINT_TIMEOUT and FAST_START_IO_TARGET parameters they are deprecated u shud rather use: FAST_START_MTTR_TARGET.
If FAST_START_MTTR_TARGET=600. Then it means that every 600 secs Checkpoint occurs so that the Instance recovery does not take more that 600 secs.
Vivek.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
