| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Extents size.
Thanh - I believe the 128k / 4m / 128m comes from the paper "Stop defragmenting and start living" (I hope I am recalling the name of the article correctly), which is posted on Oracle's Web site. It references the fact that it bases those sizes on Oracle8i, and mentions that Oracle is recommending the 160k / 4m / 160m for Oracle9i.
Anyway, I would advise you to locate that paper and read it carefully before laying out your new reorganization. Better to clear up any misconceptions now. I don't think the exact sizes you pick are as important as understanding and following the philosopy.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Monday, October 01, 2001 5:35 PM
To: Multiple recipients of list ORACLE-L
Hello,
I'll do an reorganization of a database (about 140 gigs). Some people say that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be 160K, 4M and 160M. Which size do you advice me ? I have also many small indexes (less than 16K).
Regards,
Thanh-truc Nguyen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thanh-truc Nguyen
INET: truc_at_nguyen.as
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Oct 01 2001 - 17:18:53 CDT
 |
 |