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

Report message to a moderator

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

Report message to a moderator

Previous Topic: mapping resolving
Next Topic: Circular relationships...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 14:01:21 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.