This discussion is archived
1 Reply Latest reply: Oct 5, 2012 3:03 AM by 952768 RSS

how to find the users list in rac database?

OraDB Newbie
Currently Being Moderated

OS: OEL 6.3 64 bit
DB: 11gR2 (
2 node rac with ASM.

in the node1 i logged in as sys.
and in the second node i logged in as hr
when i try to check the usernames in v$session in node1....i didnt find the username hr...
how can i check the username list of all the users who are logged in the rac database?
if i check in each node's v$session i am getting but how can i check it any node for all the loggedin usernames.?



  • Correct Answers - 10 points
  • Helpful Answers - 5 points