Big free space chunk in a tablespace
Hi all,
We are on 10gR2 database on Solaris 64-bit Sparc systems. Our tablespaces are LMT. We are comparing two production database with very similar application data (ie serving two different customer) but with exactly same object structure including tables, indexes, datafiles etc.
1st server's data tablespace datafile has around 80% usage; rest around 20% blocks are free - most of them in 128 block sizes (using dba_free_space view). The datafile size is the default one we started with (2GB).
However, other database has around 40% usage and out of rest 60% free, I can see one big chunk of blocks amounting to 3.3Gb plus some 128 blocks too. We are trying to know the cause how come we have such a huge chunk of free space sitting in middle of datafile. This file has grown from its default size (from 2GB to 5.5GB). I have restored this db to one of my test box. If I create some dummy table, it does use that space so do not believe space is corrupted or can not be used for any
1st server's data tablespace datafile has around 80% usage; rest around 20% blocks are free - most of them in 128 block sizes (using dba_free_space view). The datafile size is the default one we started with (2GB).
However, other database has around 40% usage and out of rest 60% free, I can see one big chunk of blocks amounting to 3.3Gb plus some 128 blocks too. We are trying to know the cause how come we have such a huge chunk of free space sitting in middle of datafile. This file has grown from its default size (from 2GB to 5.5GB). I have restored this db to one of my test box. If I create some dummy table, it does use that space so do not believe space is corrupted or can not be used for any
0