Thanks Marcin,Mark for clarification - will keep this in mind in future. ~ Sanjeev. On Tue, Aug 2, 2011 at 2:17 PM, Marcin Przepiorowski <pioro1@xxxxxxxxx>wrote: > 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 >