Utilities & Scripts

From zzat
Jump to: navigation, search

Reports

zz_report_error.sql - Show details about an error code from zztat's log table in the last 24h.

zz_report_error_all.sql - Show all details about an error code from zztat's log table, since the start of the data.

zz_report_gauge.sql - Show the current gauges.

zz_report_reaction_config.sql - Shows the reaction configuration parameters and their current values.

zz_report_metric.sql - Show the current metrics.


Enabling Features

The following scripts enable various zztat features:

zz_util_alter_session.sql

zz_util_alter_system.sql

zz_util_dbms_system.sql

zz_util_mail.sql

zz_util_sys_helper.sql

Disabling Features

zz_no_alter_session.sql

zz_no_alter_system.sql

zz_no_dbms_system.sql

Support Scripts & Various

zz_util_sql92.sql

zz_util_void_script.sql

zz_util_recompile.sql - Recompile zztat packages

zz_util_recompile_sys.sql - Recompile the zz$sys_helper package, if it's installed


zzdiag.sql - Run diagnostics and a system status check against a zztat database.

zztail.sh - Follow the zztat log in real-time.