Tablespace Size mismatch between dba_data_files and v$asm_file

(Doc ID 2007656.1)

Last updated on APRIL 26, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

File size difference on Database and ASM. 

In the below output we see that there a difference of almost 20GB. Where the size showing on ASM is way higher than what the actual size of the datafile on the database.

From Database

select file_id, file_name c1, bytes/1024/1024 from dba_data_files;

FILE_ID file_name BYTES/1024/1024
---------- ------------------------------------------------------------ ---------------
4 +DATA/kisp/datafile/users.298.864736579 61,25
3 +DATA/kisp/datafile/undotbs1.329.864735999 32767,9844
2 +DATA/kisp/datafile/sysaux.316.864736293 3000
1 +DATA/kisp/datafile/system.321.864736013 3880
5 +DATA/kisp/datafile/miss_data.330.864735999 124600
6 +DATA/kisp/datafile/misc_data.331.864735979 243200
7 +DATA/kisp/datafile/misw_data.270.864735979 217500
8 +DATA/kisp/datafile/lead_data.257.864736007 92160



From ASM

select group_number, file_number,block_size,blocks,bytes/1024/1024/1024,space/1024/1024/1024 from v$asm_file;

GROUP_NUMBER FILE_NUMBER BLOCK_SIZE BLOCKS BYTES/1024/1024/1024 SPACE/1024/1024/1024
------------ ----------- ---------- ---------- -------------------- --------------------
1 253 512 23 .000010967 .000976563
1 257 8192 157286401 1200.00001 1200.01074

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms