| checkpoint [message #58645] |
Tue, 23 September 2003 12:15  |
nadeem
Messages: 11
Registered: December 2000
|
Junior Member |
|
|
Hai,
I am using Oracle9.2 and Solaris 5.8. I want to force checkpoint. I used fast_start_mttr_target but no use. Please provide me the solution.
Thanks
Nadeem
|
|
|
|
|
|
| Re: checkpoint [message #58648 is a reply to message #58645] |
Tue, 23 September 2003 13:31  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Nadeem,
if you want to force a checkpoint on a running system, you can
alter system checkpoint;
You can also implicitly force a checkpoint by switching the logfile as in
alter system switch logfile;
Checkpoints are also implicitly effected whenever there is a log switch and in other conditions.
FAST_START_MTTR_TARGET allows you to specify instance recovery time which causes Oracle to vary its parameters (including checkpoints) accordingly.
If you are using LOG_CHECKPOINT_INTERVAL or FAST_START_IO_TARGET ,then the fast_start_mttr_target is not effected.
You said 'but no use' . How are you measuring checkpoints ? V$INSTANCE_RECOVERY and V$SYSSTAT can be used to monitor checkpoints.
HTH
Thiru
|
|
|
|
| Re: checkpoint [message #58651 is a reply to message #58645] |
Tue, 23 September 2003 16:31 |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
ALTER SYSTEM CHECKPOINT; will force a checkpoint.
init.ora parm
log_checkpoints_to_alert = true
setting this will record checkpoints in your alert log file, so you could monitor them.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
