Re: shrinking rollback segments

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 16 Jul 2002 19:49:21 +0200
Message-ID: <n1n8ju0vqn85ugrhhfncn8m2r5d2o6o7ef@4ax.com>

On Tue, 16 Jul 2002 19:00:57 +0200, "Johannes" <johannes_at_merckle.de> wrote:

>Hello all,
>
>I have 60 rollback segments set with storage option 'optimal NULL'.
>Now I wonder myself why getting in v$rollstat much entries for the column
>'shrinks' for each rollback segment.
>Shoulnd't they stay extented until i explicitly say: alter rollback segment
>shrink ?
>I restarted the DB, so there can't be any data from before. Or is it a bug
>like $GB? :-)
>
>Thanx for your help
>Johannes
>
>

Yeah sure, everything that doesn't work is automatically a bug. Why on earth BTW do you have 60 rollback segments. And implementing optimal was not one of Oracle's brightest moments: stay away from it, you are increasing the possibility of hitting ora-1555 snapshot too old.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jul 16 2002 - 12:49:21 CDT