|
[oracle-l]
||
[Date Prev]
[10-2004 Date Index]
[Date Next]
||
[Thread Prev]
[10-2004 Thread Index]
[Thread Next]
Re: Increase FREEIST w/o drop objects--sorry for the previous garbage code
- From: zhu chao <zhuchao@xxxxxxxxx>
- To: chzhu@xxxxxxxx
- Date: Sat, 2 Oct 2004 17:34:44 +0800
hi,
To increase the freelists on an object, you must be 8.1.6+. and to
modify the freelist groups (at least 9i), you need to recreate the
object.
Some old rules get changed while oracle continue to change.
By the way, one of our senior dba said, the freelists needs to be
prime " Freelists needs to be a prime number. If you cannot use 23,
use 17", I don't know why. Anyone have experience?
Regards
--
Regards
Zhu Chao
www.cnoug.org
--
http://www.freelists.org/webpage/oracle-l
|
|
