Re: Increase FREEIST w/o drop objects--sorry for the previous garbage code
From: SJHussain@xxxxxxxxxxxxxxx
To: zhuchao@xxxxxxxxx
Date: Sat, 2 Oct 2004 12:39:25 +0300
Do wee still need to worry about the freelist setting when using 9i rel.2
feature called Automatic Segment Management?
- - -
Best Regards,
Syed Jaffar Hussain
OCP 8i DBA
zhu chao
<zhuchao@xxxxxxxx
m> To
Sent by: chzhu@xxxxxxxx
oracle-l-bounce@f cc
reelists.org sinardyxing@xxxxxxxxxxxxx,
oracle-l@xxxxxxxxxxxxx
Subject
10/02/2004 12:34 Re: Increase FREEIST w/o drop
PM objects--sorry for the previous
garbage code
Please respond to
zhuchao@xxxxxxxxx
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
Visit us on www.alfransi.com.sa
====== Banque Saudi Fransi - Privacy Notice ======
This message is intended only for the person or entity to which it is
addressed and may contain confidential and/or privileged material. Any
use of this information by persons or entities other than the intended
recipient is prohibited. If you have received this in error, please
contact the sender and delete the material from your computer. Any
opinions and other information contained in this message that do not
relate to the official business of Banque Saudi Fransi shall be
understood as neither given or endorsed by it. Although precautions
have been taken to ensure no viruses are present in this email, BSF
cannot accept responsibility for any loss or damage arising from the
use of this email or attachments.
====== Banque Saudi Fransi - Privacy Notice ======
--
http://www.freelists.org/webpage/oracle-l
