
November 21st, 2003, 09:07 PM
|
|
Registered User
|
|
Join Date: Nov 2003
Posts: 14
Time spent in forums: 31 m 42 sec
Reputation Power: 0
|
|
|
Peculiar behaviour on a locally managed tablespace
Hello,
Oracle version is 8.1.7.4
I've a table sitting in a locally managed tablespace. The table has an extent size of 5m( uniform ). Every time the records are inserted after the HWM( high water mark ), even though there is a lot of space available ( with in the tablespace ) and the total volume of the table ( and those inserted are very small( in 100's ). This causes lot of fragmentation.
Here are some details...
SELECT COUNT(DISTINCT DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)) FROM SA_MAX_FISCAL_PERIOD;
COUNT(DISTINCTDBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID))
---------------------------------------------------
6
select count(*) from SA_MAX_FISCAL_PERIOD;
COUNT(*)
----------
297
select num_rows, blocks, empty_blocks from user_tables
where table_name='SA_MAX_FISCAL_PERIOD';
NUM_ROWS BLOCKS EMPTY_BLOCKS
---------- ---------- ---------------------
297 5119 0
Couldn't get much from oracle meta-link.
Any help is appreciated. Thanks.
Kramer.
|