Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E25513-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$SESSION_CONNECT_INFO

V$SESSION_CONNECT_INFO displays information about network connections for all currently logged in sessions.

Column Datatype Description
SID NUMBER Session identifier (can be used to join this view with V$SESSION)
SERIAL# NUMBER Session serial number. Used to uniquely identify a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID. (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