Note: Documentation for Pivotal SQLFire 1.1.x is now available at http://docs.gopivotal.com/sqlfire/index.html. Please reference the docs.gopivotal.com site for the latest and most up-to-date documentation on SQLFire. The vFabric SQLFire documentation site will no longer be updated.

SYS.SET_GLOBAL_STATEMENT_STATISTICS

Configures statement statistics collection for all members and client connections in a SQLFire distributed system.

This procedure enables or disables statement statistics collection for the distributed system as a whole. You can optionally gather time statistics along with statement statistics. See Collecting System Statistics.

Syntax

SYS.SET_GLOBAL_STATEMENT_STATISTICS (
IN ENABLESTATS BOOLEAN NOT NULL,
IN ENABLETIMESTATS BOOLEAN NOT NULL
)
ENABLESTATS
Specifies whether the system should collect statement statistics.
ENABLETIMESTATS
Specifies whether the system should also collect time-based statement statistics.

Example

This command enables time-based statement statistics for the entire SQLFire distributed system:
call sys.set_global_statement_statistics (true, true);