Re: Is an INACTIVE session executing a statement?
From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Wed, 19 Feb 2014 22:05:15 +0100
Message-ID: <53051C8B.6010205_at_gmail.com>
Hi,
I'm quite sure I've seen an inactive session with not null sql_id in v$session.
I believe those had active transactions (before commit/rollback was issued).
Date: Wed, 19 Feb 2014 22:05:15 +0100
Message-ID: <53051C8B.6010205_at_gmail.com>
Hi,
I'm quite sure I've seen an inactive session with not null sql_id in v$session.
I believe those had active transactions (before commit/rollback was issued).
Regards
Dimitre
Il 19/02/2014 19.01, Martin Berger ha scritto:
> after some testing with Kim Berg Hansen I can only say I'm having a
> strange observation:
> in my env v$session keeps (sometimes) SQL_ID even the statement is
> closed.
> We compared v$session view for 11.2.0.4 and 12.1 but there is no
> substantial difference there.
> Even Kim could not reproduce the problem, he always saw the SQL_ID
> disappear after the statement completed.
>
> Maybe I'm hunting a different problem; at the moment I can not give
> more details to hunt down my observations.
> Martin
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 19 2014 - 22:05:15 CET