How to find Max sessions ever reached by the database

Printable View

06-13-2002, 11:14 AM
ronnie

Hi,

Is there a way where we can find the maximum number of sessions ever reached by the database.

Something like a High water mark for number of sessions.
06-13-2002, 11:23 AM
samdba

select * from v$resource_limit
06-13-2002, 11:32 AM
jrpm

If you mean during a given session, then look at the alert log after a shutdown normal. It will show max sessions. I don't know where it is stored internally.
06-13-2002, 11:36 AM
stecal

Ever reached in the current instance vs ever reached ever?

v$whatever view is only good for the current instance. Alert log, as mentioned, is an alternative.
06-13-2002, 11:38 AM
jrpm

Thanks for the input on v$resource_limit. I looked, I thought for all MAX_ fields and it did not show up.

Interesting.
06-13-2002, 11:52 AM
TimHall

Sounds like you need v$license :

http://otn.oracle.com/docs/products/...ch377.htm#5370
06-13-2002, 12:11 PM
btrigg01

You can also use auditing to audit the number of connections made take a look in the admin manual. Just make sure AUD$ doesn't get to big by deleting info that is say three months out of date from it. AUD$ is in the SYSTEM tablespace after all.

Although you can also move AUD$ to another tablespace this is supported by Oracle.
06-13-2002, 12:25 PM
ronnie

Quote:

Originally posted by TimHall
Sounds like you need v$license :

http://otn.oracle.com/docs/products/...ch377.htm#5370

I am looking for the maximum number of sessions reached since the database has been created, not since the instance started.

Thanks
06-13-2002, 12:42 PM
samdba

Quote:

Originally posted by jrpm
Thanks for the input on v$resource_limit. I looked, I thought for all MAX_ fields and it did not show up.

Interesting.

Doesn't it show MAX_UTILIZATION col?
06-13-2002, 12:55 PM
patnams

Probably you cannot find it unless you start tracking the sessions programatically.
06-13-2002, 01:27 PM
ronnie

I'm surprised about why oracle dosnt store it.
06-13-2002, 02:58 PM
jmodic

Quote:

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)....
11-04-2003, 04:40 PM
ronnie

Quote:

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
11-04-2003, 05:33 PM
marist89

What does the number of sessions have to do with named users?
11-04-2003, 05:39 PM
jmodic

Quote:

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.
11-04-2003, 06:19 PM
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
11-04-2003, 06:24 PM
jmodic

Would it? Ask Oracle why they switched from concurent sessions model to named users model few years ago....
11-04-2003, 09:45 PM
marist89

Quote:

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.
11-05-2003, 10:35 AM
ronnie

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
11-05-2003, 10:57 AM
marist89

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.