control file block size. [message #264424] |
Mon, 03 September 2007 05:00 |
alantany
Messages: 115 Registered: July 2007
|
Senior Member |
|
|
Hello,all!
I found my control file block size and data file block size are defferent ,I do not think I set a control file block size when I create db,where does it from ?
SQL> select name,block_size,file_size_blks from v$controlfile;
NAME BLOCK_SIZE FILE_SIZE_BLKS
------------------------------ ---------- --------------
C:ORACLEPRODUCT10.2.0ORADA 16384 450
TAORCLCONTROLFILEO1_MF_390M
ZRBL_.CTL
SQL> show parameter block_size;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_block_size integer 8192
SQL> select name,block_size from v$datafile;
NAME BLOCK_SIZE
------------------------------ ----------
C:ORACLEPRODUCT10.2.0ORADA 8192
TAORCLDATAFILEO1_MF_SYSTEM_
390N2CK3_.DBF
C:ORACLEPRODUCT10.2.0ORADA 8192
TAORCLDATAFILEO1_MF_UNDOTBS
1_390N2D0W_.DBF
C:ORACLEPRODUCT10.2.0ORADA 8192
TAORCLDATAFILEO1_MF_SYSAUX_
390N2CW2_.DBF
NAME BLOCK_SIZE
------------------------------ ----------
C:ORACLEPRODUCT10.2.0ORADA 8192
TAORCLDATAFILEO1_MF_TEST_39
0N2DBX_.DBF
C:ORACLEPRODUCT10.2.0ORADA 8192
TAORCLDATAFILEO1_MF_DEFAULT
__390N2DJK_.DBF
C:ORACLEPRODUCT10.2.0DBDAT 8192
AORCLDATAFILEO1_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
CORE 10.2.0.3.0 Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 -
Regards !
Alan
[Updated on: Mon, 03 September 2007 06:20] Report message to a moderator
|
|
|
|
|
Re: control file block size. [message #264441 is a reply to message #264430] |
Mon, 03 September 2007 06:22 |
alantany
Messages: 115 Registered: July 2007
|
Senior Member |
|
|
Arju wrote on Mon, 03 September 2007 05:20 | Don't be worried. Both size is dependent on your Operating system block size.
|
Thanks,Arju!
I use winxp and the os block size is 4K,I want to know why my control file block size is 16K,where can I set it?
Regards!
Alan
|
|
|
Re: control file block size. [message #264442 is a reply to message #264433] |
Mon, 03 September 2007 06:23 |
alantany
Messages: 115 Registered: July 2007
|
Senior Member |
|
|
Michel Cadot wrote on Mon, 03 September 2007 05:24 | In addition, use "Preview Message" button before posting.
There are too much blank and useless lines in your post.
Regards
Michel
|
Sorry ,Michel!
I edit the text,hope your answer.
Regards!
Alan
|
|
|
|
Re: control file block size. [message #264579 is a reply to message #264513] |
Mon, 03 September 2007 18:55 |
alantany
Messages: 115 Registered: July 2007
|
Senior Member |
|
|
Michel Cadot wrote on Mon, 03 September 2007 10:36 | Quote: | I want to know why my control file block size is 16K
|
Block or cluster size on your OS.
Regards
Michel
|
But my os cluster size is 4K.
Regards!
Alan
|
|
|
|
|