3 entries per session gv$session
755353Aug 27 2010 — edited Feb 28 2011Hi,
I have one open connection to 11.2 db and one to 11.2 db
when i execute select username,inst_id from gv$session where username like 'abc';
it returns one row in 11.1 but 3 rows in 11.2 whis is this? i only have one connection to 11.2 db as user abc!
USERNAME INST_ID
------------------------------ ----------
ABC 1
ABC 1
ABC 2
thanks