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

From: Thomas Jeff <jeff.thomas_at_thomson.net>
Date: Wed, 23 Jul 2003 09:43:04 -0500
Message-Id: <25998.339134@fatcity.com>

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

---

Received on Wed Jul 23 2003 - 09:43:04 CDT