-
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,
-
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
|