tag:blogger.com,1999:blog-1113949853993421596.post6567379472452001361..comments2024-02-13T16:22:47.962+05:30Comments on Ingress IT Solutions: Tuning Sort Area SizeAnonymoushttp://www.blogger.com/profile/16195763811758156489noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-1113949853993421596.post-70586584368781742382008-10-30T17:32:00.000+05:302008-10-30T17:32:00.000+05:30PGA_AGGREGATE_TARGET=AUTO is the default now, howe...PGA_AGGREGATE_TARGET=AUTO is the default now, however it can be usefull to manually set the sort area size at a session level for batch processing (where a really big sort area may help), although you then have to make sure you have enough memory for your normal pga plus the additional sort areas.chris_cnoreply@blogger.comtag:blogger.com,1999:blog-1113949853993421596.post-40225347682257859202008-10-30T17:24:00.000+05:302008-10-30T17:24:00.000+05:30I do know that in at least oracle 9i, setting sort...I do know that in at least oracle 9i, setting sort_area_size will negate the use of PGA_AGGREGATE_TARGET , which would be the preferable method of auto-tuning sort_area_sizeBradd Piontekhttp://www.blogger.com/profile/09812125551238871609noreply@blogger.comtag:blogger.com,1999:blog-1113949853993421596.post-30813706890687367042008-10-30T15:40:00.000+05:302008-10-30T15:40:00.000+05:30Isn't this tip version specific and dependent ...Isn't this tip version specific and dependent on the setting of WORK_AREA_SIZE_POLICY=MANUAL?<br><br>Regards,mathewbutlerhttp://www.blogger.com/profile/04733010552235144796noreply@blogger.com