V$SESSION_CONNECT_INFO

V$SESSION_CONNECT_INFO 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)
CLIENT_CHARSET	VARCHAR2(40)	Client character set as specified in the NLS_LANG environment variable or in the OCIEnvNlsCreate() call; Unknown if the Oracle client is older than release 11.1 or the connection is through the JDBC thin driver
CLIENT_CONNECTION	VARCHAR2(13)	Client server connection flags: · Heterogeneous · Homogeneous
CLIENT_OCI_LIBRARY	VARCHAR2(27)	OCI client library: · Home-based · Full Instant Client · XE Instant Client · Light Weight Instant Client · OCI · Unknown
CLIENT_VERSION	VARCHAR2(40)	Client library version number
CLIENT_DRIVER	VARCHAR2(9)	Client driver name
CLIENT_LOBATTR	VARCHAR2(23)	Client LOB flags: · Client Temp Lob Rfc On · Client Temp Lob Rfc Off
CLIENT_REGID	NUMBER	Query cache registration ID sent by the client

Note:

1. To get view definition:

SELECT view_definition FROM v$fixed_view_definition

WHERE view_name='GV$SESSION_CONNECT_INFO';

2. Query the analytic workspaces in the database:

SELECT * FROM V$SESSION_CONNECT_INFO;

SID	AUTHENTICATION_ TYPE	OSUSER	NETWORK_SERVICE_BANNER
143	DATABASE	tomcat	TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.3.0 - Production
148	DATABASE	tomcat	TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.3.0 - Production
149	DATABASE	tomcat	TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.3.0 - Production
151	DATABASE	sde	Oracle Bequeath NT Protocol Adapter for Solaris: Version 10.2.0.3.0 - Production
151	DATABASE	sde	Oracle Advanced Security: authentication service for Solaris: Version 10.2.0.3.0 - Production
151	DATABASE	sde	Oracle Advanced Security: encryption service for Solaris: Version 10.2.0.3.0 - Production
151	DATABASE	sde	Oracle Advanced Security: crypto-checksumming service for Solaris: Version 10.2.0.3.0 - Production

Oracle data dictionary views

Oracle dynamic performance views