SORT_AREA_SIZE SET UP

[oracle8]

Hi!

Any ideas on how to size the SORT_AREA_SIZE, i have more than 100 users connected to the database whick is 8.05 in win2003.

thanks,

Rommel

 

[sem]

It mainly depends on your business tasks rather than on number of users. Do you encounter "sort area size too small"?

Regards, Dima

http://seminihin.narod.ru

 

[oracle8]

Dima,

No, i have not encounter such message what i need is, is there a standard value in setting up the SORT_AREA_SIZE.

thanks,

Rommel