Hi Tamil,

Thanks for your reply.

By today I have checked the view DBA_FREE_SPACE, and it showing correct values


ADMIN@PROD>select
2 ( select sum(bytes)/1024/1024 from dba_data_files
3 where tablespace_name like 'UND%' ) allocated,
4 ( select sum(bytes)/1024/1024 from dba_free_space
5 where tablespace_name like 'UND%') free,
6 ( select sum(bytes)/1024/1024 from dba_undo_extents
7 where tablespace_name like 'UND%') USed
8 from dual;

ALLOCATED FREE USED
------------ ------------ ------------
46,500.000 37,289.500 9,210.125

But I have checked the same views,yesterday it show different values as above. Its their any time difference in updating the base tables of the view DBA_FREE_SPACE.

Oracle Version
=============
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production