onActiveTableTable

The following list summarizes this table:
Contents:
Information about the open and active database tables
Index:
applIndex, rdbmsDbIndex, onTableIndex
Scope of a row:
One open and active database table
For a fragmented database table, the values in this table are summaries of the values from all the fragments of the database table. The table has the following MIB objects.
Table 1. MIB objects for onActiveTableTable
MIB Object Description
applIndex See applTable.
rdbmsDbIndex See rdbmsDbTable.
onTableIndex See onDbspaceTable.
onActiveTableStatus Status of the table:
  • not Busy (1): The table is not in use.
  • busy (2): The table is in use.
  • dirty (3): The table has been modified.
onActiveTableIsBeingAltered State of the table:
  • Yes (1): The table is being altered. (An index is being added or dropped, an ALTER TABLE statement is being executed, the alter page count is being updated, or pages are being altered to conform to the latest schema.)
  • No (2): The table is not being altered.
onActiveTableUsers Number of users accessing the table
onActiveTableLockRequests Number of lock requests
onActiveTableLockWaits Number of lock waits
onActiveTableLockTimeouts Number of lock timeouts
onActiveTableIsamReads Number of reads from the database table
onActiveTableIsamWrites Number of writes to the database table
onActiveTableBufferReads Number of buffer reads
onActiveTableBufferWrites Number of buffer writes