Re: Max Extents

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 2 Nov 1999 07:31:42 +0100
Message-ID: <941524345.16466.0.pluto.d4ee154e@news.demon.nl>

1 use the formula in Appendix A of the Oracle Server Administrators Guide to determine space needed for the initial load 2 set next extent for every object to 10 or 20 percent of the initial extent 3 set pctincrease to 0.

Usually this works. You may need to revise your estimates over time, but I never saw a separate application resizing automatically. The only reason for that is, that the answer to your last question is : YES.

Hth,

--
Sybrand Bakker, Oracle DBA
<stuart.crawford_at_home.com> wrote in message news:7vlqme$82k$1_at_nnrp1.deja.com...
> Can you guys tell me how we determine optimum size for extents on a DB.
> The problem we are experiencing has to be handled in some manner so
> that we have an application that we have resize the extents everyday.
> Correct me if I'm wrong but this can't be the only application on an
> Oracle Server that's writes a large number new records into the
> database everyday. How do these applications handle the problem? is it
> a matter of our estimates being way off?
>
> --
> Stuart R. Crawford, MCP, CNA
> Calgary, Alberta, Canada
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 02 1999 - 00:31:42 CST