Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to access v$session

755678Sep 7 2010 — edited Sep 7 2010
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!
This post has been answered by orawiss on Sep 7 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2010
Added on Sep 7 2010
5 comments
8,284 views