Hi,
I'm running the below query connected to Instance 1 of an Oracle DB with 2 nodes through sqldeveloper.
select * from gv$session where machine = 'CHJAYARA-LAP';
I've just one instance of sqldeveloper opened and just one active connection through it. However the above query returns 3 rows, 2 rows with inst_id = 1 and 1 with inst_id = 2. One row has program = SQL Developer, the others have oracle@XXXXXXX.com and oracle@YYYYYY.com.
Could you please explain the additional 2 rows in gv$session when all I've is just one connection to the DB.
Thanks,
CJM