What is strange about it? The documentation for v$session does not list serial# as being unique so why wouldn't you expect duplicate values? select count(*),serial# from v$session group by serial#; > l 1 select count(*),serial# from v$session group by serial# 2* having count(*) > 1 > / COUNT(*) SERIAL# ---------- ---------- 20 1 2 6 2 9 2 50026 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rafael Alberto Hernandez Sent: Thursday, January 10, 2013 4:15 AM To: Mark W. Farnham Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: v$session with same serial# but it's really strange have at the same time 14 sessions with the same serial# this behaviour is not normal in other instances and always occurs in this. El 10/01/2013 9:46, Mark W. Farnham escribió: > sid,serial# should be unique as a pair, serial# alone is essentially > meaningless. > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of Rafael Alberto Hernandez > Sent: Thursday, January 10, 2013 3:00 AM > To: oracle-l@xxxxxxxxxxxxx > Subject: v$session with same serial# > > Hi, > > I have a question for your all, i don´t understand because in > v$session we have many sessions (BMC/REMEDY) with different sid and same > serial#. > > I tried to find something about this behavior but i don't find > anything reliable in forums,blogs and Oracle Support. > > Why does this behavior exists? > > > SID SERIAL# MACHINE > ---------- ---------- -------------------- > 64 1 zzz-server > 65 6 zzz-server > 66 3 zzz-server > 67 3 zzz-server > 68 3 zzz-server > 69 3 zzz-server > 70 3 zzz-server > 71 3 zzz-server > 72 3 zzz-server > 73 3 zzz-server > 74 3 zzz-server > 75 3 zzz-server > 76 3 zzz-server > 77 3 zzz-server > 78 3 zzz-server > 79 3 zzz-server > 80 4 zzz-server > 82 50 zzz-server > 83 58 zzz-server > 98 50 zzz-server > > Thanks & Regards, > > Ralberto. > > -- > //www.freelists.org/webpage/oracle-l > > -- Rafael Alberto Hernández Ramos Técnica de Sistemas Area de Producción de Sistemas Dpto. Operaciones Avda. de la Arboleda, S/N. 41940 - Tomares (Sevilla) Tlf: 671599596 (699596) / Fax: 955 061 019/041 e-mail: ralberto.hernandez.ext@xxxxxxxxxxxxxxxxxxx -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l