SID

NUMBER

Session identifier (can be used to join this view with V$SESSION)

AUTHENTICATION_TYPE

VARCHAR2(15)

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

OSUSER

VARCHAR2(30)

The external username for this database user

NETWORK_SERVICE_BANNER

VARCHAR2(2000)

Product banners for each Net8 service used for this connection (one row per banner)