Overview | Package | Class | Tree | Deprecated | Index | Help

2.01.05
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

## 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

Overview | Package | Class | Tree | Deprecated | Index | Help

2.01.05
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

Send comments or suggestions to interclient@borland.com