Skip to Content
avatar image
Former Member

table space is showing full

Dear Experts ,

please clarefy me on tablespace

here in my server tablespace is showing 100% full and the status is in Auto turn off mode

can i increase this tablespace or no need to increase

table name size Free used Auto Ext Total Size total free size total used files segments extends status contents

PSAPUNDO 10,000.00 32.00 100 NO 10,000.00 32.00 100 1 28 3,072 ONLINE UNDO

PSAPUNDO --- what hapens if it is not increased

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 18, 2011 at 04:36 PM

    PSAPUNDO is the Oracle tablespace for "UNDO" management

    Read,

    Note 1035137 - Oracle Database 10g: Automatic Undo Retention

    Also as reference read, Note 600141 - Oracle9i: Automatic UNDO Management

    Regards

    Juan

    Add comment
    10|10000 characters needed characters exceeded