DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ref:(Sorting)

  1. #1
    Join Date
    Jul 2002



    Default sort_area_size is 512 KB, if query sort needs more space like 10-15 MB then temp segment is used right.
    If I increase the sort_area_size to 15 MB for the session where the sort is being done then will temp segment be used?.

    Another one re-building ,creating index.

    The field I am going to create an index has around 1 million records, if I increase the sort_area_size to size of the field then will temp segment be used ?.

    Since we have enough physical memory, I would like to reduce temp segment usage in tem table space as much I can.

    If about points are correct then do I have to maintain sort_area_retain size equal to sort_are_size?.

    Please clear my questions.


  2. #2
    Join Date
    Sep 2000
    Chennai, India

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.