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

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.


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: 4578
Registered: April 1998
Senior Member

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.

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

Current Time: Sat Feb 24 21:23:29 CST 2024