Name

dbfsize

Use dbfsize to determine the block size and the number of blocks in a given database file. dbfsize can be run against datafiles, redo logfiles, and control files.

Tip

dbfsize is not available on Windows platforms.

Syntax

dbfsize database_file_name

Parameters

database_file_name

The name of a database file

Examples

$ dbfsize control01.ctl

Database file: control01.ctl
Database file type: file system
Database file size: 184 16384 byte blocks

$ dbfsize redo01.log

Database file: redo01.log
Database file type: file system
Database file size: 20480 512 byte blocks

$ dbfsize users01.dbf

Database file: users01.dbf
Database file type: file system
Database file size: 768 8192 byte blocks

The output of dbfsize shows three values. The first is the filename, which is the same as the input parameter. The second is the type of the file—whether file system or raw. The third consists of two numbers: the first number is the number of blocks; the second is the size of each block. Note that the block sizes of different files and types of files may differ from each other.

Get Oracle Utilities Pocket Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial