Performance Management
Peter F. Sørensen · The Encyclopedia of Political Science · 2011
Oracle Database 11g adds several weapons to the arsenal of the DBA looking to improve performance and scalability. Automatic native compilation of PL/SQL code means you’ll now get much faster PL/SQL performance automatically when you upgrade applications to the new release. The new server cache feature dramatically increases performance for SQL queries as well as for PL/SQL functions by retrieving results straight from the cache instead of reexecuting code. There is also a new client-side result caching feature for OCI applications.KeywordsQuery ResultExecution PlanBind VariablePrivate StatisticOracle DatabaseThese keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.