May 17, 2000

Performance Analysis of Application by Code Profiling

Oracle8i provides a standard package, DBMS_PROFILER, which facilitates performance and code coverage analysis of your PL/SQL application. This package provides functions for gathering statistics, such as total number of times

Caching Packages on Database Startup

Oracle8i has introduced database-level and system-level triggers. They can track events in the database such as logon/logoff from a schema, startup and shutdown of a database, and response to a

Wrapping Application Code

Oracle comes with a PL/SQL wrapper, which converts the PL/SQL source code into an intermediate form of object code. By hiding application internals, the wrapper prevents the misuse of your

Avoid Multiple Exit Points in a Function

If you have a database function that has multiple return statements, try to minimize the exit points. I will explain with the following example: create or replace function getStatus(p_status_code in