Oracle 10 auto free space?

From: Ricard Martínez <ricard.martinez@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Thu, 10 Dec 2009 08:43:18 +0100

Hi all.
Im using a select  to check space in database:

select sysdate, total_space,total_space-nvl(
free_space,0) used_space, nvl(free_space,0) free_space,((total_space -
nvl(free_space,0)) / total_space)*100 pct_inuse, num_db_files
    from ( select sum(bytes)/1024/1024 free_space      from
sys.DBA_FREE_SPACE ) FREE,
         ( select sum(bytes)/1024/1024 total_space,  count(*)
num_db_files    from   sys.DBA_DATA_FILES) FULL;

With a result like:

Timestamp    DBSize (Meg)    Used (Meg)    Free (Meg)    % Used    Num DB
Files
1    07 Dic 2009 11:28    129782    98300    31482    75.74    41
2    08 Dic 2009 11:28    129782    98255    31527    75.71    41
3    09 Dic 2009 12:00    129782    98639    31143    76.00    41


Between Dic 7 and 8, the used space lows. I havent done, any shrink, or
coalesce, or purge bin, nothing. Its posible that
the difference in used was by a delete, and that the locally tablespace,
coalesce the free space?
Thanks

Oracle 10 auto free space?

Other related posts: