1
Create a monitoring user
SELECT_CATALOG_ROLE covers the data dictionary views Zynty reads from; it does not grant access to application schemas or data.
CREATE USER zynty_ro IDENTIFIED BY "STRONG_PASSWORD"; GRANT CREATE SESSION TO zynty_ro; GRANT SELECT_CATALOG_ROLE TO zynty_ro; GRANT SELECT ANY DICTIONARY TO zynty_ro;
2
Add the instance in Zynty
Provide the host, port (default 1521) and the service name or SID your listener uses.
1
2
3
Watch tablespace growth
Oracle tablespaces that hit 100% cause hard application failures rather than graceful degradation, set an early warning threshold (80-85%) rather than alerting only at the limit.