The total wait time (in centiseconds) for waits that belong to the Cluster wait class Number of cluster scans that were started Number of blocks obtained in a cluster scan Number of consistent gets that require only block cleanouts, no rollbacks. Number of consistent gets that require both block rollbacks and block cleanouts. Number of calls to routine kcsgrs to get a recent SCNĮlapsed redo write time for changes made to CURRENT blocks in 10s of milliseconds.Ĭleanouts and rollbacks - consistent read gets Number of calls to routine kcmgcs to get a current SCN Number of calls to routine kcmgas to get a new SCN
The SCN is allocated at the start of a transaction. Number of times a snapshot system change number (SCN) was allocated. Useful only for internal debugging purposes Total number of bytes sent over a database link Total number of bytes sent to the client from the foreground processes Total number of bytes received from a database link over Oracle Net Services Total number of bytes received from the client over Oracle Net Services Useful only for internal debugging purposes. Number of times a buffer was pinned when visited.
#Oracle enqueue waits free
Number of times a buffer was free when visited. Number of times an index branch block was split because of the insertion of an additional value
This is a count of the times where a background process has set an alarm for itself and the alarm has timed out rather than the background process being posted by another process to do some work.
#Oracle enqueue waits Offline
Individual file checkpoints for operations such as offline or begin backupįoreground (user-requested) checkpoints (for example, performed by ALTER SYSTEM CHECKPOINT LOCAL statements) This statistic includes only checkpoints of the redo thread. This statistic can be larger than "background checkpoints completed" if a new checkpoint overrides an incomplete checkpoint or if a checkpoint is currently under way.
Number of checkpoints started by the background process. This statistic is incremented when the background process successfully advances the thread checkpoint. Number of checkpoints completed by the background process. The total wait time (in centiseconds) for waits that belong to the Application wait class Table E-1 Database Statistics Descriptions Name
0 kommentar(er)
