Extent management local uniform size ???
Hi,
Oracle database 8.1.7.0
we are having SECTS which is dictionary managed and i want to make it locally managed by creating a new TS and will use exp / imp, which will also remove space fragmention within the TS.
This SECTS is the primary TS with lots of load and thus increasing contention on the system tables for managing free extents and thus degrading the performance of database.
so i want to make it locally managed to improve its performance.
Now my query is,
which storage memory clause is more recommendable while creating new tablespace ?
1) locally manage autoallocate
2) locally manage uniform size
Our block size is 8kb, block buffer size is 10847 bytes, RAM is of 2GB
Now if i keep "autoallocate" then no question of giving size (case 1),
but in case of uniform size (case 2)
what extent size should i keep as per above block size details ???
*(i have got stuck over here regarding extent size)*
which extent size will be more appropriate considering block size,block buffer and size of the RAM as mentioned above ????
extent size wil be the multiple of the block size(8kb) which is mentioned above.
please guide....
With Regards