4 Replies Latest reply: Oct 11, 2012 6:15 AM by Cherif bh RSS

    ORA 01422 and V$SESSION & AUDSID

    Cherif bh
      Hi all,

      We have a client sent us the below Oralce error : ORA-01422

      SELECT DISTINCT SID INTO My_sid FROM V$SESSION WHERE AUDSID=USERENV('SESSIONID');

      could you please help, does v$session contain many session having the same audsid ?
      Is this error related to RAC architecure or ASSM ?

      Thanks

      Edited by: BIJGA on Oct 11, 2012 2:44 AM