Database Management Technology

Architecture | Monitor | Sentinel | Query | Testimonials | Documentation | Downloads
Courses | On-Site Courses | Course Schedule | Testimonials |
DBAnalyzer | JVM
Contact Info

logging_stats

The logging_stats table contains logging system activity statistics for the current installation.  One row is returned for each vnode in the current IMA management domain.  Delta columns represent changes in counter values in the last interval.

 
Attribute Name Key Datatype Description
timestamp 0 date Date and time the data was collected
delta_seconds 0 integer4 Elapsed time (seconds) since the previous refresh.
vnode 1 varchar(64) Ingres virtual node name
dual_read_ios 0 integer4 Count read operations from the dual transaction log since installation startup.
dual_read_ios_d 0 integer4 Count of read operations from the dual transaction log in the last interval.
dual_write_ios 0 integer4 Count of write operations to the dual transaction log since installation startup.
dual_write_ios_d 0 integer4 Count of write operations to the dual transaction log in the last interval.
txn_ends 0 integer4 Count of transactions completed since installation startup.
txn_ends_d 0 integer4 Count of transactions completed in the last interval.
log_forces 0 integer4 Count of force operations to the current transaction log since installation startup.
log_forces_d 0 integer4 Count of force operations to the current transaction log in the last interval.
kbytes 0 integer4 Measure of logging data written to the transaction log since installation startup, units are Kbytes.
kbytes_d 0 integer4 Measure of logging data written to the transaction log in the last interval, units are Kbytes.
log_read_ios 0 integer4 Count of read operations from the primary transaction log since installation startup.
log_read_ios_d 0 integer4 Count of read operations from the primary transaction log in the last interval.
log_write_ios 0 integer4 Count of physical writes to the primary transaction log.
log_write_ios_d 0 integer4 Count of physical writes to the primary transaction log in the last interval.
split_waits 0 integer4 Count of log waits initiated by split write operations.
split_waits_d 0 integer4 Count of log waits initiated by split write operations in the last interval.
log_waits 0 integer4 Count of log wait operations since installation startup.
log_waits_d 0 integer4 Count of log wait operations in the last interval.
log_writes 0 integer4 Count of logical writes to logging system buffers.
log_writes_d 0 integer4 Count of logical writes to logging system buffers in the last interval.
writeio 0 integer4 Count of physical writes to the transaction log.
writeio_d 0 integer4 Count of physical writes to the transaction log in the last interval.
prim_last_block 0 integer4 Most recent block written to the primary transaction log.
dual_last_block 0 integer4 Last block read or written to/from the primary transaction log.
lfbb_size 0 integer4 Maximum number of log file blocks which can be allocated by the logging system.
ldb_inuse 0 integer4 Number of log database blocks currently in use, this is the number of open databases.
ldbb_count 0 integer4 Number of log database blocks allocated by the logging system.
lfbb_count 0 integer4 Count of lof file block allocated by the logging system.
lpb_inuse 0 integer4 Count of log process blocks currently in use.
lpb_allocated 0 integer4 Count of log process blocks allocated by the logging system.
lpd_inuse 0 integer4 Count of log process database blocks currently in use.
lpd_allocated 0 integer4 Count of log process database blocks allocated by the logging system.
lxb_inuse 0 integer4 Count of transaction blocks currently in use.
lxbb_allocated 0 integer4 Count of transaction blocks allocated by the logging system.
no_bcp 0 integer4 If 1, consistency point is in progress and a new one cannot be started.
protect_count 0 integer4 Current count of protect transactions, that is transactions which must be rolled back if aborted.
db_add 0 integer4 Count of database add operations since installation startup.
db_add_d 0 integer4 Count of database add operations in the last interval.
bcp_stall_waits 0 integer4 Log stalls caused by BCP (begin consistency point) writes.
bcp_stall_waits_d 0 integer4 Log stalls caused by BCP (begin consistency point) writes in the last interval.
txn_begins 0 integer4 Count of transactions started since installation startup.
txn_begins_d 0 integer4 Count of transactions started in the last interval.
dual_readio 0 integer4 Count of read operations from the dual transaction log since installation startup.
dual_readio_d 0 integer4 Count of read operations from the dual transaction log in the last interval.
dual_writeio 0 integer4 Count of write operations to the dual transaction log since installation startup.
dual_writeio_d 0 integer4 Count of write operations to the dual transaction log in the last interval.
lgd_txn_ends 0 integer4 Count of transactions completed by the logging system since installation startup.
lgd_txn_ends_d 0 integer4 Count of transactions completed by the logging system in the last interval.
force 0 integer4 Count of log buffers forced to the transaction log.
force_d 0 integer4 Count of log buffers forced to the transaction log in the last interval.
free_waits 0 integer4 Count of waits for free log buffers since installation startup.
free_waits_d 0 integer4 Count of waits for free log buffers in the last interval.
group_count 0 integer4 Count of log buffers written during group commit processing.
group_count_d 0 integer4 Count of log buffers written during group commit processing in the last interval.
group_force 0 integer4 Count of log buffers forced to the transaction log during group commit processing.
group_force_d 0 integer4 Count of log buffers forced to the transaction log during group commit processing in the last interval.
inconsistent_db 0 integer4 Count of databases marked inconsistent since installation startup.
inconsistent_db_d 0 integer4 Count of databases marked inconsistent in the last interval.
kbytes_written 0 integer4 Measure of logging data written to all active transaction logs since installation startup, units are Kbytes.
kbytes_written_d 0 integer4 Measure of logging data written to all active transaction logs in the last interval, units are Kbytes.
log_readio 0 integer4 Count of read operations from all configured transaction logs since installation startup.
log_readio_d 0 integer4 Count of read operations from all configured transaction logs in the last interval.
log_writeio 0 integer4 Count of physical writes to the transaction log.
log_writeio_d 0 integer4 Count of physical writes to the transaction log in the last interval.
pgyback_check 0 integer4 Count of piggyback write checks since installation startup.
pgyback_check_d 0 integer4 Count of piggyback write checks in the last interval.
pgyback_write 0 integer4 Count of write operations initiated by piggyback write.
pgyback_write_d 0 integer4 Count of write operations initiated by piggyback write in the last interval.
readio 0 integer4 Count of physical read operations from the transaction log.
readio_d 0 integer4 Count of physical read operations from the transaction log in the last interval.
db_remove 0 integer4 Count of database remove operations since installation startup.
db_remove_d 0 integer4 Count of database remove operations in the last interval.
split 0 integer4 Count of split write operations since installation startup.
split_d 0 integer4 Count of split write operations in the last interval.
stall_wait 0 integer4 Count of log write operations stalled.
stall_wait_d 0 integer4 Count of log write operations stalled in the last interval.
wait 0 integer4 Count of log waits since installation startup.
wait_d 0 integer4 Count of log waits in the last interval.
log_write 0 integer4 Count of logical log writes performed since installation startup.
log_write_d 0 integer4 Count of logical log writes performed in the last interval.
lgd_writeio 0 integer4 Count of physical writes to all transaction logs performed by the logging system since installation startup.
lgd_writeio_d 0 integer4 Count of physical writes to all transaction logs performed by the logging system in the last interval.

 


About DMT | Contact Us | ©2004 Database Management Technology, Inc. All rights reserved.