V$SESSION_CONNECT_INFO

This view displays information about network connections for the current session.

Column	Datatype	Description
`SID`	`NUMBER`	Session identifier (can be used to join this view with `V$SESSION`)
`AUTHENTICATION_TYPE`	`VARCHAR2(26)`	How the user was authenticated: `DATABASE` - Username/password authentication `OS` - Operating system external user authentication `NETWORK` - Network protocol or ANO authentication `PROXY` - OCI proxy connection authentication `SERVER` `PASSWORD` `EXTERNAL ADAPTERS` `INTERNAL` `GLOBAL` `EXTERNAL` `PASSWORD BASED GLOBAL USER`
`OSUSER`	`VARCHAR2(30)`	External username for this database user
`NETWORK_SERVICE_BANNER`	`VARCHAR2(4000)`	Product banners for each Oracle Net service used for this connection (one row per banner)