Configuration

All information necessary for the lua gather script to run are stored in the GLOBAL_PARMS table.

There are some parameters should be customized as this heavily deppends on your installation.

SCANS_EXCLUDE_SCHEMAS

For example we have certain Schemas that are for temporary workload only and heavy Data Science users. So for monitoring statements that for table scans we exclude these

To show the current values for this parameter take a look in the GLOBAL_PARMS table:

SELECT
	*
FROM
	GLOBAL_PARMS gp
WHERE
	PARAM_NAME = 'SCANS_EXCLUDE_SCHEMAS'

Default Value

('SYS','EXA_STATISTICS')

SCANS_ROW_MIN

This parameter sets the limit for what qualifies of a heavy scan. The default settings sets a scan to have read a minimum of 20m rows. This also only qualifies when all rows in the table have been read and that table holds more than 20m rows.

To show the current values for this parameter take a look in the GLOBAL_PARMS table:

SELECT
	*
FROM
	GLOBAL_PARMS gp
WHERE
	PARAM_NAME = 'SCANS_ROW_MIN'

Default value:

20000000