1. ProTop Knowledge Base
  2. Advanced Alerting Configuration

Show Table, Indexes and LOB Ranges (T)

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

  1. The green lines at the top are the current values used when the database is started.
  2. The following three lines in black show the current limits based on those current startup values.
  3. Actual application numbers of tables, indexes, and LOBs, and if any are unmonitored, and the amount of excess range, if any.
  4. Suggested basic startup values to cover application entities only.
  5. System entity high and low values. You should monitor them as well;  many applications read them.
  6. The orange lines at the bottom represent the suggested complete database startup parameters, which cover both application and system entity high and low values.
  7. 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