How to find Max sessions ever reached by the database - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 20 of 20

Thread: How to find Max sessions ever reached by the database

  1. #11
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    I'm surprised about why oracle dosnt store it.
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #12
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by ronnie
    I'm surprised about why oracle dosnt store it.
    Why would it? For what purpose?

    As Tim pointed out, for the life of the instance it is recorded in V$LICENCE.

    If you wan't it to span over instance restarts simply create BEFORE SHUTTDOWN trigger and store tha value in your own table.

    This, however, will not record it in the cases when instance terminates as a result of a failure (shutdown abort or instance crash)....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #13
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Originally posted by jmodic
    Why would it? For what purpose?

    As Tim pointed out, for the life of the instance it is recorded in V$LICENCE.

    If you wan't it to span over instance restarts simply create BEFORE SHUTTDOWN trigger and store tha value in your own table.

    This, however, will not record it in the cases when instance terminates as a result of a failure (shutdown abort or instance crash)....

    Well the Purpose can be to find out whether the user is compliant with the licenses in case of a software audit.

    If the oracle customer has licenses based on names user and if for somereason has a software audit then this is where they can find out the max sessions ever reached.

    Please correct me if I am wrong.

    Thanks
    Ron
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  4. #14
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    What does the number of sessions have to do with named users?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #15
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by ronnie
    Please correct me if I am wrong.
    Yes, you are wrong.

    If the customer has licensed based on named users, maximum concurent sessions reached during the lifetime of the database can tell absolutely nothing wether the customer is compliant with his licence agreement or not.

    Suppose I have 50 named users licenses for my system. Now I can have 51, 100, 250, 1000 (or whatever number you want) of concurent sessions on my database and still I'm totaly within limits of my license, as long as all those concurent sessions were created by those 50 named users.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #16
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Hi,

    Would it be fair if the license be based on the no. of
    concurrent sessions rather than named users or schema ids?


    Thanks

  7. #17
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Would it? Ask Oracle why they switched from concurent sessions model to named users model few years ago....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  8. #18
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by kris123
    Hi,

    Would it be fair if the license be based on the no. of
    concurrent sessions rather than named users or schema ids?


    Thanks
    Would it be more fair, yes. Would it result in more revenue for Oracle, no.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #19
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Si this means that if I have 50 users (schemas) created in my database i need to have a names user license for 50 even though only 10 of them use the database at any given time.

    Also what about thoase people who purchased a concurrent user license few years back and now oracle doesnt have concurrent liceneses. Do we need to switch to named users or we can continue concurrent user license.

    Thanks
    Ron
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  10. #20
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    number of schemas has nothing to do with named users. You could have 200 schemas and only 10 named users (ala Oracle Apps).

    Your specific licensing questions should be addressed by your legal department or your Oracle Sales weasel.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width