Files

HENLO Oracle SYS functions

These scripts are DBA-operated SQL artifacts. The Agent never executes GRANT, DDL, or any write operation.

Apply order:

  1. henlo_ora_monitor.sql
  2. henlo_awr_export.sql only when the DBA has confirmed Diagnostics Pack licensing and AWR access.

Replace <AGENT_SCHEMA> with the read-only Oracle account used by the Agent. Record the applied version in the database change log.

Generate the complete current bundle with:

python scripts/oracle_skill.py sys_functions <AGENT_SCHEMA>

The command reads every .sql file in this directory and replaces the schema placeholder. Any new SYS function must be added here so it is automatically included.