可以的。
[php]
SQL> select name,block_size,file_size_blks from v$controlfile;
NAME
BLOCK_SIZE FILE_SIZE_BLKS
------------------------------ ---------- --------------
C:\ORACLE\PRODUCT\10.2.0\ORADA16384
450
TA\ORCL\CONTROLFILE\O1_MF_390M
ZRBL_.CTL
SQL> show parameter block_size;
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
db_block_size
integer 8192
SQL> select name,block_size from v$datafile;
NAME
BLOCK_SIZE
------------------------------ ----------
C:\ORACLE\PRODUCT\10.2.0\ORADA 8192
TA\ORCL\DATAFILE\O1_MF_SYSTEM_
390N2CK3_.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADA 8192
TA\ORCL\DATAFILE\O1_MF_UNDOTBS
1_390N2D0W_.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADA 8192
TA\ORCL\DATAFILE\O1_MF_SYSAUX_
390N2CW2_.DBF
NAME
BLOCK_SIZE
------------------------------ ----------
C:\ORACLE\PRODUCT\10.2.0\ORADA 8192
TA\ORCL\DATAFILE\O1_MF_TEST_39
0N2DBX_.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADA 8192
TA\ORCL\DATAFILE\O1_MF_DEFAULT
__390N2DJK_.DBF
C:\ORACLE\PRODUCT\10.2.0\DBDAT 8192
A\ORCL\DATAFILE\O1_MF_TEST100_
NAME
BLOCK_SIZE
------------------------------ ----------
3BYJR6R3_.DBF
C:\DUL.DBF
8192
7 rows selected.
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE10.2.0.3.0Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
