-
I understand that temp tablespaces are used for large queries, sorting, etc. Once statement is executed or an error occurs the tablespace should free itself.
Does it mean that I'll see different proportions free/used space in my temp tablespace all the time since it is for changing and dynamic or once it reaches its highest point it thinks it is that much full regardless whether it is participating in performing any operations or not.
I personally believe it is the second option but don't understand why.
Thank you.
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
|