Also relevant:
Tom's presentation on the Alternate Buffer Pool (OE 10.2B+):
http://dbappraise.com/ppt/B2Buzz.pptx
The Alternate Buffer Pool may be particularly helpful to you if you have objects (tables or indexes) that are small but very frequently read. To determine this you need runtime statistics for your application(s). If you take this approach you may want to structure your database so that these frequently-read storage objects reside in their own storage areas.
In addition to runtime data you should also get a static analysis report of your database:
proutil dbname -C dbanalys -Bp 10 > dbname.dba
With some massaging you can take the text file produced by this command and bring it into Excel for analysis.
Topics to research (in Database Administration manual and/or KB):
Database startup parameters:
-basetable
-baseindex
-tablerangesize
-indexrangesize
VSTs:
_TableStat
_IndexStat
You can get information on which tables and indexes are accessed most frequently by writing your own code to interrogate the VSTs above, or by running Tom's free open-source utility ProTop (
http://dbappraise.com/protop.html).