Re: Max Extents

Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote in message news:941524345.16466.0.pluto.d4ee154e_at_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.

I am not quitely sure but I have heard that SMON is not able to performe tablespace background coalecsing if pctincrease is set to 0. Is that true?

>
> 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 - 08:54:15 CST