Agresso help and temp tables

Name:	Agresso help and temp tables
Platform:	Oracle
Category:	Agresso
Description:	Collects information about objects (temporary tables and help tables) created in the agresso application schema.
Long description:	Collects information about objects (temporary tables and help tables) created in the agresso application schema.
Version:	1.3
Default schedule:	20 7,16 * *
Requires engine install:	Yes
Compatibility tag:	[CDATA[.[type=‘instance’ & databasetype=‘oracle’]/.[hasengine=‘YES’ & maj_version > 11

Parameters
Name	Default value	Description
Agresso schema owner	agr%	The name of the agresso schema. You can specify a list of schemas (separated by comma). You can use % (percent sign) to represent wild card characters.
Help tables prefix	agr%	Prefix used by the Agresso help tables created when running Agresso reports.
Temporary tables prefix	H%	Prefix used by the temporary tables in the Agresso schema.
warning threshold — total size	1000	Warning threshold, in MB, for aggregated size value for all help and tmp tables.
warning threshold — total count	1000	Warning threshold for total count value of all help and tmp tables.
history threshold	366	The number of days the statistics will be kept in the history table.

Feedback