Use the dynamic view V$SYSSTAT to view a variety of statistics. DBAs can use the information to monitor and tune the Tibero database.
Descriptions for each item included in V$SYSSTAT are as follows:
Item | Description |
---|---|
consistent block gets | The number of times that CR blocks were requested. |
consistent multi gets | The number of times that multi CR blocks were requested. |
block gets (CRX) | The number of times that CR block examine was requested. |
block examine rowlock | The number of times that current block examine was requested. |
current block gets - waits | The number of times that the system waited to get a current block. |
block disk read | The number of times that blocks were read from a disk. |
multi block disk read - requested | The number of times that multi blocks were read from a disk. |
current block gets | The number of times that a current block was requested. |
current block gets - no wait | The number of times that a current block was obtained without waiting. |
block disk read undo header block | The number of times that undo blocks were read from a disk. |
block changes - current + consistent | The number of times that blocks in a buffer cache were changed. |
multi block read complete | The number of times that the system waited until reading was complete after a multi-block was requested. |
current block cleanout | The number of times that cleanout was executed for a current block. |
current block partial cleanout | The number of times that partial cleanout was executed for the current block. |
buffer cache invalidate | The number of times that buffer caches were invalidated. |
block corrupt logging | The number of times that buffer cache corrupts were marked. |
block pin - not conflict | The number of times that a buffer cache was pinned. |
block unpin | The number of times that a buffer cache was unpinned. |
block wait (ckpt + writing) | The number of times that a buffer cache waited until checkpoint and flush were complete. |
block wait (writing) | The number of times that a buffer cache waited until flush was complete. |
block copy in ckpt progress or write | The number of times that a buffer cache that was executing checkpoint was copied. |
block copy on write | The number of times that a buffer cache that was executing flush was copied. |
candidate bh scanned | The number of times that buffers were searched in a buffer cache chain. |
block cleanouts | The number of times that cleanout was executed for entire blocks. |
block partial cleanout - total | The number of times that partial cleanout was executed. |
checkpoint requests | The number of times that checkpoints were requested. |
checkpoint requested - media recovery | The number of times that checkpoints were requested by media recovery. |
checkpoint requested - instance recovery | The number of times that checkpoints were requested by instance recovery. |
switching logfile waits - incomplete checkpoint | The number of times that checkpoints were requested by log file switching. |
checkpoint requests - timeout | The number of times that checkpoints were requested by timeout. |
checkpoint requests - cache invalidate | The number of times that checkpoints were requested by invalidating buffers. |
checkpoint requests - log block interval | The number of times that checkpoints were requested by CKPT_LOG_INTERVAL. |
checkpoint requests - next logfile | The number of times that checkpoints were requested to prepare the next log file switch. |
consistent block created - converted from current | The number of times that a current buffer was changed to a CR buffer. |
consistent block cleanout | The number of times that cleanout was executed for CR blocks. |
consistent block partial cleanout | The number of times that partial cleanout was executed for CR blocks. |
consistent rollback | The number of times that rollback was executed for CR blocks. |
consistent block created - clone | The number of times that duplicated to create CR blocks. |
consistent gets - no clone | The number of times that CR blocks were obtained without duplication. |
tx table consistent rollback | The number of times that rollback was executed for transaction tables. |
dbwr flush requests - make clean | The number of times that flush was requested from DBWR to create an empty buffer. |
dbwr flush requests - force | The number of times that blocks were flushed due to requests of an instance in TAC. |
dbwr flush requests - checkpoint | The number of times that flush was requested from DBWR for checkpoints. |
dbwr lru list scans | The number of times that DBWR searched LRU. |
dbwr writing list scans | The number of times that DBWR searched LRU to be flushed. |
dbwr write - OS | The number of times that DBWR requested writing to OS. |
dbwr write block count - OS | The number of blocks that DBWR flushed. |
dbwr written block count | The number of blocks that DBWR flushed for other instances. |
dbwr written block count - checkpoint list | The number of blocks that DBWR flushed for checkpoints. |
dbwr written block count - lru list | The number of blocks that DBWR flushed for empty blocks. |
dbwr written block count - adjacent | The number of blocks that DBWR flushed for multi block writing. |
dbwr writes for incremental checkpoint | The number of times that DBWR worked for incremental checkpoints. |
dbwr multi block writes | The number of times that DBWR wrote multi blocks. |
dbwr log flush requests | The number of times that DBWR requested flush to LGWR. |
log flush | The number of times that LGWR flushed log buffers. |
lgwr logfile switch | The number of times that log files were switched. |
lgwr wait for copy | The number of times that LBWR waited for a session which copied to a log buffer. |
redo wait for lgwr | The number of times that the system waited until a log buffer flush completed. |
loga write | The number of times that LARC wrote. |
free blocks scanned block count | The number of buffers searched while finding empty buffers. |
free blocks scanned - pinned seen | The number of pinned buffers detected while finding empty buffers. |
free blocks scanned - dirty seen | The number of dirty buffers detected while finding empty buffers. |
free blocks scanned - writing clean seen | The number of flushing buffers detected while finding empty buffers. |
free blocks requested | The number of times that empty buffers were searched. |
free blocks total waits | The number of times that the system waited for empty buffers. |
free blocks - invoke dbwr | The number of times that flush was requested for DBWR because an empty buffer was not found. |
redo entries | The number of times that Redo logs were copied to a log buffer. |
redo space allocation trials | The number of times that spaces were obtained to copy Redo logs. |
redo log space requests | The number of times that flush was requested because of insufficient Redo buffers. |
redo wait for logfile switch | The number of times that the system waited for log file switch to write Redo logs. |
redo wait for flush | The number of times that the system waited for a flush of Redo logs. |
redo write | The number of times that Redo flush was executed. |
redo write multi | The number of times that multiple requests for a Redo flush were handled at the same time. |
block updates | The number of times that Redo logs were written and blocks were modified. |
[CCC,MASTER] cr request on the master(requester = master) | [CCC] The number of times that master requested CR from a holder |
[CCC,MASTER] cr request fail on the master(requester = master) | [CCC] The number of times that CR requested by master failed. |
[CCC,MASTER] cr make on the master(holder = master) | [CCC] The number of CR blocks created by a master. |
[CCC,MASTER] cr make fail on the master(holder = master) | [CCC] The number of times that a master failed to create CR. |
[CCC,SHADOW] cr request on the shadow | [CCC] The number of CR requests from a shadow. |
[CCC,SHADOW] cr request fail on the shadow | [CCC] The number of times that CR request from a shadow failed. |
[CCC,SHADOW] cr make on the holder | [CCC] The number of CR requests from a holder. |
[CCC,SHADOW] cr make fail on the holder | [CCC] The number of times that a holder failed to create CR. |
Number of times to wait & process CR reply for prefetch | The time and The number of times that the system waited to handle a lock during multi-block prefetch. |
Number of sleeps to wait CR reply for prefetch | The number of times that the system waited for another node's response during JC_TAC_PREFETCH_POST. |
Number of locks prefetched | The number of times that a lock was preset for DPL and IndexFastBuild. |
Number of waiting previous CR reply | The number of times that the system waited for termination as CR was already requested when CR was requested. |
Number of waiting BUSY flag to cancel lock | The number of times that the system waited for lock cancel. |
Number of waiting CCC remastering | The number of times that lock requests were suspended because cache lock was remastering. |
Number of waiting RCOC status | The number of times that the cache waited to monitor another node's status. |
Number of waiting RCOC start | The number of times that the system waited until cache recovery started. |
Number of times to reclaim CCC during reconfiguration | The number of times that memory was recalled because of insufficient cache RSB. |
Number of times retrying to reclaim CCC | The number of attempts because of insufficient recalled cache RSB memory. |
Number of times to wait the other reclaim CCC | The number of times that another thread waited until recalling cache RSB memory completed. |
Number of times to allocate new CCC RSB | The number of times that RSB was newly created. |
Number of times to reclaim CCC RSB | The number of times that memory was recalled. |
Number of blocks received from a remote CR Server | The number of times that CR created by another node was obtained. |
Number of locks granted from the master | The number of times that another node received locks. |
Number of UP locks processed as master | The number of times that a node handled lock up as a master. |
Number of DOWN locks processed as master | The number of times that a node handled lock down as a master. |
Number of waiting CWS remastering | The number of times that lock requests were suspended because a Wlock lock was remastering. |
Number of waiting RCOW status | The number of times that Wlock waited to monitor another node's status in Wlock. |
Number of waiting RCO start | The number of times that Wlock recovery started. |
Number of times to reclaim CWS during reconfiguration | The number of times that memory was recalled because of insufficient Wlock RSB during reconfiguration. |
Number of times retrying to reclaim CWS | The number of attempts because of insufficient recalled Wlock RSB memory. |
Number of times to wait the other reclaim CWS | The number of times that another thread waited until recalling Wlock RSB memory was ended. |
Number of times to wait ctx sync | The number of times that the system waited to match reconfiguration status with another node. |
Number of times to wait acf task ready | The number of times that the system waited to prepare a TAC background process. |
Number of times to retry receive INC packet | The number of times that EAGAIN occurred while receiving a TAC packet. |
Number of receiving INC packet | The number of times that packets for TAC were received. |
Number of errors during receiving INC packet | The number of errors that occurred while sending a TAC packet. |
Number of times to retry send INC packet | The number of times that EAGAIN occurred while sending a TAC packet. |
Number of sending INC packet | The number of times that packets for TAC were sent. |
Number of errors during sending INC packet | The number of errors that occurred while sending a TAC packet. |
Number of re-scanning send msg Q | The number of attempts to search a queue because unsent TAC packets remained. |
Number of times to wait DSPC working | The number of times that a DSPC thread waited to be resumed. |
Number of times to wait DSPC suspend | The number of times that a DSPC thread waited to be suspended. |
csr fetch insert | The time to execute INSERT in a DML statement. |
csr fetch delete | The time to execute DELETE in a DML statement. |
csr fetch update | The time to execute UPDATE in a DML statement. |
csr fetch select | The time to execute a SELECT query. |
ex workarea cache hit count | The number of cache hits for private context required to execute a query. |
ex workarea cache miss count | The number of cache misses for private context required to execute a query. |
ex cache miss count for different param types | The number of cache misses for private context required to execute a query because a bind parameter type was different. |