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