I.4 When performance information is collected
The following table lists the Oracle account system privileges needed for PFM - Agent 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. |
- #
-
This privilege is not needed when the assignment limit that allows writing to the default tablespace of the account used for monitoring has been set.
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.