Home » RDBMS Server » Server Administration » Larger Blocksize for INDEXTABLESPACE (
Larger Blocksize for INDEXTABLESPACE [message #336623] Mon, 28 July 2008 07:29 Go to next message
Messages: 36
Registered: July 2008

My DB blocksize is 8K.

If I create a larger blocksize (say 32K) for index tablespace will it be helpful in faster retrival?


Re: Larger Blocksize for INDEXTABLESPACE [message #336637 is a reply to message #336623] Mon, 28 July 2008 08:35 Go to previous message
Michel Cadot
Messages: 63908
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on your application and the statements it execute.
In addition, you have to configure and manage a cache for this block size and so have less space for the default cache.

Previous Topic: pfile at remote location..
Next Topic: SCN:system change number and alertlogfile
Goto Forum:

Current Time: Fri Oct 21 06:20:25 CDT 2016

Total time taken to generate the page: 0.10254 seconds