Re: determining extent sizes

chuckh_at_ix.netcom.com (Chuck Hamilton) wrote:

>I'm curious as to what other DBAs do when creating new tables. Is it
>better to:
 

>1) estimate actual table sizes and create the initial extent to be
>that size,

It is best to create your initial extent large enough to hold all current data, and allow for some growth as well.

There is excellent information in the Admin Guide, chapter 8.

Also, check out the 'Oracle DBA Handbook" from the Oracle Press as well as "Oracle Performance Tuning" from O'Reilly.

>or
 

>2) make all extents the same size so it's easier for the RDBMS to
>reuse free'd up extents?

The only way a table will free up extents is to drop it.

>--
>Chuck Hamilton
>chuckh_at_ix.netcom.com
 

>Never share a foxhole with anyone braver than yourself!

Jared Still, Oracle DBA
RxNet, Division of Value Health
"All opinions are mine, not my employers" jared_at_valleynet.com Received on Wed Jan 24 1996 - 00:00:00 CET