Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HELP: Counting users (without database links)

HELP: Counting users (without database links)

From: Guy Dallaire <gdallair_at_criq.qc.ca>
Date: Tue, 07 Dec 1999 18:58:20 GMT
Message-ID: <384d5828.25146957@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 - 12:58:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US