EM EXPRESS Displays Wrong Size of Free Space When Datafile is Full (Doc ID 2452881.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• From the view DBA_FREE_SPACE, the tablespace TBS_01 does not appear
• But EM EXPRESS shows that the tablespace TBS_01's size is 1GB and the free size is 958MB
• Through the following information, the datafile is full:
  
  SQL> SELECT d.file_name "FILE", d.tablespace_name "TABLESPACE", v.status "STATUS",
  2 TO_CHAR((d.bytes / 1024 / 1024), '99999990.000') "SIZE(M)",
  3 NVL(TO_CHAR(((d.bytes - SUM(s.bytes)) / 1024 / 1024),'99999990.000'),
  4 TO_CHAR((d.bytes / 1024 / 1024), '99999990.000')) "USED(M)"
  5 FROM sys.dba_data_files d, sys.dba_free_space s, sys.v_$datafile v
  6 WHERE (s.file_id (+)= d.file_id) AND (d.file_name = v.name)
  7 GROUP BY d.file_name,d.tablespace_name, v.status, d.bytes
  8 order by TABLESPACE;

  FILE TABLESPACE STATUS SIZE(M) USED(M)
  ---------------------------------------------------------------------- ----------------------------- -------------------------- -------------
  datafile/TEST_01.dbf TBS_01 ONLINE 1030.000 1030.000

    
  
  

Changes

 None

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.