Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: postbus@sybrandb.demon.nl (Sybrand Bakker)
Newsgroups: comp.databases.oracle.server
Subject: Re: connect protocol in views
Date: 6 Jun 2002 06:59:17 -0700
Organization: http://groups.google.com/
Lines: 16
Message-ID: <a20d28ee.0206060559.2cd3f43f@posting.google.com>
References: <adnf6d$505$1@news2.ipartners.pl>
NNTP-Posting-Host: 145.13.42.4
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1023371958 11227 127.0.0.1 (6 Jun 2002 13:59:18 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 6 Jun 2002 13:59:18 GMT
Xref: easynews comp.databases.oracle.server:149749
X-Received-Date: Thu, 06 Jun 2002 06:56:43 MST (news.easynews.com)

"roblop" <roblop@friko2.onet.pl> wrote in message news:<adnf6d$505$1@news2.ipartners.pl>...
> Oracle 8.1.7 on Solaris 10/01.
> In which view can I get information about connect protocol for all connected
> session ?
> 
> Regards, Roblop

v$session_connect_info

A select * from dict where table_name like '%CONNECT%'
would also have told you this.

Hth

Sybrand Bakker
Senior Oracle DBA