Oracle Database
--
Questions
--
Followers
Top Experts
Maximum Db_block_size on a windows 32 bit O/S
I currently have an oracle database with a 2k db_block_size on Windows 2003 32 bit server. Can I increase the db_block_size to increase performance and if so what is the maximum db_block_size for the oracle server on windows 32 bit.
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
So if I change the block size to 8k from 2k would this help in improving performance of the database?
When and why would you ever use 2k db_block_size?
2k db_block_size is useful for OLTP transactions with small record size. The length of a record should be very small so that more rows can be accomodated in a block. But Oracle block size should be a multiple of OS block size. The value of MULTI_BLOCK_READ_COUNT also should be appropriately set.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin
Oracle Database
--
Questions
--
Followers
Top Experts
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.