Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> oracle docs do say # of extents effect performance

oracle docs do say # of extents effect performance

From: <>
Date: Fri, 20 Jun 2003 08:45:10 -0700
Message-ID: <>

I just read a .pdf by a couple of people at oracle called Stop Fragmenting and start living where it says not worry about the number of extents in a tablespace. However in the administrators doc it says the following:

Estimate Table Size and Set Storage Parameters Estimating the sizes of tables before creating them is useful for the following reasons:

You can use the combined estimated size of tables, along with estimates for indexes, rollback segments, and redo log files, to determine the amount of disk space that is required to hold an intended database. From these estimates, you can make correct hardware purchases and other decisions.

You can use the estimated size of an individual table to better manage the disk space that the table will use. When a table is created, you can set appropriate storage parameters and improve I/O performance of applications that use the table. For example, assume that you estimate the maximum size of a table before creating it. If you then set the storage parameters when you create the table, fewer extents will be allocated for the table's data segment, and all of the table's data will be stored in a relatively contiguous section of disk space. This decreases the time necessary for disk I/O operations involving this table.

this is at the following link:

am I reading this wrong or is Oracle stating that you should have less extents in a table? I know several people on here have posted that the number of extents used by an object is almost irrelevant.


Please see the official ORACLE-L FAQ:


Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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 Fri Jun 20 2003 - 10:45:10 CDT

Original text of this message