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 126.96.36.199.0.