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.

Note

The variables that begin with GV$ are available for the Oracle RAC and Standalone monitoring profiles only.


Monitoring categoryMonitor typesGrant typesVariables and authorizations
ASMASM Disk (KOE_INST_ASM_DISK)GRANT SELECT

V$ASM_DISK_IOSTAT

V$ASM_DISKGROUP_STAT

V$ASM_DISK_STAT

GV$ASM_DISK_IOSTAT

GV$ASM_DISKGROUP_STAT

GV$ASM_DISK_STAT

Availability and ConnectionInstance (KOE_INSTANCE)

GRANT CREATE

GRANT SELECT 

SESSION

V$PARAMETER

V$DATABASE

Fast Recovery AreaOracle Fast Recovery Area (KOE_INST_FRA)GRANT SELECT

V$RECOVERY_FILE_DEST

V$FLASH_RECOVERY_AREA_USAGE

ListenersListeners (KOE_INST_LISTENER)GRANT SELECTV$INSTANCE
Operating System usage

.Operating System Usage (KOE_INST_OS) v2.0


GRANT SELECT

V$RESOURCE_LIMIT

V$OSSTAT

GV$RESOURCE_LIMIT

GV$OSSTAT

Pluggable database

Pluggable Database (KOE_INST_PLUGGABLE_INSTANCE)

Pluggable Tablespace (KOE_INST_PLUGGABLE_TBS)


GRANT SELECT

DBA_PDBS

V$PDBS

V$DATABASE

V$SESSION

CDB_TABLESPACES

CDB_TABLESPACE_USAGE_METRICS

GV$PDBS

GV$SESSION

ALTER USER

<MONITOR USER NAME> SET CONTAINER_DATA=ALL CONTAINER=CURRENT

RACOracle RAC Nodes (KOE_INST_RAC)

GRANT SELECT

V$DATABASE

V$INSTANCE

GV$DATABASE

GV$INSTANCE

ServicesServices (KOE_INST_SERVICE)GRANT SELECT

V$SERVICEMETRIC

GV$SERVICEMETRIC

SessionsSessions (KOE_INST_SESSIONS)GRANT SELECT

V$SESSION

V$LOCK

GV$SESSION

GV$LOCK

Standby HealthStandby Health (KOE_INST_STANDBY)GRANT SELECT

V$DATAGUARD_STATS

V$RECOVERY_PROGRESS

V$LOGSTDBY_STATS

System.System (KOE_INST_SYSTEM) v2.0GRANT SELECTV$METRIC
UNDO usage.UNDO Usage (KOE_INST_UNDO) v2.0GRANT SELECT

V$PARAMETER

V$UNDOSTAT

UsersUsers (KOE_INST_USERS)GRANT SELECTV$METRIC
Wait eventsEvent Class (KOE_INST_EVENT_CLASS)GRANT SELECT

V$WAITCLASSMETRIC_HISTORY

GV$WAITCLASSMETRIC_HISTORY

V$EVENT_NAME

GV$ENVENT_NAME

JobsJobs (KOE_INST_JOBS)GRANT SELECT

DBA_SCHEDULER_JOB_RUN_DETAILS

DBA_SCHEDULER_RUNNING_JOBS

DBA_SCHEDULER_JOBS

TablespacesTablespaces (KOE_INST_TABLESPACE)GRANT SELECT

DBA_TABLESPACE_USAGE_METRICS

DBA_TABLESPACES

Was this page helpful? Yes No Submitting... Thank you

Comments