Undo Tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Undo Tablespace

  1. #1
    Join Date
    May 2002
    Posts
    163

    Undo Tablespace

    Hi Friends

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

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Sep 2000
    Location
    Calcutta / Ahmedabad, India
    Posts
    137
    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
    Suvashish

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width