Re: Is an INACTIVE session executing a statement?

  • From: Kim Berg Hansen <kibeha@xxxxxxxxx>
  • To: martin.a.berger@xxxxxxxxx
  • Date: Wed, 19 Feb 2014 12:42:31 +0100

Aha!  Look at v$session.SQL_ID

At least in my test it was populated as long as the session is fetching and
null when it is done and truly idle.



Regards


Kim Berg Hansen

http://dspsd.blogspot.com
kibeha@xxxxxxxxx
@kibeha



On Wed, Feb 19, 2014 at 12:38 PM, Kim Berg Hansen <kibeha@xxxxxxxxx> wrote:

> Nope, sorry - it does not seem to be the wait event.
> No idea, then ;-)
>
>
>
>
> Regards
>
>
> Kim Berg Hansen
>
> http://dspsd.blogspot.com
> kibeha@xxxxxxxxx
> @kibeha
>
>

Other related posts: