Hi,
I migrated a database from oracle 9i to oracle 11g (through export/import method). The db is only 25GB.
Now few users are unable to access the v$session. When we try to access the v$session through certain users, we get the below error
SQL> SELECT SID,SERIAL#,USERNAME,OSUSER,TO_CHAR(LOGON_TIME,'MM/DD/YYYY HH:MI AM') FROM V$SESSION WHERE CLIENT_INFO='MIS0883001MEMOIP' AND STATUS!='KILLED' ORDER BY USERNAME;
SELECT SID,SERIAL#,USERNAME,OSUSER,TO_CHAR(LOGON_TIME,'MM/DD/YYYY HH:MI AM') FROM V$SESSION WHERE CLIENT_INFO='MIS0883001MEMOIP' AND STATUS!='KILLED' ORDER BY USERNAME
*
ERROR at line 1:
ORA-00942: table or view does not exist
However the query runs fine in Oracle 9i database.
I checked all the privileges and it seems to be the same as was the case in Oracle 9i.
Is there any limitations in Oracle 11g that normal users cannot access v$session table?
Thanks!