interbase.interclient
Class DatabaseStatistics

java.lang.Object
  |
  +--interbase.interclient.DatabaseStatistics

public final class DatabaseStatistics

extends Object

Statistics about database page reads and writes to memory and disk, and table operation counts on the database.

Several connections may act on a single database, sharing the same database page cache, and operating on the same tables. So these statistics are database-wide, and include the operation counts of all connections to the database collectively.

Counting begins at zero from the moment the call to getStatistics is made.

Since:

Extension, proposed for InterClient 3.0, not yet supported

See Also:

DatabaseMetaData.getStatistics(), ServerManager.getStatisticsText(java.lang.String, java.util.Map)

Method Summary

int	getBackoutCount(String table) Number of removals of record versions from table.
int	getDeleteCount(String table) Number of database record deletes from table.
int	getDiskReads() Number of database page reads from disk.
int	getDiskWrites() Number of database page writes to disk.
int	getExpungeCount(String table) Number of removals of a record and all of its ancestors from table, for records whose deletions have been committed.
int	getIndexedReadCount(String table) Number of table reads done via an index.
int	getInsertCount(String table) Number of record inserts into table.
int	getMemoryReads() Number of memory reads from cache.
int	getMemoryWrites() Number of memory writes to cache.
int	getPurgeCount(String table) Number of removals of old versions of fully mature records from table (records committed, resulting in older ancestor versions no longer being needed).
int	getSequentialReadCount(String table) Number of sequential table reads.
int	getUpdateCount(String table) Number of table updates.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

getDiskReads

public int getDiskReads()
                 throws SQLException

Number of database page reads from disk.

Throws:

SQLException - if a database access error occurs

Since:

Extension, proposed for InterClient 3.0, not yet supported

getDiskWrites

public int getDiskWrites()
                  throws SQLException

Number of database page writes to disk.

Throws:

SQLException - if a database access error occurs

Since:

Extension, proposed for InterClient 3.0, not yet supported

getMemoryReads

public int getMemoryReads()
                   throws SQLException

Number of memory reads from cache.

Throws:

SQLException - if a database access error occurs

Since:

Extension, proposed for InterClient 3.0, not yet supported

getMemoryWrites

public int getMemoryWrites()
                    throws SQLException

Number of memory writes to cache.

Throws:

SQLException - if a database access error occurs

Since:

Extension, proposed for InterClient 3.0, not yet supported

getBackoutCount

public int getBackoutCount(String table)
                    throws SQLException

Number of removals of record versions from table.

Throws:

SQLException - if a database access error occurs

Since:

Extension, proposed for InterClient 3.0, not yet supported

getDeleteCount

public int getDeleteCount(String table)
                   throws SQLException

Number of database record deletes from table.

Throws:

SQLException - if a database access error occurs

Since:

Extension, proposed for InterClient 3.0, not yet supported

getExpungeCount

public int getExpungeCount(String table)
                    throws SQLException

Number of removals of a record and all of its ancestors from table, for records whose deletions have been committed.

Throws:

SQLException - if a database access error occurs

Since:

Extension, proposed for InterClient 3.0, not yet supported

getIndexedReadCount

public int getIndexedReadCount(String table)
                        throws SQLException

Number of table reads done via an index.

Throws:

SQLException - if a database access error occurs

Since:

Extension, proposed for InterClient 3.0, not yet supported

getInsertCount

public int getInsertCount(String table)
                   throws SQLException

Number of record inserts into table.

Throws:

SQLException - if a database access error occurs

Since:

Extension, proposed for InterClient 3.0, not yet supported

getPurgeCount

public int getPurgeCount(String table)
                  throws SQLException

Number of removals of old versions of fully mature records from table (records committed, resulting in older ancestor versions no longer being needed).

Throws:

SQLException - if a database access error occurs

Since:

Extension, proposed for InterClient 3.0, not yet supported

getSequentialReadCount

public int getSequentialReadCount(String table)
                           throws SQLException

Number of sequential table reads.

Throws:

SQLException - if a database access error occurs

Since:

Extension, proposed for InterClient 3.0, not yet supported

getUpdateCount

public int getUpdateCount(String table)
                   throws SQLException

Number of table updates.

Throws:

SQLException - if a database access error occurs

Since:

Extension, proposed for InterClient 3.0, not yet supported