在Linux/Unix上,Oracle提供一个小工具dbfsize可以用于查看文件的Block Size大小.
oracle:/u02/oradata$pwd //查看所在目录
/u02/oradata
oracle:/u02/oradata$ls -l sys*
lrwxrwxrwx 1 oracle dba 12 Nov 05 06:19 sysaux.t -> sysaux01.dbf
-rw-r----- 1 oracle dba 471875584 Nov 26 14:33 sysaux01.dbf
-rw-r----- 1 oracle dba 524304384 Nov 26 14:33 system01.dbf
oracle:/u02/oradata$ls -l con* //看控制文件详细信息
-rw-r----- 1 oracle dba 5488640 Nov 26 14:34 control01.ctl
oracle:/u02/oradata$dbfsize control01.ctl //查看控制文件块大小
Database file: control01.ctl
Database file type: file system
Database file size: 334 16384 byte blocks
oracle:/u02/oradata$dbfsize sysaux01.dbf \\看数据文件块大小
Database file: sysaux01.dbf
Database file type: file system
Database file size: 28800 16384 byte blocks
oracle:/u02/oradata$dbfsize redo01a.dbf
redo01a.dbf: No such file or directory
oracle:/u02/oradata$dbfsize redo01a.log \\看redo文件块大小
Database file: redo01a.log
Database file type: file system
Database file size: 204800 512 byte blocks
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8258133/viewspace-503431/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8258133/viewspace-503431/