 |
|
PL/SQL Performance Tips
Oracle Tips by Burleson Consulting
|
Brian Carr
has offered some valuable information that users can use if
you have a popular PL/SQL package:
Pinning popular packages in shared memory:
You can pin the popular packages in shared memory pool by using
DBMS_SHARED_POOL. When you pin a package it is not aged out by the least
recently used (LRU) algorithm that Oracle uses. It will remain in memory.
For declared (but unused variables) in your PL/SQL code:
PL/SQL waits to allocate memory until you assign the variable, then only
allocates as much storage as needed. So no need to worry about consuming
memory.
Identifying bottlenecks:
PL/SQL provides a Profiler API to identify run-time behavior and to help you
find performance bottlenecks. It's the DBMS_PROFILER PL/SQL
Package.
You can read more about this package at:
http://www.dba-oracle.com/t_plsql_dbms_profiler.htm
