Why does oncheck warn me about more than 8 extents?
On 10th Mar 1998 satriguy@aol.com (SaTriGuy) wrote:- If you are on anything since 7.11, I wouldn’t worry too much about the “less than 8 extent” rule. In version 5, we used an extent table in memory for each tablespace which was only 8 entries large. For any extent past the eighth, we had to examine the systables table for that database directly. This is why we made such a big deal about the “eight extents”. With 7.11+, we dynamically allocate memory so that all of the extents are in memory. Thus the “less than extents” rule is not nearly so important. However, if you are really going to have this many tables on a 7.1x or 7.2x system, you might want to increase your in memory dictionary somewhat. This is managed by the DD_HASHSIZE and DD_HASHMAX onconfig variables. These are undocumented so you will need to contact tech support to get information on how to use them.
