Re: v$session with same serial#
Date: Thu, 10 Jan 2013 13:30:05 +0100
Message-ID: <50EEB44D.5060403_at_juntadeandalucia.es>
Mark, i want show you one instance with 500 sessions approximately and every session has one distinct serial except background processes. I did not expect this behavior (same value of serial#).I expected this: select count(*),serial# from v$session group by serial# order by 1 desc;
COUNT(*) SERIAL#
---------- ----------
20 1
1 789
1 12992
1 9763
1 26487
1 17981
1 18412
1 7033
1 17677
1 7028
1 16728
1 1313
1 55664
1 20173
1 14725
1 54914
1 14219
1 22604
1 39983
1 20176
1 63770
1 35564
1 14358
1 24336
1 37576
1 35588
1 48554
1 45730
1 17226
1 15983
1 14980
1 3557
1 37615
1 23026
1 20633
1 9066
1 16298
1 47789
1 20436
1 9477
1 16102
1 6560
1 8813
1 2201
.....
....
..
..
1 9
1 12016
1 62799
478 filas seleccionadas.
Thanks for your replies
El 10/01/2013 11:03, Mark W. Farnham escribió:
> As Iggy and I have both told you, this is quite normal. For example:
>
> SQL> select count(*),serial# from v$session group by serial#;
>
> COUNT(*) SERIAL#
> ---------- ----------
> 15 1
> 1 28
> 1 394
> 1 133
> 4 3
>
> In fact all the oracle background processes usually have the same serial#
> apart from ones that get started and stopped without the instance being
> restarted. I'm actually wondering a bit about your other instances and what
> would make them NOT have duplicate serial# values consistently.
>
> mwf
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Rafael Alberto Hernandez
> Sent: Thursday, January 10, 2013 4:15 AM
> To: Mark W. Farnham
> Cc: oracle-l_at_freelists.org
> 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_at_freelists.org
>> [mailto:oracle-l-bounce_at_freelists.org]
>> On Behalf Of Rafael Alberto Hernandez
>> Sent: Thursday, January 10, 2013 3:00 AM
>> To: oracle-l_at_freelists.org
>> 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.
>>
>> --
>> http://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_at_juntadeandalucia.es
>
> --
> http://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_at_juntadeandalucia.es -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 10 2013 - 13:30:05 CET