The DBMS_APPLICATION_INFO package registers application names with the database for auditing or performance tracking.
Privileges
No special privileges are required for the use of the DBMS_APPLICATION_INFO package. When the application registers with the database, its name and operation are recorded in the GV$OB_PROCESSLIST view.
Subprograms
The following table describes the DBMS_APPLICATION_INFO subprograms supported by the current OceanBase Database version.
| Subprogram | Description |
|---|---|
| READ_CLIENT_INFO | Reads the value of the client_info field of the current session. |
| READ_MODULE | Reads the values of the module and action fields of 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 | Renames the running module as a new module. |