RE: Find out thread in RAC session

[Balakrishnan, Ashok - VSCM]

Hi Vladmir,   You could find it from - select instance_number from v$instance;   You can also query gv$instance to find all sessions connected to both the instances. This query can be run from any instance and it will display all the sessions connected to all the instances. There's a thread_id column which will provide the instance number. For any of the gv$ views to work, you have to enable parallel query (parallel_min_servers > 0).   Regards, Ashok -----Original Message----- From: Vladimir Barac [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 4:29 AM To: Multiple recipients of list ORACLE-L Subject: Find out thread in RAC session Good day to everyone   How do I find under which thread is my current session running in 9i RAC?   Vladimir Barac