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
ASM
ASM Disk (KOE_INST_ASM_DISK)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
Instance (KOE_INSTANCE)

CREATE 

SESSION

SELECT

V$PARAMETER

SELECT

V$DATABASE

Fast Recovery Area

Oracle Fast Recovery Area (KOE_INST_FRA)SELECT

V$RECOVERY_FILE_DEST

SELECT

V$FLASH_RECOVERY_AREA_USAGE

ListenersListeners (KOE_INST_LISTENER)SELECTV$INSTANCE
Operating System usage

Oracle OS Usage (KOE_INST_OS)

SELECT

V$RESOURCE_LIMIT

SELECT

V$OSSTAT

SELECT

GV$RESOURCE_LIMIT

SELECT

GV$OSSTAT

Pluggable database

Pluggable Database (KOE_INST_PLUGGABLE_INSTANCE)

Pluggable Tablespace (KOE_INST_PLUGGABLE_TBS)

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



Oracle RAC Nodes (KOE_INST_RAC)SELECT

V$DATABASE

SELECT

V$INSTANCE

SELECT

GV$DATABASE

SELECT

GV$INSTANCE

Services

Services (KOE_INST_SERVICE)SELECT

V$SERVICEMETRIC

SELECT

GV$SERVICEMETRIC

Sessions



Sessions (KOE_INST_SESSIONS)SELECT

V$SESSION

SELECT

V$LOCK

SELECT

GV$SESSION

SELECT

GV$LOCK

Standby Health

Standby Health (KOE_INST_STANDBY)SELECT

DBA_LOGSTDBY_LOG

SELECT

V$ARCHIVED_LOG

SELECT

V$DATABASE

SELECT

V$DATAGUARD_STATS

SELECT

V$RECOVERY_PROGRESS

SELECT

V$LOGSTDBY_STATS

SystemSystem (KOE_INST_SYSTEM)SELECTV$METRIC
UNDO usage
UNDO Usage (KOE_INST_UNDO)SELECT

V$PARAMETER

SELECT

V$UNDOSTAT

UsersUsers (KOE_INST_USERS)SELECTV$METRIC
Wait events
Event Class (KOE_INST_EVENT_CLASS)SELECT

V$WAITCLASSMETRIC_HISTORY

SELECT

GV$WAITCLASSMETRIC_HISTORY

SELECT

V$EVENT_NAME

SELECT

GV$EVENT_NAME

Jobs
Jobs (KOE_INST_JOBS)SELECT

DBA_SCHEDULER_JOB_RUN_DETAILS

SELECT

DBA_SCHEDULER_RUNNING_JOBS

SELECT

DBA_SCHEDULER_JOBS

Tablespaces
Oracle Tablespace (KOE_INST_TABLESPACE)SELECT

DBA_TABLESPACE_USAGE_METRICS

SELECT

DBA_TABLESPACES

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/utilityPermission

ORACLE_HOME\bin\lsnrctl

$ORACLE_HOME/bin/lsnrctl

Execute

ORACLE_HOME\bin\CRSCTL

$ORACLE_HOME/bin/CRSCTL

Execute
listener.oraRead

tnsnames.ora

Read

Note

In remote monitoring, you can monitor listeners configured on the UNIX platforms only. 


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

Comments

  1. Timothy Pun
    1. What the GV$ENVENT_NAME ? Is that GV$EVENT_NAME? Please correct.
    2. The format of the table is not good, especially the column grant type is splitted into two role. Please correct.
    Apr 19, 2023 09:12
    1. Swati Malhotra

      Thanks for your feedback, Timothy Pun ! Appreciate your comment. We have fixed the table and permissions. Do let us know if more changes are required.


      Thanks and regards,

      Swati 

      Apr 20, 2023 02:34
  2. Timothy Pun

    Thanks for your quick respond.

    Apr 20, 2023 03:18