Yes, it means it is now fully allocated by Oracle and will be used when required by sessions. rjamya On 6/13/07, genegurevich@xxxxxxxxxxxxxxxxxxxxx < genegurevich@xxxxxxxxxxxxxxxxxxxxx> wrote:
Let me rephrase it then... If the TEMP TS is shown as 100% used in the temp_space_header table it does not necessarily mean that it is full because the existing segments can be reused by other processes.