The DBMS_APPLICATION_INFO package registers application names with the database for auditing or performance tracking purposes.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
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. |