Re: Size of extents?

From: jarom <jarom_at_xotmail.com>
Date: Wed, 07 Nov 2001 15:51:38 GMT
Message-ID: <eMcG7.20$h3.134650@news.kpnqwest.ch>

Thanks, Connor!

Jann

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3BE69F21.66F3_at_yahoo.com...
> jarom wrote:
> >
> > In Oracle documentation, I never found any practical hints on what
criteria
> > should be used to determine ideal extent sizes for tables and indexes
and
> > how they impact database performance.
> >
> > Can anyone help me with this issue or have a clue where good relevant
> > documentation can be found?
> >
> > Thanks for any inputs in advance!
> >
> > Jann
>
> Simple guidelines:
>
> a) in each tablespace every extent should be the same size (typically
> via locally managed tablespaces)
> b) have multiple tablespaces so that you can use a different set of
> extent sizes in use, such that each object in your application has a
> manageable number of extents (say less than roughly 100 or so)
>
> hth
> connor
>
> --
> ==============================
> Connor McDonald
>
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue..."
Received on Wed Nov 07 2001 - 09:51:38 CST