Re: fast growing RBSs

Martin:

I'm away from work, so I don't have my scripts handy, but I know you can query V$ROLLSTAT to find various statistics about RBSs. There's some view, perhaps not that one, that tells which sessions have current rollback transactions. If you can't find it and really need it, e-mail me.

Have you set OPTIMAL in the storage parameters? If not, I recommend it. You should monitor the high-water-mark periodically to make sure your OPTIMAL isn't too small.

I had a problem with growing RBSs. I found that the middle tier of our three-tier client-server setup would open sessions and never close them. RBSs associated with these sessions would never shrink back to OPTIMAL. I reconfigured the middle tier to periodically close and re-open sessions, and the problem went away.

Good luck.

Joseph

In article <37DADE01.DBF7B175_at_element-5.de>,   Martin Trzaskalik <martin_at_element-5.de> wrote:
> 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
>

--
Joseph Thvedt
jthvedt_at_my-deja.com

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sun Sep 12 1999 - 00:22:10 CDT