Re: Undo usage by service or schema

SQL> SELECT TO_CHAR(s.sid)||','||TO_CHAR(s.serial#) sid_serial,

  2         NVL(s.username, 'None') orauser,
  3         s.program,
  4         r.name undoseg,
  5         t.used_ublk * TO_NUMBER(x.value)/1024||'K' "Undo"
  6    FROM sys.v_$rollname    r,
  7         sys.v_$session     s,
  8         sys.v_$transaction t,
  9         sys.v_$parameter   x
 10   WHERE s.taddr = t.addr
 11     AND r.usn   = t.xidusn(+)
 12     AND x.name  = 'db_block_size'

Thanks
Nilesh Soni

On Wed, Jul 14, 2010 at 1:13 PM, Restomi_w <restomi_w_at_yahoo.com> wrote:

> Hi,
>
> Is it possible to get statistics about undo usage per db service or schema?
>
> The idea is to get picture of undo generation per apps/schema sharing the
> same database.
>
> Dba_hist_service_stat contains no such info.
>
> Considering resource manager could limit undo space used by consumer group,
> there should be some way to get this info. Thanks.
>
> Regards,
> Tomi
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l