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

    spid is same for all the sessions

    Prince chandra



      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