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:
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.