OraFAQ Forum: Performance Tuning » WORK_AREA_SIZE

Home » RDBMS Server » Performance Tuning » WORK_AREA_SIZE_POLICY = manual

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

WORK_AREA_SIZE_POLICY = manual [message #237143]

Sat, 12 May 2007 12:16

balaji1010
Messages: 35
Registered: March 2006
Location: London

Member

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.

Report message to a moderator

Re: WORK_AREA_SIZE_POLICY = manual [message #237164 is a reply to message #237143]

Sat, 12 May 2007 15:30

sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM

Member

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.

Thanks

Report message to a moderator

Re: WORK_AREA_SIZE_POLICY = manual [message #242620 is a reply to message #237143]

Mon, 04 June 2007 06:23

parthokonar
Messages: 17
Registered: September 2006
Location: india

Junior Member

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/memory.htm#49321
http://www.jaredstill.com/content/pga-target.html

see the above sites it will give details

Report message to a moderator

Previous Topic:	Performance issues with dbms_job
Next Topic:	Please guide how to tune the given query (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 00:16:16 CST 2025