Home » RDBMS Server » Server Utilities » Range Values for Sort Area Parameters in Oracle 9i
Range Values for Sort Area Parameters in Oracle 9i [message #72586] Fri, 25 July 2003 04:06 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 Values for Sort Area Parameters in Oracle 9i [message #72587 is a reply to message #72586] Fri, 25 July 2003 22:47 Go to previous message
James
Messages: 120
Registered: June 2000
Senior Member
1) 6 x DB_BLK_SIZE to OS limit
2) 2 x DB_BLK_SIZE to 1)
3) NO
40 NO

Report message to a moderator

Previous Topic: Suppressing username/password while using sqlldr
Next Topic: TNS & LISTENER
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 13:49:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.