Home » Developer & Programmer » Designer » Range Value for SORT AREA Parameter in 9i
Range Value for SORT AREA Parameter in 9i [message #90420] Fri, 25 July 2003 03:52 Go to next message
Sri Sai Krishna
Messages: 2
Registered: July 2003
Junior Member
Hi,

Could anyone tell me what are the minimum and maximum values that can be set for the following parameters in Oracle 9i.

1. sort_area_size
2. sort_area_retained_size
3. sort_write_buffer_size
4. sort_write_buffers

Thanks
Sri Sai
Re: Range Value for SORT AREA Parameter in 9i [message #90446 is a reply to message #90420] Thu, 25 September 2003 13:55 Go to previous message
Manish
Messages: 79
Registered: December 2000
Member
sort_area_size 6 oracle blocks to os dependant
sort_area_retained_size 2 oracle blocks to sort_area_size

there are no parameters called
sort_write_buffer_size
and sort_write_buffers
Previous Topic: mapping resolving
Next Topic: Circular relationships...
Goto Forum:
  


Current Time: Fri Mar 29 05:10:02 CDT 2024