SCRIPT: HOW TO IDENTIFY what packages are in the shared_pool and how many times have they been executed (Doc ID 262296.1)

Last updated on OCTOBER 06, 2010

Applies to:

Oracle Server - Enterprise Edition
Information in this document applies to any platform.
Verified script runs on 10.2 and 11g as well
Checked for relevance 8-Oct-2008

Goal

Number of times the SQL statement used within each stored object that has been executed. How to identify what packages are in the shared_pool and how many times have they been executed

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms