For tables/indexes, the minimum initial extent size is 2 blocks (8k = 2*
4k). Block 0 contains the segment header, block 1 contains the data/index
entries.
Daniel Fink
nelson.petersen@homehardware.ca wrote:
Since
I agreed with Mladen that it wouldn't work, I just had to test this.On
8.1.7.3 on OpenVMS the "deallocate unused keep # " shrinks the initial
extent.It
shrank a test table from 1m to 8k. I'm not sure why it chose
8k.(db_block_size=4k,
default initial_extent for
the tablespace=64k)I
assume it would work on SYS tables as well.(No
sacrificial database that I'm willing to try it on.)Nelson
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel Fink
INET: Daniel.Fink_at_Sun.COM
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Dec 03 2003 - 15:59:27 CST
