Snapshot Information Level Database Application |
API Structure(s) sqlm_dbase sqlm_appl |
Monitor Group Basic Basic |
Resettable |
Yes |
|
Event Information Level Database Connection |
API Structure(s) sqlm_db_event sqlm_conn_event |
|
API Element Name Element Type |
appl_section_lookups counter |
Description: Lookups of SQL sections by an application from its SQL work area.
Usage: The executable sections generated for dynamic and static SQL statements are placed in the database package cache when they are created, and remain there until they become invalid or the space is required for another section. Each section is cached at a database level and can be shared among agents.
An application control heap is required to share information between agents working on behalf of the same application. One heap is allocated for each partition on which the application is active.
You can use this element in conjunction with Section Inserts to tune the size of the heap. In partitioned databases heap size is controlled by the app_ctl_heap_sz configuration parameter. Whereas, heap size in other database environments use the the applheapsz configuration parameter.
[ Top of Page | Table of Contents | Glossary | Index ]