Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 137 of 179


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(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) 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index