PSAPTEMP tablespace Full

[Former Member]

Hi All,

We have Oracle 9i DB around 90GB, when monitored through BRTools, found that PSAPTEMP is showing 100% utilization. We tried shutting down the DB (shutdown normal/immediate) as well as the whole SAP system & restarted again but it did'nt help..Another option I think is creating new Temp TBS making that as default tbs & making this PSAPTEMP offline...but have not implemented that as not sure if we can do nything with PSAPTEMP TBS.

Other thing that we did is added new datafile to the PSAPTEMP TBS but did'nt help.

Please suggest .

Thanks & Regards

Rupali S

[Former Member]

SAP uses the tablespace PSAPTEMP to hold temp segments.

The ALTER TABLESPACE statement takes datafiles offline as well as the tablespace, but it cannot be used to alter the status of a temporary tablespace or its tempfile

If the TEMPORARY TABLESPACE is of type TEMPORARY, the space is not released until the instance is shutdown. If the TEMPORARY TABLESPACE is of type PERMANENT, then cleanup is performed by SMON after completion of the process using it.

Try to find out whay it is becoming full u can add files if it is not working

You can create one more temp TS make it default and drop the Old one

Use BR Tools

vinod

[Former Member]

Hi,

You should first create two new temp datafiles of at least 512 MB each and delete old one.

U can also resize your tablespace and make it autoextend on

Regards