-
Locally Managed TEMP tablespace
Oracle 817 (64-bit) on Solaris8.
We have created a locally managed temporay tablespace using TEMPFILE option of the size 2GB. It seems to be atlest 95% utilized all the time and SMON not seems to be cleaning up.
As you know on temporary tablespaces, we can not run ALTER TABLESPACE TEMP coalesce.
What could be the reason why SMON is not cleaning up/coalescing periodically? Is there any setting or command that I use to see that the TEMP tablespace is coalesced and freed up?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|