Re: SYSTEM tablespace 300M?

Adrian J. Shepherd wrote:
>
> BLOCK_SIZE isn't directly related to chained rows.. Chained rows are best
> avoided using correct PCTFREE and PCTUSED storage qualifiers. Use smaller
> block sizes for smaller databases and OLTP environments, use larger block
> sizes for larger I/O bound applications such as warehousing and applications
> that force long table scans.
>
> "Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
> news:38E752A1.3C97_at_yahoo.com...
> > Arthur Levin wrote:
> > >
> > > Hi,
> > > I installed Oracle8i and created new database.
> > > SYSTEM tablespace I set 300M (initial 1M next 1M pctincrease 1).
> > > Additional installed on other machine Oracle8i Client , Oracle
 WebDB(user
> > > webdb) and TOAD.
> > >
> > > New schema I installed under not SYSTEM user!!!
> > > The atabase is competly empty no data.
> > > When I checked the size of tablespaces the SYSTEM tablespace exceeded
 the
> > > limit 300M
> > > So I increased SYSTEM tablspace to 400M.
> > >
> > > In TOAD server Tuning I received: Chained Fetch Ratio is HIGH.
> > > If anybody knows what is wrong with my database and maybe will be good
 idea
> > > reinstall database.
> >
> > Chained rows sounds like you may have a small block size. You haven't
> > mentioned what platform and what you want to use it for, but a common
> > norm is 8k (but the database typically defaults to 2k or 4k)
> >
> > HTH
> > --
> > ===========================================
> > Connor McDonald
> > http://www.oracledba.co.uk
> >
> > We are born naked, wet and hungry...then things get worse

We may be talking semantics here -

(Using my understanding of the terminology) there are 'migrated' rows which are what happens when the you don't have enough pctfree, and 'chained' rows when a row cannot be fit into a single block (for example if it contains a large varchars or a long etc).

Thus 'chained' rows do depend on blocksize - you can typically see them from the statistic "table fetch continued row"

Cheers

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse