Properly sizing the extents
Posted on 1998-04-12
We have a Oracle database(220.127.116.11) with db_block_size 8k on Sun UltraSparc machine(Solaris Ver 2.6).
I created a tablepsace with the default storage parameter 'initial extent' as 64K(ie 8 db blocks). But the objects created in the tablespace takes up 80K(ie 10db blocks) for its initial extent. I created the object in the tablespace by explicitly specifying the storage parameter for the object.(with initial extent size as 64K). This also creates extents with 80K.
How to prevent the Oracle from doing this rounding and get the correct extent size which I need?