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.