Undo Tablespace

[newcomer]

Hi Friends

Can I create a undo tablespace using Localy managed tablepsace feature?

[SANJAY_G]

The UNDO tablespace must be Locally Managed and the extent allocation must be SYSTEM. If you will try to create as dictionary managed or UNIFORM extent size an error will be returned.

HTH

[dsuva]

Hi Sanjay,

I have created a Locally managed tablespace. i.e.

CREATE TABLESPACE RBS
DATAFILE '/gjdb04/PRODBSCS/oradata/rbs/rbs_1.dbf' SIZE 1920M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M;

and then created the Rollback Segment on this tablespace. i.e.

CREATE PUBLIC ROLLBACK SEGMENT R01 TABLESPACE RBS STORAGE (MAXEXTENTS UNLIMITED OPTIMAL 40M);

We have a highly OLTP environment, do u think using Rollbacks this way can cause performance degradation. I am actually having performance degradation on my database. although the Waits shown in the STATSPACK report show Data Block contention, do u think the Rollbacks could have a role to play in this.

Thanks