Monitoring data objects using table functions
The data object monitoring perspective provides information about operations performed on data objects, that is tables, indexes, buffer pools, table spaces, and containers.
A different set of monitor elements is available for each object type. Monitor elements for a data object are incremented each time a request involves processing that object. For example, when processing a request that involves reading rows from a particular table, the metric for rows read is incremented for that table.
These table functions return data in a relational form.
You cannot access historical data for data objects.
Data object monitor elements are collected by default for new databases. You can use the mon_obj_metrics database configuration parameter to reduce the amount of data collected by the table functions.
- No data object monitor elements are collected
- Some data object monitor elements are collected
- All data object monitor elements are collected