on 03-29-2012 10:27 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.