cancel
Showing results for 
Search instead for 
Did you mean: 

Free tablespace PSAPTEMP

Former Member
0 Kudos

Hi,

Within PI we are using a file adapter to read a lot of documents and transfer those to a SAP system. During the reading of those documents the tablespace PSAPTEMP increases significantly. But to free the space afterwards takes a long time. Is there an easy way to clean tablespace PSAPTEMP quickly?

Kind regards

Maarten

Accepted Solutions (0)

Answers (2)

Answers (2)

stefan_koehler
Active Contributor
0 Kudos

Hello Marteen,

well this works as designed.

Metalinknote #61997.1 or official documentation (http://docs.oracle.com/cd/B19306_01/server.102/b14231/tspaces.htm#i1013552)

SMON actually de-allocates the sort segment after the instance has been started and the database has been opened.

Thus, after the database has been opened, SMON may be seen to consume large amounts of CPU as it first de-allocates the (extents from the) temporary segment, and then when it is  requested to perform free space coalescing of the free extents created by the temporary segment cleanup.

If you want to "free" the space immediately - just create a new temporary tablespace and assign this one as the default temporary tablespace.

Regards

Stefan

Former Member
0 Kudos

Hi Stefan,

It worked. Thnx for your answer.

kind regards,

Maarten

former_member182034
Active Contributor
0 Kudos

hi Marteen,

TEMP segments are not being released, so you can help from following SAP Note and Link

PSAPTEMP does not release TEMP segments

659946 – FAQ: Temporary tablespaces)

Regards,