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

Report message to a moderator

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: 68667
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 17 22:58:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.