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!

sessions are not showing in V$session in 10g RAC

32800Mar 4 2007 — edited Mar 5 2007

Hi All,

I have 2-node 10gR2 Rac installed on RHEL4. It is up and running fine. And i'm able to connect from clients also(from other machines). My doubt is...If i connect to the RAC database using other clients, a record is showing in v$session. But if if connect to the database from one of the RAC nodes. that record is not showing up in v$session. What might be the reason?

And how can we see, which user has connected from which node in RAC?

Thanks,
Praveen.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 2 2007

Added on Mar 4 2007

#general-database-discussions

2 comments

580 views