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!

Why V$session in all instance in RAC show less session than in gv$session ?

mantovamMay 16 2009 — edited May 17 2009
Hi folks

I guess that the differences in v$session and gv$sesson is that one show the current instance and the other all ( global) instance in RAC
In my enviroment have 2 machines in RAC.

If I try to do a select in v$session in the 2 instances in my RAC enviroment, show a "sum" of 70 session.
But if I do a select select in gv$session show a lot of session, more than v$session.

Why this occur?
Have any ideias ?


Tks
Mantovam
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 14 2009
Added on May 16 2009
7 comments
6,651 views