How to seup tablespace storage
From: Meng <m.fangtao_at_genesis.co.nz>
Date: 16 Aug 2001 20:36:24 -0700
Message-ID: <1ddc56b5.0108161936.1de54943_at_posting.google.com>
Date: 16 Aug 2001 20:36:24 -0700
Message-ID: <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 Received on Fri Aug 17 2001 - 05:36:24 CEST