Snapshot Level Database Application |
Logical Data Grouping dbase appl |
Monitor Switch Basic Basic |
Resettable |
Yes |
|
Event Type Database Connection |
Logical Data Grouping db_event conn_event |
|
Element Name Element Type |
appl_section_lookups counter |
Description: Lookups of SQL sections by an application from its SQL work area.
Usage: Each agent has access to a unique SQL work area where the working copy of any executable section is kept. In partitioned databases, this work area is shared by all non-SMP agents. In other environments and with SMP agents, each agent has its own unique SQL work area.
This counter indicates how many times the SQL work area was accessed by agents for an application. It is a cumulative total of all lookups on all SQL work heaps for agents working for this application.
You can use this element in conjunction with Section Inserts to tune the size of the heap used for the SQL work area. In partitioned databases this size is controlled by the app_ctl_heap_sz configuration parameter. SQL work area size in other database environments use the the applheapsz configuration parameter. The size of the SQL work area for SMP agents is controlled by applheapsz in all environments.