This content has been marked as final. Show 2 replies
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?
You can not estimate, in advance, the swap space required but you can write better queries, create sorted hash clusters, or use the right indexing, to minimize the number of sorts and the size of what is being sorted.
Without a version number, DML, and Explain Plans it is impossible to give anything other than very general advice ... but suffice it to say your basic assumption is incorrect.