| Sort_Area_Size [message #64911] |
Mon, 01 March 2004 19:47  |
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  |
Frank Naude
Messages: 4595
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
