Re: How to seup tablespace storage

From: Meng <m.fangtao_at_genesis.co.nz>
Date: 17 Aug 2001 17:09:27 -0700
Message-ID: <1ddc56b5.0108171609.5ac0f6d9_at_posting.google.com>


postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0108170232.3c8828e6_at_posting.google.com>...

> m.fangtao_at_genesis.co.nz (Meng) wrote in message news:<1ddc56b5.0108161936.1de54943_at_posting.google.com>...
> > I am a new Oracle DBA. We will create a tablespace for a big table
> > (more than 6GB). The table is always inserted,updated and selected.
> > The table's row size is 268 bytes. Which tablespace storage shall I
> > choose, locally managed or dictionary managed? If I select locally
> > managed automatic allocation, the default initial extent is only 64k
> > (DB_BLOCK_SIZE=8k). Do you think the value is a little bit of small?
> > How to setup the table's storage? Do I need to modify default storage
> > values? Thank you very much.
> >
> > Meng
>
> If you are on 8i - and sigh, again NO version and platform, why if you
> do take the trouble to post, not include that-
> use locally managed for everything except the system tablespace.
> 64k is not small depending on platform. Most platform won't read more
> than 64k ahead anyway.
> You don't setup the tables storage, as that has been done for you by
> making the tablespace locally managed.
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA

Thanks Sybrand. My Oracle version is 8.1.7 Standare edition. Platform is Compaq Tru64 Unix V5.1. How many uniform size for TEMP and RBS tablespaces if I choose locally managed.

Regards,
Meng Received on Sat Aug 18 2001 - 02:09:27 CEST

Original text of this message