Rollback segment is always full

From: <cdoganay_at_my-dejanews.com>
Date: Mon, 24 Aug 1998 17:31:44 GMT
Message-ID: <6rs821$87a$1@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 Mon Aug 24 1998 - 12:31:44 CDT