1 Reply Latest reply: Oct 5, 2012 5:03 AM by 952768 RSS

    how to find the users list in rac database?

    OraDB
      Friends,

      OS: OEL 6.3 64 bit
      DB: 11gR2 (11.2.0.3)
      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.?

      thanks