shared pool, bind variables, cursors optimization
716430Aug 9 2009 — edited Aug 9 2009" Your shared pool maybe filled with non-reusable SQL with 93.06% memory usage. The Oracle shared pool contains Oracle´s library cache, which is responsible for collecting, parsing, interpreting, and executing all of the SQL statements that go against the Oracle database. You can check the dba_hist_librarycache table in Oracle10g to see your historical library cache RAM usage.
can you help me understand the concept of bind variables, cursors, cursor sharing etc briefly?
Is there a query to find out problematic sql? pl/sql? with bind variables, cursor sharing issues, reparsed etc
What additions can make it reusable?
how to find sql,pl sql that were reloaded, reparsed?
is there a query to check the dba_hist_librarycache table in Oracle10g to see your historical library cache RAM usage.
how to determine the optimal sizing of library cache?
How to find out if sql/.pl sql pinning in memory will be helpful? what sq/pl sql can benefit from it?is there a query?