The permissions needed for using PFM - RM for Oracle differ depending on what is being used.
The following lists the permissions required for each operation target.
The following table lists the system privileges needed for the Oracle account executing the sp_rist.sql script.
Table I-1 Oracle account privileges needed to execute the sp_rist.sql script
Privileges required | Description |
---|---|
CREATE SESSION | Required when a session is established for the monitored Oracle Database. |
CREATE TABLE | Required when a table#1 required to monitor the monitored Oracle Database is registered. |
CREATE PROCEDURE | Required when a procedure#1 required to monitor the monitored Oracle Database is registered. |
SELECT ANY DICTIONARY | Required when information#1 required to monitor the monitored Oracle Database is registered. |
UNLIMITED TABLESPACE | Required when information#1 required to monitor the monitored Oracle Database is registered#2. |
The following table lists the system privileges needed for the Oracle account executing the sp_rdrp.sql script.
Table I-2 Oracle account privileges needed to execute the sp_rdrp.sql script
Privileges required | Description |
---|---|
CREATE SESSION | Required when a session is established for the monitored Oracle Database. |
The following table lists the system privileges needed for the Oracle account executing the mk_rmus.sql script.
Table I-3 Oracle account privileges needed to execute the mk_rmus.sql script
Privileges required | Description |
---|---|
CREATE SESSION | Required when a session is established for the monitored Oracle Database. |
CREATE USER | Required when a user is created for the monitored Oracle Database. |
GRANT ANY PRIVILEGE | Required when system privileges are granted for the monitored Oracle Database. |
The following table lists the Oracle account system privileges needed for PFM - RM for Oracle to collect performance information.
Table I-4 Oracle account privileges needed by PFM - RM for Oracle to collect performance information
Privileges required | Description |
---|---|
CREATE SESSION | Required when a session is established for the monitored Oracle Database. |
SELECT ANY DICTIONARY | Required to obtain performance information from the monitored Oracle Database. |
UNLIMITED TABLESPACE | Required to obtain the Explain Plan field for the PD_PDSQ records.# |
SELECT ANY TABLE | Required to obtain the Explain Plan (EXPLAIN_PLAN) field for SQL Text (PD_PDSQ) records. |
INSERT ANY TABLE | Required to obtain the Explain Plan (EXPLAIN_PLAN) field for SQL Text (PD_PDSQ) records. |
UPDATE ANY TABLE | Required to obtain the Explain Plan (EXPLAIN_PLAN) field for SQL Text (PD_PDSQ) records. |
DELETE ANY TABLE | Required to obtain the Explain Plan (EXPLAIN_PLAN) field for SQL Text (PD_PDSQ) records. |
CREATE ANY INDEX | Required to obtain the Explain Plan (EXPLAIN_PLAN) field for SQL Text (PD_PDSQ) records. |
ALTER ANY INDEX | Required to obtain the Explain Plan (EXPLAIN_PLAN) field for SQL Text (PD_PDSQ) records. |
The Oracle user account needs all of the privileges listed in Table I-4 to obtain PD_PDSQ records.
When PD_PDSQ records are not obtained, the CREATE SESSION and SELECT ANY DICTIONARY privileges are needed for the Oracle user account.