-
could some one tell the concept Oracle uses in sorting ...using temporary segments, iit is said that the same temporary segment will be used by all users for sorting ,, will each user get a different extent for his sort and is the temporary segment allocated tablespace wise or it is one for an instance ??
could also the SORT_AREA_SIZE and SORT_AREA_RETAINED SIZE be clarified ???
regards,
sharmila
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|