The DBMS_APPLICATION_INFO system package is used to register application names in the database for auditing or performance tracking.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL-compatible mode.
DBMS_APPLICATION_INFO Privilege Description
Using the DBMS_APPLICATION_INFO system package does not require any special privileges. When an application registers with the database, its name and operations are recorded in the GV$OB_PROCESSLIST view.
Overview of Subprograms
The following table lists the DBMS_APPLICATION_INFO subprograms supported by the current version of OceanBase Database and provides brief descriptions.
subprogram |
Description |
|---|---|
| READ_CLIENT_INFO | Retrieves the value of the client_info field for the current session. |
| READ_MODULE | Retrieves the values of the module and operation fields for the current session. |
| SET_ACTION | Sets the name of the current operation in the current module. |
| SET_CLIENT_INFO | Sets additional information for the client application. |
| SET_MODULE | Sets the name of the currently running module to the new module. |