Re: Is an INACTIVE session executing a statement?

Are you sure all rows haven't already been fetched? That the SQL*Plus PAUSE isn't just pausing output while already having fetched everything?

My first guess would be that if it really is in FETCH phase, then it should be waiting on something other than "SQL*Net message from client"? But it is just a guess that you might be able to distinguish via the wait events?

Regards

Kim Berg Hansen

http://dspsd.blogspot.com
kibeha_at_gmail.com
_at_kibeha

On Wed, Feb 19, 2014 at 12:20 PM, Martin Berger <martin.a.berger_at_gmail.com>wrote:

> Hi list,
>
> (I'm in 11.2.0.3/11.2.0.4EE _at_ RH5.8 env right now)
>
> I try to investigate if a session with STATUS=INACTIVE has a statement
> "in execution" (and maybe get more informations about it).
>
> to make it more clear a simple testcase:
> in sqlplus
> set pause on
> select * from dba_objects;
> when checking this session, it is in STATUS=INACTIVE but the statement is
> still somewhere in FETCH phase (if I hit enter again in the test-sqlplus,
> more rows are coming).
>
> I tried to distinguish this session state from another, where we have a
> "really idle" sqlplus,
> but did not find anything useful.
> It would be fine to see the state of the statement (e.g. PARSE, BIND,
> EXECUTE, FETCH) of a given session.
>
> I already sampled x$ksuse but I did not see anything useful there.
>
> Any hints how to address this question is appreciated,
>
> Martin
>
>

--
http://www.freelists.org/webpage/oracle-l