Database Analyzer Messages

The following table lists the most important Database Analyzer messages that are written to the DBAN.prt log file.

Database Analyzer: Messages
Avg User cmd exec Time for Task
Avg User Suspend Time for Task
Avg User Wait Time For Task
Catalog Cache Hit Rate
Collision Rate
Data Cache Hit Rate
Data Volume Filling Level
Deletes/Updates
Free User Tasks
Index accesses Index range accesses Isolated index accesses Isolated index range accesses Isolated index scans More information: Optimizer Strategies
Log Area Filling Level
Lock List Escalations
Log Queue Overflows
Log write time
Max Log Queue Filling
Number of Cached History Pages
Number of Physical Reads
Number of Physical Writes
Number of Physical Writes of Temporary Pages
OMS Cache Hit Rate
OMS Heap Collisions
OMS Heap Utilization
OMS History Cache Hit Rate
OMS Terminates
OMS Version is Old
OMS Version is Unloaded
Out of Memory Exceptions
Parse Activities
Physical Reads for User Task
Primary key accesses Primary key range accesses More information: Optimizer Strategies
Selects and Fetches
Table scans
User Task Blocked in State
User Task Physical Writes