determining extent sizes

From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1996/01/17
Message-ID: <4djqml$l7n_at_cloner2.ix.netcom.com>#1/1

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

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

or

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

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!

Received on Wed Jan 17 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Vikram Goel: "Re: scheduling an operation for a later time usin sql or .."
Previous message: Doug Traxler: "(no subject)"
Next in thread: Jared Still: "Re: determining extent sizes"
Reply: Michael Abbey: "Re: determining extent sizes"
Maybe reply: Frank Kobylanski: "Re: determining extent sizes"
Maybe reply: Paul Osborn: "Re: determining extent sizes"
Reply: Jared Still: "Re: determining extent sizes"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message