Programming Languages White Papers
VERITAS DBMS Technical Brief: Using Oracle DBMS_SESSION and DBMS_APPPLICATION_INFO Built-In Packages
Overview Each new release of Oracle adds to the already rich set of built-in packages as a standard part of PL/SQL functionality. DBAs and developers can benefit greatly from using packages, but a lack of time or other job pressures often prevents them from exploring the value and employing packages on a regular basis. The Oracle PL/SQL built-in packages (a.k.a. the DBMS packages) are a virtual treasure trove of useful and powerful constructs that can greatly enhance the quality and value of any PL/SQL programming effort. Understanding the Oracle built-in packages is critical to developing proficiency and productivity in PL/SQL programming. Two of these built-in packages, DBMS_SESSION and DBMS_APPLICATION_INFO, are particularly useful for setting session parameters and monitoring performance and resource utilization.
| Publisher | Symantec | File Format | |
|---|---|---|---|
| Date Published | May 2004 | ||
| Format | White Papers | ||
| Topics | |||



