Question:
How do I determine how many licenses have been installed on an Oracle system? Is there a stored procedure I can run or a table I can exmaine?
Answer:
You can check the V$LICENSE view. To set the max # of sessions, you'll want to adjust the license_max_sessions and license_sessions_warning parameters.
HTH,
Brian