C
ChUIMonster
Guest
That's a topic of some debate and personal preference. Rows per block is meaningless to indexes. The thinking behind the recommendation is that RPB = 1 says "this storage area is for indexes, don't put anything else in it." The other perspective is "if you accidentally put something else in that area it will probably get very big, very fast." I can confirm that from personal experience, having done so at least once 
But -- that rapid growth also serves as a "canary in the coal mine" that you have an issue that needs attention... Of all the various recommendations in that presentation that is the one that I would be least likely to spend much time worrying about. If you think that you would rather go with rpb = 256 "just in case someone puts a table in an index area" I might raise an eyebrow but I'm not going to spend much time trying to talk you out of it. On 3/18/15 10:32 AM, S33 wrote: RE: Converting from oe10.2 to oe11.5 Reply by S33 Tom -- I spent a little more time in the storage optimization ppt you recommended. Can you explain the logic behind this statement: "Indexes should always be assigned to a storage area whose rows per block is set to 1. " Thx in advance -- Jim Shepherd jrs@lvlsvn.com Stop receiving emails on this subject. Flag this post as spam/abuse. -- Tom Bascom 603 396 4886 tom@greenfieldtech.com
Continue reading...
But -- that rapid growth also serves as a "canary in the coal mine" that you have an issue that needs attention... Of all the various recommendations in that presentation that is the one that I would be least likely to spend much time worrying about. If you think that you would rather go with rpb = 256 "just in case someone puts a table in an index area" I might raise an eyebrow but I'm not going to spend much time trying to talk you out of it. On 3/18/15 10:32 AM, S33 wrote: RE: Converting from oe10.2 to oe11.5 Reply by S33 Tom -- I spent a little more time in the storage optimization ppt you recommended. Can you explain the logic behind this statement: "Indexes should always be assigned to a storage area whose rows per block is set to 1. " Thx in advance -- Jim Shepherd jrs@lvlsvn.com Stop receiving emails on this subject. Flag this post as spam/abuse. -- Tom Bascom 603 396 4886 tom@greenfieldtech.comContinue reading...