Re: CREATE ROLLBACK SEGMENT

In our last gripping episode diegolosi_at_my-deja.com wrote:
> I am using Oracle Version 8.1.5 on an NT server
> I have this problem:
> I want to create a rollback segment,
>
> create public rollback segment RB2
> tablespace RBS
> storage (
> initial 10 K next 10 K optimal 300 K
> minextents 20 maxextents 450);
>
> ORA-01593: rollback segment optimal size (38 blks) is smaller than the
> computed initial size (80 blks)
>
> The db_block_size is 8192. Is the initial size of the rollback segment
> 200K?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

It depends upon the PCTINCREASE parameter of the RBS tablespace. If the PCTINCREASE is set to 0 (which it should be) then the initial size of the rollback segment would be 200K. However that is not the case since ORACLE is calculating that 20 extents will consume 80 8K blocks or 640K. I would think that your PCTINCREASE is set at the default for the tablespace, which is 50. Alter the PCTINCREASE value for the RBS tablespace:

ALTER TABLESPACE RBS
DEFAULT STORAGE(PCTINCREASE 0); and then create your rollback segment.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.