Monitoring categories and user permissions
The PATROL for Oracle Enterprise Database KM provides the following monitoring categories for the Oracle standalone and RAC database instances.
For initial connection and availability monitoring, you must use the GRANT CREATE SESSION TO <username> permission. This permission allows the user entered in the environment configuration's Oracle credentials to monitor the database.
Depending on the monitoring category, you must grant certain permissions so each user can access the Oracle objects that are required for each of the monitoring categories.
The following table lists the monitoring category and the required Oracle objects used to perform the monitoring functions.
Monitoring category | Monitor types | Grant types | Variables and authorizations |
|---|---|---|---|
ASM | SELECT | V$ASM_DISK_IOSTAT | |
SELECT | V$ASM_DISKGROUP_STAT | ||
SELECT | V$ASM_DISK_STAT | ||
SELECT | GV$ASM_DISK_IOSTAT | ||
SELECT | GV$ASM_DISKGROUP_STAT | ||
SELECT | GV$ASM_DISK_STAT | ||
Availability and Connection | CREATE | SESSION | |
SELECT | V$PARAMETER | ||
SELECT | V$DATABASE | ||
Fast Recovery Area | SELECT | V$RECOVERY_FILE_DEST | |
SELECT | V$FLASH_RECOVERY_AREA_USAGE | ||
Listeners | SELECT | V$INSTANCE | |
Operating System usage | SELECT | V$RESOURCE_LIMIT | |
SELECT | V$OSSTAT | ||
SELECT | GV$RESOURCE_LIMIT | ||
SELECT | GV$OSSTAT | ||
Pluggable database | SELECT | DBA_PDBS | |
SELECT | V$PDBS | ||
SELECT | V$DATABASE | ||
SELECT | V$SESSION | ||
SELECT | CDB_TABLESPACES | ||
SELECT | CDB_TABLESPACE_USAGE_METRICS | ||
SELECT | GV$PDBS | ||
SELECT | GV$SESSION | ||
ALTER USER | <MONITOR USER NAME> SET CONTAINER_DATA=ALL CONTAINER=CURRENT | ||
RAC | SELECT | V$DATABASE | |
SELECT | V$INSTANCE | ||
SELECT | GV$DATABASE | ||
SELECT | GV$INSTANCE | ||
Services | SELECT | V$SERVICEMETRIC | |
SELECT | GV$SERVICEMETRIC | ||
Sessions | SELECT | V$SESSION | |
SELECT | V$LOCK | ||
SELECT | GV$SESSION | ||
SELECT | GV$LOCK | ||
Standby Health | SELECT | DBA_LOGSTDBY_LOG | |
SELECT | V$ARCHIVED_LOG | ||
SELECT | V$DATABASE | ||
SELECT | V$DATAGUARD_STATS | ||
SELECT | V$RECOVERY_PROGRESS | ||
SELECT | V$LOGSTDBY_STATS | ||
System | SELECT | V$METRIC | |
UNDO usage | SELECT | V$PARAMETER | |
SELECT | V$UNDOSTAT | ||
Users | SELECT | V$METRIC | |
Wait events | SELECT | V$WAITCLASSMETRIC_HISTORY | |
SELECT | GV$WAITCLASSMETRIC_HISTORY | ||
SELECT | V$EVENT_NAME | ||
SELECT | GV$EVENT_NAME | ||
Jobs | SELECT | DBA_SCHEDULER_JOB_RUN_DETAILS | |
SELECT | DBA_SCHEDULER_RUNNING_JOBS | ||
SELECT | DBA_SCHEDULER_JOBS | ||
Tablespaces | SELECT | DBA_TABLESPACE_USAGE_METRICS | |
SELECT | DBA_TABLESPACES | ||
| Wait Time | KOE_INST_WAIT_TIME_SQL | SELECT | V$SQL |
| SELECT | GV$SQL |
Oracle Net Listeners
The following table lists the permissions that PATROL OS account (for local monitoring) and Oracle host user (for remote monitoring) require to monitor Oracle Net Listeners:
File/utility | Permission |
|---|---|
ORACLE_HOME\bin\lsnrctl $ORACLE_HOME/bin/lsnrctl | Execute |
ORACLE_HOME\bin\CRSCTL $ORACLE_HOME/bin/CRSCTL | Execute |
listener.ora | Read |
tnsnames.ora | Read |