User receives this error message when accessing the Session Browser:
'ORA-00942: Table or view does not exist'
To resolve this problem, make sure that your database has the following public synonyms must be present:
V$SESSION
V$PROCESS
V$SESS_IO
V$SESSION_WAIT
V$SESSION_EVENT
V$ACCESS
V$SESSSTAT
V$STATNAME
V$OPEN_CURSOR
V$SQL
V$LOCK
V$SESSION_LONGOPS
V$SQLTEXT_WITH_NEWLINES
In addition, you must have access to the following:
SYS.V_$TRANSACTION
SYS.V_$ROLLNAME
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center