Scope:
Oracle DB with CDB/PDB - Zabbix templates oracle_agent2 and "Oracle by ODBC"

Use case:
I have Oracle DB (cdb - Container database) instance with more than 100 DB (pdb - pluggable  databases).

Pain point:
Zabbix agent2 and "Oracle by ODBC" is capable to gather only CDB instance stats (from V$SYSMETRIC), 
but no PDB stats (from V$CON_SYSMETRIC) - it is not possible to monitor PDBs directly with "Oracle by ODBC" due to V$SYSMETRIC for PDB is empty and it is huge overhead.

Requirement:
I want to monitor not only CDB instance, but also performance of all PDBs.

Solution:
Add capability to discover all PDBs from CDB instance and all related metrics (e.g. tablespaces, sysmetrics, ... ):

• add rules to gather metrics for discovered PDBs;
• change template/agent logic to read data from "V$CON_*" tables when needed.