1 Reply Latest reply on Jul 24, 2013 6:37 AM by Prince chandra

    spid is same for all the sessions

    Prince chandra

      Hi

       

      Today we have found an issue in one of our database i.e. found the same spid for all the sessions. Used the below query to find the spid. Please suggest how to get back from this issue. We need the spid to get the trace file details.

       

        select  s.sid,     s.serial#,      p.spid, s.program , s.username, s.status

        from    v$session s, v$process p

        where     s.paddr    = p.addr and s.username='DBUSER1';

       

      We are working on AIX6.1 and oracle version is 11.2.0.2.0.