969224 wrote:That information would be useless because you do not know at any given time what will be executing and also using the temp tablespace.
Hello Guys, . . . E t c . . .
. . . any help to determine how much storage the query needs to do the sorting in the temporary tablespace?
Wrong. It only uses temp if it is unable to perform the sort in memory.
when ever a sql is executed it uses the temporary tablespace storage to do the sorting right?