Re: Rollback segment is always full

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: Tue, 25 Aug 1998 09:08:09 -0400
Message-ID: <6ruct4$6df$1@client3.news.psi.net>

Hi Cemal,

Unless you specified OPTIMAL your rollback segments will not shrink. This is okay and unrelated to your performance problems.

When you created your new rollback segments did you modify your init<sid>.ora file to set the new rollback segments online when the database is started? If not they won't be used unless you manually alter them online.

I suggest that you obtain a copy of Corrigan and Gurry's book, Oracle Performance Tuning, published by O'Reilly and Associates.

regards

Jerry

cdoganay_at_my-dejanews.com wrote in message <6rs821$87a$1_at_nnrp1.dejanews.com>...
>Hi, I had a seriuos performance problems and noticed that one of the
rollback
>segments (there were 2) was always full(121). Even I shutdown and startup
the
>system, it is always 121. Then, I created new 2 rollback segments in
diffrenet
>tablspace. But , they seemed unused and the first rollback seg is overused.
>Whta was wrong with my current configuration?
>
>We have just one third party application running and they created their own
>tablespace and rollback segment (Just 1)
>
>Any help will be appreciated
>
>Cemal Doganay
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Aug 25 1998 - 08:08:09 CDT