The DBMS_SESSION system package provides access to the ALTER SESSION SQL statement and other session information from PL. You can use DBMS_SESSION to set the client identifier.
DBMS_SESSION Privilege Description
The DBMS_SESSION system package calls user privileges, and does not require SYS privileges.
Overview of DBMS_SESSION Subprograms
The following table lists the DBMS_SESSION subprograms supported by the current version of OceanBase Database and provides brief descriptions.
subprogram |
Description |
|---|---|
| SET_IDENTIFIER | Sets the client ID in the session. |
| CLEAR_IDENTIFIER | Clear the identifier. |