You should review similar queries with low numbers of executions to uncover opportunities to combine them into statements using bind variables. A high ratio of hard parses may mean that the shared pool itself is too small or perhaps a SQL statement is repeatedly nudging other code out of the precious shared pool or Java pool cache space.
Identify these statements and consider pinning. Consider also setting the parameter CURSOR_SHARING = FORCE. The next listing shows various queries to view parse activity:
Leave a Reply