Printable View
I would like to find another way of cleaning up a localy managed temporary tablespace, without having to shut the instance down or creating a second localy managed temporary tablespace and changing the users temporary_tablespace location to the new temp, and then taking the tempfiles offline. This seems to result in 0 bite files when places back online. There must be a way of repairing the bitmap associated with the tempfile as the is with localy managed datafiles.
Why do you feel there is a need to "cleanup" your temporary storage? Temporary storage will be reused by other operations.
See http://technet.oracle.com/docs/produ...block.htm#2930 for details.
My users mantain long sessions and the space is only returned after the session has ended. I know previous sort operations will not be reused. I have not set autoextend on my temp storage and would like to dealocate those used sort segments.
I occasionaly get an error message that a sort opperation cannot extend my temporary storage. Even when the users are only using a few meg's of space.
Although Oracle states that the segments are returned, it seems as if they are not. The only time I see the segments returned are after I have shutdown the instance.
IMHO, if you are running out of TEMP space, you don't have enough configured for your user load.