OraFAQ Forum: Server Administration » control file block size

Home » RDBMS Server » Server Administration » control file block size - db_block size?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

control file block size - db_block size? [message #528283]

Mon, 24 October 2011 01:53

hanner
Messages: 90
Registered: August 2011
Location: at HOME

Member

SQL> select block_size from v$controlfile;

BLOCK_SIZE
----------
     16384

SQL> show parameter db_block_size;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_block_size                        integer     8192

the 2 can have difference block size?

Report message to a moderator

Re: control file block size - db_block size? [message #528290 is a reply to message #528283]

Mon, 24 October 2011 02:20

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes.

Regards
Michel

Report message to a moderator

Re: control file block size - db_block size? [message #528339 is a reply to message #528283]

Mon, 24 October 2011 06:13

gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK

Senior Member

Do you only have one control file?

Report message to a moderator

Re: control file block size - db_block size? [message #528341 is a reply to message #528339]

Mon, 24 October 2011 06:21

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It seems unless he stripped his output which is possible as the result is the same for each control file and it does not add any information to have 1 or several times the same value.
Anyway, this is not the question.

Regards
Michel

Report message to a moderator

Previous Topic:	fetch procedure of one database from another database server
Next Topic:	How to compress index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 18:40:07 CDT 2024