Re: rollback segment problem

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: Sat, 13 Feb 1999 16:54:47 +0100
Message-ID: <7a47bs$ft3$1@news.worldonline.nl>

Hello Suresh,
Try:
sql> alter rollback segment R01 shrink ;

etc.

---

Roelof Schierbeek, DBA
Bytelife BV
The Hague, Holland
email: bytelife AT worldonline.nl
check out : http://home.worldonline.nl/~bytelife

sureshna_at_my-dejanews.com heeft geschreven in bericht <7a0sgq$nlq$1_at_nnrp1.dejanews.com>...
>Hi All,
>I have setting for the rollback segment as inital 10k next 50k optimum
100k.
>As per Oracle manual if you set optimum setting after the transactions are
>commited, the rollback segment size will go back near 100k mark. but in my
>case it stays at for example 90MB. I have to personaly drop the rollback
and
>recreate to reclaim the space.
>
>Can you anyone help me how to set the optimum parameter to work well
>
>thanks
>
>Suresh.N
>
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat Feb 13 1999 - 09:54:47 CST