9.19 V$SESSION_CONNECT_INFO
V$SESSION_CONNECT_INFO
displays information about network connections for all currently logged in sessions.
Column | Datatype | Description |
---|---|---|
|
|
Session identifier (can be used to join this view with |
|
|
Session serial number. Used to uniquely identify a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID. (Can be used to join this view with |
|
|
How the user was authenticated:
|
|
|
External username for this database user |
|
|
Product banners for each Oracle Net service used for this connection (one row per banner) |
|
|
Client character set as specified in the |
|
|
Client server connection flags:
|
|
|
OCI client library:
|
|
|
Client library version number |
|
|
Client driver name |
|
|
Client LOB flags:
|
|
|
Query cache registration ID sent by the client |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also: