I just started at my new DBA job, and I have been reviewing their database
installation procedure. I noticed that they create all their databases with a 4K
block size. This is for Oracle 9.2 on AIX 5.2. It has been my general understanding
that most sites these days use 8K db_block_size as a
Hi Chris,
Be default Oracle 9i create database with 4k block_size ,you can choose
differently types of block_size on tablespace level. You may like to look
into tablespace block_sizes. I have a 4 k block size in one of our
production database but it allows me to have different block size on
Syed
The statement I received from an Oracle instructor is that the ability to
handle blocks of a different size are in 9i for one purpose and one purpose
only -- so you can bring a transportable tablespace from another database.
Specifically, if you have databases with several block sizes you
I fully agree with Dennis. Even some applications like Oracle Finanacials
11i requires that min db_block size should be 8K. About 32K size, may be
some OS not support that size but 16K is much better for OLAP environment
and we have been using 8K for OLAT and 16K for OLAP/DSS.
Regards
Rafiq