-
Help with sql - monthly usage count
Hello, I am new to sql and would like someone to help me. I am trying to create a script to manage usage\licenses
Below is a script I found but I would like to run\show by month ( last 3 months broken down by month )
script: select * From v$license;
result:
SESSIONS_MAX 0
SESSIONS_CURRENT 75
SESSIONS_HIGHWATER 96
USERS_MAX 0
Thanks!!
-
there is no history in this view.
if your license changes, you would need to take a snapshot of this view for the time periods you are interested in and then build the query around stored data.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|