How to find session
aaaaaOct 22 2009 — edited Oct 23 2009Hi;
I have 10.2.0.1 on sun. I am using toad. while i try to check session(Database>>Monitor>> Session Browswer) i see only my session is active, i even cant see in locks tab any session.
While i am using prstat comman i see one oracle user (X) running and its using cpu. I use this sql to find who and what happening
select s.sid,s.serial#,s.username,s.osuser,p.spid,p.terminal,s.program from v$session s ,v$process p where paddr=addr and spid="UNIX_PID_NO"
it returns nothing to me
How i can find this oracle user doing what?and why i cant see his session in toad?
Any idea
Thanks alot