The rollback segment below is probably not full. The majority of the
allocated extents are probably not in use, but once allocated to an object
extents remain part of the object until the object is dropped and
re-created. There are commands to release unused extents, but they are not
automatic.
- assign an optimal value to all the rbs segments; see alter rollback
segment
- try issuing 'alter rollback segment_name shrink'
- allocate at least 4 rollback segments to all databases
cdoganay_at_my-dejanews.com wrote in article
<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:05 CDT
