Wednesday, October 8, 2008

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