table space is showing full

[Former Member]

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

[JPReyes · Accepted solution]

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