Re: How to tell if a given session is coming across a db link?

Hi!

I would look at program column in v$session... it should show oracle or something similar there if the connection is initiated by another Oracle server.

Tanel.
----- Original Message -----
From: "Thomas Jeff" <jeff.thomas_at_thomson.net> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, July 23, 2003 6:39 PM
Subject: How to tell if a given session is coming across a db link?

> I have a task to pull v$session info from various databases and insert
into
> a history table.
> I'd like to exclude those sessions that are connected to a database via a
db
> link.
> Is there an easy way to identify such sessions?
>
>
> Thanks.
>
> --------------------------------------------
> Jeffery D Thomas
> DBA
> Thomson Information Services
> Thomson, Inc.
>
> Email: jeff.thomas_at_thomson.net
>
> Indy DBA Master Documentation available at:
> http://gkmqp.tce.com/tis_dba
> --------------------------------------------
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Thomas Jeff
> INET: jeff.thomas_at_thomson.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jul 23 2003 - 09:56:56 CDT