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 ?