Home » RDBMS Server » Performance Tuning » WORK_AREA_SIZE_POLICY = manual
WORK_AREA_SIZE_POLICY = manual [message #237143] Sat, 12 May 2007 12:16 Go to next message
Messages: 35
Registered: March 2006
Location: London

Hi everyone,

I intend to know if a user is connecting through dedicated server and WORK_AREA_SIZE_POLICY is set to MANUAl the SORT_AREA_SIZE parameter would be in effect.

What if user is performing a sort worth 100M and SORT_AREA_SIZE is 100M and simultaneously other user wants to perform a sort, would the sorting be done in temporary tablespace or in the memory.

Can anyone clarify please

Thanx in advance.
Re: WORK_AREA_SIZE_POLICY = manual [message #237164 is a reply to message #237143] Sat, 12 May 2007 15:30 Go to previous messageGo to next message
Messages: 48
Registered: February 2007
Sort area size is session specific , so this would again happen in the memory , so sizing the sort area size should be done carefully , but automatic pga management will take this burden off from us.

Re: WORK_AREA_SIZE_POLICY = manual [message #242620 is a reply to message #237143] Mon, 04 June 2007 06:23 Go to previous message
Messages: 17
Registered: September 2006
Location: india
Junior Member

see the above sites it will give details
Previous Topic: Performance issues with dbms_job
Next Topic: Please guide how to tune the given query (merged)
Goto Forum:

Current Time: Thu Oct 27 21:53:23 CDT 2016

Total time taken to generate the page: 0.09546 seconds