Tutorial Flow:




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