Re: HELP: Counting users (without database links)

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 7 Dec 1999 20:10:14 +0100
Message-ID: <944593857.17225.0.pluto.d4ee154e@news.demon.nl>

I would guess type in v$session should contain info as it is already discriminating between 'background' and 'user'

Hth,

--
Sybrand Bakker, Oracle DBA
Guy Dallaire <gdallair_at_criq.qc.ca> wrote in message news:384d5828.25146957_at_news.risq.qc.ca...
> Is there a way to easily figure out how many users are "directly"
> connected to an oracle instance ? I would like to filter out the users
> connected via database links.
>
> If I do a select from v$license, it includes the database link
> connections which I do not want.
>
> There must be a way of identifying wha are "real users" and who are
> "database links" from v$session ?
>
> TIA
> -----------------------------
> Guy Dallaire, Sysadmin/DBA
> Centre de recherche industrielle du Quebec
> Ste-Foy, QC, Canada
> http://www.criq.qc.ca
> e-mail: gdallair_at_criq.qc.ca
> ICQ: 18846092
Received on Tue Dec 07 1999 - 13:10:14 CST