Can I create a undo tablespace using Localy managed tablepsace feature?
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.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
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.
Click Here to Expand Forum to Full Width