SCO Unix 7
Oracle 8.1.6
Hi friends..
I did a sar and have a lot of resource consumed in usr%
I then did a ps -ef and found some processes which belonged to oracle sessions where a lot of processing resource was consumed. I took a note of the pid (1234).
From Sqlplus i issued :
select username, osuser, sid, serial#
from v$session
where process like '%1234%';
I got 'no rows selected'
Does anyone know where this session is ?
It is not background process I know it is a user session as it has a CMD of 'sid (LOCAL= NO)'.
can anyone tell me what/where this process is ?
Thanks
Suresh
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.