1.51.2

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 2.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 2.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 2.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 2.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 2.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 2.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 2.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 2.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 2.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 2.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 2.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 2.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 2.0, not yet supported

1.51.2

Send comments or suggestions to interclient@interbase.com