This content has been marked as final. Show 4 replies
The Oracle system supplied V$SESSION view will show you all CURRENT connections to your database. There will be one row per connection.
So if you have 3 DBA's and 10 users all connected view the same logon, then you'd still see 13 user connections to your database, along with the oracle background processes as well..
For all licensing questions, you really, really, really want to consult the paperwork your organization has, your Oracle sales rep, and whoever manages compliance for your licenses. If there is ever an audit, saying that you relied on advice from some guy on the internet with a playing card logo next to his name is a career limiting statement. Nothing that is said in this forum is binding.
Assuming you are talking about named user licenses (Oracle used to sell concurrent user licenses and there are a few organizations that still have concurrent user licenses that they haven't converted to the more modern licensing schemes), you would need to add up the total number of humans that can access the data in the database (plus any automated systems but it doesn't sound like we're considering any of those). So you would take the 3 DBA users and then add in all the humans that have accounts that would allow them to access the application hosted on the app servers. If you have 6 application servers and those app servers are keeping 60 sessions open in their connection pools, I would expect that there are far more than 60 humans that have the ability to use those applications. So I would expect that you would need far more than 63 named user licenses.