Re: DB_BLOCK_SIZE --- How ??
Date: 2000/05/31
Message-ID: <959766361.19417.0.pluto.d4ee154e_at_news.demon.nl>#1/1
First of all, IMO there are only very rare cases where 16k is advantegeous. I just returned from a customer where I saw the detrimental consequences: many tables are smaller than db_file_multiblock_read_count * db_block_size, so whatever index: they will be read using full table scan. Secondly, you can't change this parameter, the init<sid>.ora needs to have the correct value *PRIOR* to database creation. As you don't specify which version you are using, I can't tell you whether the oradim utility, the installer or the database assistant will allow you to change it on the fly, some do, some don't
Hth,
Sybrand Bakker, Oracle DBA
Johnson <syner_at_pd.jaring.my> schreef in berichtnieuws
8h2kmg$era$1_at_news4.jaring.my...
> Hello,
>
> How am I going to make this DB_BLOCK_SIZE to 16K in windows NT server.
> During install, the database ORCL is created and the db_block_size is
> default to 1k.
>
> Do I change db_block_size during Oracle Installation or after the
> installation. How ??
>
>
>
>
Received on Wed May 31 2000 - 00:00:00 CEST