Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Oracle Description, User's Guide and Reference


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.

Table I‒4: Oracle account privileges needed by 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.