Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Multiple Block Sizes - Improve efficiency by having multiple block sizes that relate more closely to the operations that are being performed.



Arindam Mukherjee said...

The portrayal is good enough albeit I think it would be more rich and enthralling if some live example like init.ora file contents were illustrated to take the essence fully.
Anyway thanks for your effort.

Tim... said...

Hi.

As requested, I've added a complete example.

Cheers

Tim...

Srikanth said...

Tim

I want to implement for my large indexes to be 32k block size, how do we test it

Srikanth

Tim... said...

Create the 32K cache. Create a tablespace with a 32K block size. Create the index within the new tablespace. Once this is doen run your system and see if it improves performance.

Cheers

Tim...

PS. It's best to ask these sort of questions on the forum. The comments are really for comments on the article contents.

Ronald Brayan said...

Hi Tim,

Indeed it is a good article. Definately it will help the DBA. But, it could be more interesting if you could explain with few examples.

Tim... said...

Hi.

There is an example at the end of the article. I'm not sure what else I can explain about this subject.

Cheers

Tim...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired