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);