Home » RDBMS Server » Server Administration » control file block size.
control file block size. [message #264424] Mon, 03 September 2007 05:00 Go to next message
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 #264430 is a reply to message #264424] Mon, 03 September 2007 05:20 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Don't be worried. Both size is dependent on your Operating system block size.
Re: control file block size. [message #264433 is a reply to message #264424] Mon, 03 September 2007 05:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition, use "Preview Message" button before posting.
There are too much blank and useless lines in your post.

Regards
Michel
Re: control file block size. [message #264441 is a reply to message #264430] Mon, 03 September 2007 06:22 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #264513 is a reply to message #264441] Mon, 03 September 2007 10:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I want to know why my control file block size is 16K

Block or cluster size on your OS.

Regards
Michel
Re: control file block size. [message #264579 is a reply to message #264513] Mon, 03 September 2007 18:55 Go to previous messageGo to next message
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
Re: control file block size. [message #264619 is a reply to message #264579] Mon, 03 September 2007 23:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Anyway, Oracle chooses its control file block size from parameters depending on OS type, file system type and parameters, etc.
You don't have any choice on this.

Regards
Michel
Re: control file block size. [message #264626 is a reply to message #264619] Tue, 04 September 2007 00:04 Go to previous message
alantany
Messages: 115
Registered: July 2007
Senior Member

ok!Thanks ,Michel.
Regards
Alan
Previous Topic: Changing parallel_max_servers parameter
Next Topic: Migration
Goto Forum:
  


Current Time: Mon Dec 05 06:58:54 CST 2016

Total time taken to generate the page: 0.12700 seconds