Re: Max Extents

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 02 Nov 1999 20:26:58 +0800
Message-ID: <381ED892.7EB3@yahoo.com>

Gazza wrote:
>
> 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.
> > >
> > >
> >
> >

Or maybe you could/should

set pctincrease to 0
set standard extent sizes (for next and initial)
optionally set the tablespaces to locally managed (8i only)

and wave goodbye to fragmentation, regular coalesce, import/export etc etc altogether...

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Nov 02 1999 - 06:26:58 CST