Sort_Area_Size

[nkumarin001]

Hi,

I am using pfile and i changed the value of Sort_Area_Size from 524288 to 1073741824(1GB) but when i started the database and checked the value of Sort_Area_Size it was showing 524288.

Please help me in this one to change the value of Sort_Area_Size from 524288 to 1073741824(1GB) and tell me why i was getting 524288 instead of 1073741824(1GB) .


Regards,
Naveen

[nabh4u]

Hi,

I am using pfile and i changed the value of Sort_Area_Size from 524288 to 1073741824(1GB) but when i started the database and checked the value of Sort_Area_Size it was showing 524288.

Please help me in this one to change the value of Sort_Area_Size from 524288 to 1073741824(1GB) and tell me why i was getting 524288 instead of 1073741824(1GB) .


Regards,
Naveen

everytime you change something in the pfile you have to restart and reconnect to the database, otherwise the changes are not reflected. once you change some parameter in pfile, save it and exit from the developer. and start up everything again. this time the changes are supposed to be taken place. If not then there might be some other probelm.
first try doing the above idea.

[gintsp]

Hi,

I am using pfile and i changed the value of Sort_Area_Size from 524288 to 1073741824(1GB) but when i started the database and checked the value of Sort_Area_Size it was showing 524288.

Please help me in this one to change the value of Sort_Area_Size from 524288 to 1073741824(1GB) and tell me why i was getting 524288 instead of 1073741824(1GB) .


Regards,
Naveen

What version you have?
Increasing sort_area_size for all instance can make quite big (not always good :) impact because sort_area_size is allocated for each session and if you have many sessions you can easily reach the limits.
So why don't you use pga_aggregate_t arget?

If you really want to change the parameter for all instance and make the modification peremanent then you should use alter blabla scope=both. See more here
(look for scope keyword and possibilities memory/spfile/both)

Gints Plivna