Re: v$session with same serial#

From: Rafael Alberto Hernandez <ralberto.hernandez.ext_at_juntadeandalucia.es>
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-l
Received on Thu Jan 10 2013 - 13:30:05 CET

Original text of this message