Investigate High Number of Hard Parses in Oracle

By Richard Niemiec on April 21, 2013


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:

 

0808_002 0809_001

 

 

Related Posts

Leave a Reply