Re: What sql is using undo tablespace

From: Ls Cheng <exriscer@xxxxxxxxx>
To: JDunn@xxxxxxxxx
Date: Tue, 13 May 2014 10:36:24 +0200

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@xxxxxxxxx> wrote:

>  Is it possible to find out what sql statements are using up UNDO
> tablespace space?
>
>
>
> Oracle 10g Enterprise Edition
>
>
>
> *John *
>
>
>

Follow-Ups:
- Re: What sql is using undo tablespace
  - From: sumit Tyagi

References:
- What sql is using undo tablespace
  - From: John Dunn

Other related posts:

» What sql is using undo tablespace- John Dunn
» Re: What sql is using undo tablespace - Ls Cheng
» Re: What sql is using undo tablespace- sumit Tyagi
» Re: What sql is using undo tablespace- Adam Musch
» RE: What sql is using undo tablespace- Jonathan Lewis
» Re: What sql is using undo tablespace- Justin Mungal
» RE: What sql is using undo tablespace- Jonathan Lewis
» Re: What sql is using undo tablespace- Yong Huang