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

My DB blocksize is 8K.

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

Brian

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: 64152
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.

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


Current Time: Sat Dec 10 08:50:38 CST 2016

Total time taken to generate the page: 0.10003 seconds