On Tue, Aug 2, 2011 at 7:19 PM, Sanjeev M <sanjeevorcle@xxxxxxxxx> wrote: > > select p1raw,p1text,event,sid from v$session where sid=1710; > P1RAW > P1TEXT > EVENT SID > ---------------- > ---------------------------------------------------------------- > ---------------------------------------------------------------- ---------- > 0000000356213B10 handle > address library cache > pin 1710 Hi, Add wait_time to your query select p1raw,p1text,event,sid, wait_time from v$session where sid=1710; If wait_time = 0 session is waiting If wait_time <> 0 session is on CPU but event and p1 columns still have old values (Oracle is lazy and doesn't clean it) Probably this is why you have different output from your query and Tanel's tool. If session is on CPU you need to analyse session stats (add stats and gather to snapper) and take a look here - http://blog.tanelpoder.com/2010/01/15/beyond-oracle-wait-interface-part-2/ -- Marcin Przepiorowski http://oracleprof.blogspot.com -- //www.freelists.org/webpage/oracle-l