Re: Is an INACTIVE session executing a statement?

From: Kim Berg Hansen <>
Date: Wed, 19 Feb 2014 12:29:41 +0100
Message-ID: <>

Hi, Martin

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?


Kim Berg Hansen

On Wed, Feb 19, 2014 at 12:20 PM, Martin Berger <>wrote:

> Hi list,
> (I'm in _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

Received on Wed Feb 19 2014 - 12:29:41 CET

Original text of this message