Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sort tablespace usage
On Sun, 17 Jun 2001 13:34:18 GMT,
SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK (Brian Tkatch)
wrote:
This sounds like what they were talking about. Question is how is it implemented?
>On Sat, 16 Jun 2001 16:41:05 GMT, willjamu_at_mindspring.com (James
>Williams) wrote:
>
>>I have always thought the only space a user has for order by, group,
>>etc was from his temp tablespace from the create user. Another tells
>>me you can have a specail temp tablespace for sort usage only. Is his
>>true? I have not seen such even though its apealing. 8.1.6.3
>
><URL:http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76965/c02block.htm#2528>
>
>"Extents in Temporary Segments"
>
>A single sort allocates its own temporary segment, in the temporary
>tablespace of the user issuing the statement, and then returns the
>extents to the tablespace.
>
>Multiple sorts, however, can use sort segments in a temporary
>tablespace designated exclusively for sorts. These sort segments are
>allocated only once for the instance, and they are not returned after
>the sort but remain available for other multiple sorts.
>
>HTH,
>Brian
Received on Sun Jun 17 2001 - 10:48:50 CDT