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)