SQL & PL/SQL

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!

V$SESSION vs GV$SESSION

Neo-bSep 29 2010 — edited Sep 29 2010

Hello All,

I am using Oracle 10g 10.2.0.1.0.
I have two database and on the two users i logged in to the databases i have the " select any dictionary" privilege on both databases.

My problem that when running the below on one of the databases it is working fine while on the other it fail ("table or view does not exist"). Knowing that both databases are not RAC environments, they are one instance database

SELECT USERNAME
INTO username
FROM GV$SESSION

while the below is working fine on both

SELECT USERNAME
INTO username
FROM V$SESSION

What is the reason ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 27 2010

Added on Sep 29 2010

3 comments

1,191 views