Home » RDBMS Server » Performance Tuning » Sort_Area_Size
Sort_Area_Size [message #64911] Mon, 01 March 2004 19:47 Go to next message
shesha
Messages: 24
Registered: August 2003
Junior Member
Hi,

I am new to Oracle DBA, recently I was asked a question about Sort_Area_Size.

Can you please tell me how this sort_area_size memory is assigned.

I was asked whether sort_area_size is assigned for entire instance or for a particular user?

If I have sort_area_size of 10M, whether this 10M is assigned to each individual user accessing the database or 10M is assigned for entire Instance?

Since this sort_area_size is assigned in PGA, I said each individual user gets 10M of memory space..but I feel this can't be possible as thousands of users will be accessing the DB.

Thanks

Sheshadri
Re: Sort_Area_Size [message #64919 is a reply to message #64911] Tue, 02 March 2004 03:23 Go to previous message
Frank Naude
Messages: 4566
Registered: April 1998
Senior Member
Hi,

Every user that is sorting will have SORT_AREA_SIZE of memory allocated. This is reduced to SORT_AREA_RETAINED_SIZE after the sort is completed, but before the rows are returned to the user.

BTW: If you are on 9i or above, you should be using PGA_AGGREGATE_TARGET instead of SORT_AREA_SIZE.

Best regards.

Frank
Previous Topic: How to trace Application Activity?
Next Topic: redo logs size ?
Goto Forum:
  


Current Time: Sun Jan 17 13:43:25 CST 2021