Permissions needed to monitor an Oracle server

Need permissions to read several of the V$ tables

In order to use the Oracle monitor, you need to be able to see the following V$ tables:

V$STATNAME
V$INSTANCE
V$SESSION
V$SESSTAT
V$SYSSTAT

1. Open up SQL*Plus. Log in with the same user ID and password supplied in the Controller when setting up the Oracle monitor. Run the following SQL statement:

SELECT * FROM V$STATNAME;

2. If you get a "Table or view does not exist" message, have your DBA grant "SELECT_CATALOG_ROLE" permission for the corresponding user id. This will give read permission to the table.

3. Repeat steps 1 and 2 for all the tables above.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s