| Checkpoint Information [message #490775] |
Thu, 27 January 2011 05:08  |
pokhraj_d
Messages: 117
Registered: December 2007
|
Senior Member |
|
|
Hi ,
I wanted to know the checkpoint information and the interval of checkpoint for my instance.
I have checked alert.log file for the same.
Is there is any other way or any view exists to get that information?
Please help...
Thanks-
P
|
|
|
|
|
|
|
|
| Re: Checkpoint Information [message #490789 is a reply to message #490787] |
Thu, 27 January 2011 06:26  |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
The last checkpoint for the database is in v$database and the last for a particular file in v$datafile_header. Besides that, I'm not aware of any.
PS: If you really must, you can always read the alert log via an external table.
|
|
|
|
|
|
| Re: Checkpoint Information [message #490879 is a reply to message #490775] |
Fri, 28 January 2011 00:07 |
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
|
Senior Member |
|
|
1. You can configure LOG_CHECKPOINTS_TO_ALERT
2. You can query V$SYSSTAT for the statistics 'background checkpoints started' and 'background checkpoints completed'.
You can only monitor background checkpoints -- those that are initiated at log switches.
Also, since 8i, Oracle has implemented incremental checkpoints (e.g. driven by FAST_START_MTTR_TARGET). Therefore, the "full" checkpoint at a log switch isn't necessarily large.
Hemant K Chitale
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
