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

Thread: ref:(Sorting)

  1. #1
    Join Date
    Jul 2002
    Posts
    29

    ref:(Sorting)

    Hi,

    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.


    Thanks,

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

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