Thursday, August 13, 2020
    Home Oracle Internals Oracle Utilities Undocumented-dbfsize

    Oracle Utilities Undocumented-dbfsize

    Hi Friends,

    There is hidden and undocumented Oracle utility available called DBFSIZE. This Oracle utility provides the exact size of the file, which is connected with Oracle software.

    - Advertisement -

    Means we can get the size of the control file, redo log file, datafile size using DBFSIZE undocumented Oracle utility.

    DBFSIZE utility doesn’t available for Windows platforms.

    How to use DBFSIZE utility of Oracle?

    DBFSIZE provides a number of blocks and size of block in output of Database file size (check below example first number stands for the number of blocks and the second number stands for the size of each block)

    - Advertisement -

    $ dbfsize indx.dbf

    Database file: indx.dbf

    Database file type: file system

    Database file size: 4196 8192 bytes blocks

    $ dbfsize control.ctl

    Database file: control.ctl

    Database file type: file system

    Database file size: 162 14324 bytes blocks

    $ dbfsize redo1a.log

    Database file: redo1a.log

    Database file type: file system

    Database file size: 20480 512 bytes blocks

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

    More Oracle DBA Tips and Oracle RAC DBA Tips you can find out from our official website of remote database monitoring.

    Wish you all the best,

    Thanks and regards,

    Remote DBA team of Dbametrix Solutions

    - Advertisement -
    - Advertisment -

    Most Popular

    ASM Disk creation issue

    The article explains how to troubleshoot Oracle ASM disk creation. Solution of Oracle ASM disk creation with ASMLIB

    Oracle Tuning Basics Part-2

    This is the 2nd part of Oracle database tuning basics including depth of every aspects.

    Oracle Tuning Basics Part-1

    The article explains Oracle database performance tuning basics details.

    When you finding new job

    The article guides you 10 things to remember when you are searching a new job to improve yourself including skills and better growth for every DBA.

    Recent Comments

    Gordon Coleclough on Oracle Tuning Basics Part-1
    Gordon Coleclough on ASM Disk creation issue