Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
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
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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)