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

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

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
Messages: 79
Registered: December 2000
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
and sort_write_buffers
Previous Topic: mapping resolving
Next Topic: Circular relationships...
Goto Forum:

Current Time: Sun Jun 25 22:48:42 CDT 2017

Total time taken to generate the page: 0.07912 seconds