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.