Aleksey

The period should not be less than 30 seconds because the timer process calculates this function only every 30 seconds. https://www.zabbix.com/documentation/3.4/manual/appendix/triggers/functions Verification period is determined by cron (cron.d/zabbix-pyora). You can...

You can use macros {$DATABASE} - databases SID. Or slightly change script pyora-discovery.py and use different ports (not 1521). pyora-active.py already have argument --port.

You must use own zabbix host for every SID. Like: "Host_ORCL"; macro ${DATABASE} "ORCL" "Host_PROD"; macro ${DATABASE} "PROD"

There are many random tables and partitions.