Re: fast growing RBSs

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 12 Sep 1999 08:33:23 +0100
Message-ID: <937122087.9203.0.nnrp-01.9e984b29@news.demon.co.uk>

Check my website. 'OLD V$'

V$transaction (which can be tracked back to v$session) through the TADDR column on v$session and the addr on v$transaction) has a couple of column used_ublk, used_urec. This is the number of blocks and records used by the current transaction.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Martin Trzaskalik wrote in message <37DADE01.DBF7B175_at_element-5.de>...
>I am having problems with fast growing roll back segments...
>
>The RBSs are currently allocating more and more space. More than I
>think is necessarcy.
>
>I guess this is caused by one of our applications.
>
>How can I track down which application or what ever causes this
>fast growing usage of RBS space?
>
>Can I find out which session caused how much allocation of
>RBS space since its beginning?
>
>I am running Oracle 8.
>
>Regards,
>
>Martin
Received on Sun Sep 12 1999 - 02:33:23 CDT