tailieunhanh - Oracle Built−in Packages- P76

Oracle Built−in Packages- P76: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | 7. Defining an Application Profile Contents Getting Started with DBMS_APPLICATION_INFO DBMS_APPLICATION_INFO Interface DBMS_APPLICATION_INFO Examples The DBMS_APPLICATION_INFO package provides procedures that allow applications to register their current execution status with the Oracle database. Once registered information about the status of an application can be monitored externally through several of the V virtual tables. DBMS_APPLICATION_INFO is used to develop applications that can be monitored in various ways including the following Module usage where do users spend their time in the application Resource accounting by transaction and module End-user tracking and resource accounting in three-tier architectures Incremental recording of long-running process statistics When applications register themselves using DBMS_APPLICATION_INFO DBAs and developers are able to analyze their performance and resource consumption much more closely. This facilitates better application tuning and enables more accurate usage-based cost accounting. WARNING Oracle explicitly warns that DBMS_APPLICATION_INFO should not be used in Trusted Oracle databases. Getting Started with DBMS_APPLICATION_INFO In Oracle the DBMS_APPLICATION_INFO package is created when the Oracle database is installed. The script found in the built-in packages source code directory as described in Chapter 1 Introduction contains the source code for this package s specification. In Oracle the script also found in the source code directory creates the package. In either case the scripts are called by which is normally run immediately after database creation. The script creates the public synonym DBMS_APPLICATION_INFO for the package and grants EXECUTE privilege on the package to public. All Oracle users can reference and make use of this package. DBMS_APPLICATION_INFO Programs Table lists the programs available from DBMS_APPLICATION_INFO. Table .