How can free + used space > tbs size, can someone explain
587557Oct 12 2007 — edited Oct 15 2007Hi Gurus
Can someone explain this, How can free + used space in a tablespace can be greater than size of a tablespace. What am I missing here . Thanks a lot .
I am on 10.2.0.1, HP-UX
14:38:52 SQL> select owner,sum(bytes), sum(BYTES) /1024/1024 "MB" from dba_segments where tablespace
name='USERDB1ADATA' group by owner;
OWNER SUM(BYTES) MB
------------------------------ ---------- ----------
USERDB1A 839680000 800.78125
1 row selected.
14:40:42 SQL> select bytes, BYTES /1024/1024 "MB" from dba_data_files where tablespace_name='USERDB1
A_DATA';
BYTES MB
---------- ----------
3758096384 3584
1 row selected.
14:40:42 SQL> select sum(bytes) , sum(BYTES) /1024/1024 "MB"from dba_free_space where tablespace_nam
e='USERDB1A_DATA';
SUM(BYTES) MB
---------- ----------
3067412480 2925.3125
1 row selected.
14:40:43 SQL> select 839680000 + 3067412480 "used + free space" from dual;
used + free space
-----------------
3907092480
1 row selected.
New DBA