Home |
Previous Page | Next Page Logging and Log Administration > Checkpoints and Fast Recovery > Monitoring Checkpoint Information >
The sysprofile table
provides the same checkpoint statistics that are available from
the onstat -p option.
The sysprofile table contains two columns, name and value.
The name column contains the statistic name,
and the value column contains the statistic
value. These rows contain the following checkpoint information.
- Checkpoint Statistic
- Description
- numckpts
- Number of checkpoints that have occurred since the database server
was brought online
- ckptwaits
- Number of times that threads waited for a checkpoint to finish to
enter a critical section during a checkpoint
Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]