to check details of id running the processes which are identified from ps listing

to check details of id running the processes which are identified from ps listing

select b.username,b.schemaname,b.osuser,b.process,b.machine,b.terminal from v$session b,v$process a where b.paddr=a.addr and a.spid='&1'