Ask the Expert

Calculating the initial extents

How do I calculate the initial extents when creating a table? For example: I have a table Transacorders:
 c1     number 10
 c2     varchar2 25
 c3     date
I think that per day, I will have 3000-4000 records inserted and as many updates. How do we calculate the initial extents? My db_block_size is 4K.

    Requires Free Membership to View

An easy way to do the calculation is to take the daily number of records (4,000 records), multiply times the max row length (2+25+7=34 bytes) and then multiply by the number of days you want to be in the first extent (say 6 months which is approximately 180 days). Then under these calculations, your initial extent needs to be 4000*34*180 = 24,480,000 bytes or 5,997 blocks (with your 4K block size).

But I have to tell you that most Oracle DBAs don't go through these type of calculations anymore. The Locally Managed Tablespace (LMT) was introduced in Oracle 8i. If you use AUTOALLOCATE for your LMT, then the INITIAL extent is typically 64K. If you use UNIFORM sizing for your LMT, then your INITIAL extent can be pretty much anything.

For More Information

This was first published in January 2003

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: