--SYSSMU12$ is space-critical object in db02

[Former Member]

  Dear Experts,

  In db02->space->segment->critical objects, we get below entries:

Owner	Name	Partition	Type	Tablespace	Size(MB)	Next Extent(MB)	Max Free(MB)	Alert Type
SYS	_SYSSMU12$		TYPE2 UNDO	PSAPUNDO	1,423.125	64.000	16.00	1.00
SYS	_SYSSMU13$		TYPE2 UNDO	PSAPUNDO	1,357.125	64.000	16.00	1.00

  Please suggest what should we do in this situation

[former_member189725 · Accepted solution]

This seems that you have to add space in PSAPUNDO tablespace , since space critical undo objects exists in the undo tablespace . Add datafiles to the undo tablespace , so that such space critical objects do not show up.

Regards

Ratnajit

[Former Member · Accepted solution]

   Dear Ratnajit,

   These same objects also reflecting in TOP GROWTH objects of database. It means they are consuming space.  What these objects contain. Can we delete ?

[former_member189725 · Accepted solution]

what is the size of the database ?

These are undo segments which are re-used by oracle transactions. The segments are 1.4 GB and 1.3 GB which is fine . So suggest you to add datafiles to PSAPUNDO tablespace.

Or if you do not want to have these segments then do the following.

Stop the database and start again

Create a new undo tablespace say PSAPUNDO1

set the UNDO_TABLESPACE to this new tablespace .

Drop the PSAPUNDO tablespace.

create again PSAPUNDO tablespace .

Restart the database

set the UNDO_TABLESPACE to PSAPUNDO

drop PSAPUNDO1 tablespace.

Refer to link http://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm

Regards

Ratnajit

[Former Member · Accepted solution]

    Hi,

  Problem resolved, SAP NOTE: 600141,828268,1035137

[former_member189725 · Accepted solution]

What did you do actually ?

Did you drop and recreate the undo tablespac ?

Regards

Ratnajit

[Former Member · Accepted solution]

  No drop & recreation...

From oracle 9i, there is automatic undo mgmt concept  in oracle, so there is no need to drop & recreate provided undo parametrs are set in system as per SAP notes.

In our case, space reduced itself next day, because we have already set parametrs accordingly.