![]() ![]() Cache is allocated for other database block sizes by using the DB_nK_CACHE_SIZE, where n is the block size in KB. The data block cache for the default block size is set using the DB_CACHE_SIZE initialization parameter. ![]() The block size for data warehouses is often 32K (you want many rows to be read at a time) and OLTP systems are often 8K. You must rebuild the database if you want to increase the DB_BLOCK_SIZE. You still want to put the bulk of your data in the default buffer cache. ![]() Although you can have different block-size tablespaces, this is not truly a performance feature, as the nondefault buffer caches are not optimized for performance. But it is still very important to choose wisely. That said, a separate cache memory allocation must be made for each different database block size. Since Oracle 10g Release 2, each tablespace can have a different block size, thus making block size selection a less critical selection before the database is created. The DB_BLOCK_SIZE is the size of the default data block size when the database is created. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |