Oracle Undocumented Utility DBFSIZE

DBFSIZE is a hidden and undocumented Oracle utility.This utility is used to provide the exact size of Oracle database files like Datafiles,Controlfiles and Redolog files.

This Utility is not available for Windows platforms.

Using DBFSIZE Utility:

DBFSIZE provides number of blocks and size of block in output of Database file size

$ dbfsize USERS.dbf

Database file: USERS.dbf
Database file type: file system
Database file size: 4196 8192 bytes blocks

Where:
- The first number [4196]: stands for number of blocks.
- The second number [8192]: stands for size of each block.

$ dbfsize CONTROL01.ctl

Database file: CONTROL01.ctl
Database file type: file system
Database file size: 162 14324 bytes blocks

$ dbfsize REDO1.log

Database file: REDO1.log
Database file type: file system
Database file size: 20480 512 bytes blocks

DBFSIZE is helpful to when checking backup file size and current file size of Oracle database.