| 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: extent management
Hermanto,
Recreate the table with larger initial and next extent size. Try not to have too many small extents since it becomes unmanageable but rather have fewer larger extents. I try not to have more than 30 or 40 extents.
Performance is not much of a problem with multiple extents but make sure
your
extent sizes are multiples of multi block read size.
See Steve Adams tip on planning extents. http://www.ixora.com.au/tips/creation/extents.htm
Suhen
Hi gurus,
I have a problem with the table extent.
Actually, the table extent growth too fast.
Maybe I set the extent configuration wrong.
So, I have to adjust the next extent almost every two months.
Now the maxextents value already reach 80 (oracle 7.3).
Is there anyone knows about how I should manage the extent of table ?
What I have to do if I have reach 121 maxextents value ?
Thanks before for your kind advise.
Warm Regards,
Hermanto P
Application Engineer
PT Riau Andalan Pulp And Paper - IT/IS Dept.
Phone : (0761) - 95529 Ext. 1147 - 1266
HP : 0812-752-3092
"Our greatest glory is not in never falling but in rising every time we
fall"
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hermanto P
INET: hermanto_p_at_aprilasia.com
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 Wed Jul 11 2001 - 21:24:53 CDT
 |
 |