Set PCTINCREASE to 1 for coalescing
Eugene Firyago <efiryago_at_bisys.com> wrote in message
news:7vmtvs$ld8$1_at_autumn.news.rcn.net...
>
> 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 - 09:09:36 CST
