ProTop 328 now includes LOB base and range sizes.
Table, Index and now, LOB Range Information (T)
Meaning of the contents above (red numbered dots):
- The green lines at the top are the current values used when the database is started.
- The following three lines in black show the current limits based on those current startup values.
- Actual application numbers of tables, indexes, and LOBs, and if any are unmonitored, and the amount of excess range, if any.
- Suggested basic startup values to cover application entities only.
- System entity high and low values. You should monitor them as well; many applications read them.
- The orange lines at the bottom represent the suggested complete database startup parameters, which cover both application and system entity high and low values.
- NEW - The right-hand column contains the values for the LOBs in your database.
NOTE: The last line of the Insight section on the right provides the explicit path to the example parameter file, which contains the suggested settings. The contents look something like this:
# suggested table, index and LOB statistics settings for /db/s2k128/s2k
#
# basic (excludes system tables, some system indexes and LOB fields)
# -basetable 1
# -tablerangesize 75
# -baseindex 8
# -indexrangesize 104
# -baselob 1
# -lobrangesize 5
# complete (includes system tables)
-basetable -361
-tablerangesize 436
-baseindex -1692
-indexrangesize 2835
-baselob 1
-lobrangesize 10