Results 1 to 2 of 2

Thread: Help with sql - monthly usage count

  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Unhappy 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!!

  2. #2
    Join Date
    Mar 2003
    Posts
    468
    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
  •