org.firebirdsql.management
Interface StatisticsManager
- ServiceManager
- FBStatisticsManager
public interface StatisticsManager
A
StatisticsManager
is responsible for replicating the
functionality of the
gstat
command-line tool.
This functionality includes:
- Retrieving data table statistics
- Retrieving the database header page
- Retrieving index statistics
- Retrieving database logging information
- Retrieving statistics for the data dictionary
getDatabase , getHost , getLogger , getPassword , getPort , getUser , setDatabase , setHost , setLogger , setPassword , setPort , setUser |
DATA_TABLE_STATISTICS
public static final int DATA_TABLE_STATISTICS
Request statistics on data tables.
INDEX_STATISTICS
public static final int INDEX_STATISTICS
Request statistics on indexes.
RECORD_VERSION_STATISTICS
public static final int RECORD_VERSION_STATISTICS
Request statistics on record versions.
SYSTEM_TABLE_STATISTICS
public static final int SYSTEM_TABLE_STATISTICS
Request statistics on system tables.
getDatabaseStatistics
public void getDatabaseStatistics()
throws SQLException
Get the full database statistics information, excluding system table
information. The statistics information is written to this
StatisticsManager
's logger.
The listed data includes:
- statistics header page
- log statistics
- index statistics
- data table statistics
Invoking this method is equivalent to the default behaviour of
gstat
on the command-line.
getDatabaseStatistics
public void getDatabaseStatistics(int options)
throws SQLException
Get specific database statistics. The statistics information is written
to this
StatisticsManager
's logger. All invocations of
this method will result in the header page and log data being output.
The following options can be supplied as a bitmask:
DATA_TABLE_STATISTICS
SYSTEM_TABLE_STATISTICS
INDEX_STATISTICS
RECORD_VERSION_STATISTICS
If this method is invoked with
0
as the
options
value, only the header and log statistics will
be output.
options
- A bitmask combination of
DATA_TABLE_STATISTICS
,
SYSTEM_TABLE_STATISTICS
,
INDEX_STATISTICS
, or
RECORD_VERSION_STATISTICS
.
Can also be 0
, which is equivalent to calling method
getDatabaseStatistics()
getHeaderPage
public void getHeaderPage()
throws SQLException
Fetch the database statistics header page. The header information is
written to this StatisticsManager
's logger.
getTableStatistics
public void getTableStatistics(String[] tableNames)
throws SQLException
Get the table statistics. The statistics information is written
to this
StatisticsManager
's logger.
The listed data includes:
- the primary pointer and index root page numbers
- number of data pages and their average fill
- fill distribution
Invoking this method is equivalent to the behaviour of
gstat -t
on the command-line.
tableNames
- array of table names to analyze.
Copyright B) 2001 David Jencks and other authors. All rights reserved.