Re: What sql is using undo tablespace
From: Ls Cheng <exriscer_at_gmail.com>
Date: Tue, 13 May 2014 10:36:24 +0200
Message-ID: <CAJ2-Qb8Xx4v1Oc+Siw1S4T3=Nfj8+6+ndj3COieKSFy9RV2okw_at_mail.gmail.com>
v$transaction.USED_UBLK is probably what you are looking for, it doesnt tell you the sql but the session
Date: Tue, 13 May 2014 10:36:24 +0200
Message-ID: <CAJ2-Qb8Xx4v1Oc+Siw1S4T3=Nfj8+6+ndj3COieKSFy9RV2okw_at_mail.gmail.com>
v$transaction.USED_UBLK is probably what you are looking for, it doesnt tell you the sql but the session
thanks
On Tue, May 13, 2014 at 10:28 AM, John Dunn <JDunn_at_sefas.com> wrote:
> Is it possible to find out what sql statements are using up UNDO
> tablespace space?
>
>
>
> Oracle 10g Enterprise Edition
>
>
>
> *John *
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 13 2014 - 10:36:24 CEST