Tutorial Flow:
- Determining the problem category (completed)
- Performing detailed diagnosis appropriate locking problems
- Identifying the scope of the SQL statements involved
Detailed Analysis
The detailed diagnosis of the problem suggests that a larger portion of SQL statements are
being compiled rather than retrieving their access plans from the package cache. To analyse the problem further
database administrator monitors elements for SQL compilation.
Metrics related to SQL compilation
- TOTAL_COMPILATIONS
- PKG_CACHE_INSERTS
- PKG_CACHE_LOOKUPS