Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> HELP: Counting users (without database links)
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
![]() |
![]() |