How to find Max sessions ever reached by the database

[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.

[samdba]

select * from v$resource_limit

[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.

[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.

[jrpm]

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

Interesting.

[TimHall]

Sounds like you need v$license :

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

[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.

[ronnie]

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

[samdba]

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?

[patnams]

Probably you cannot find it unless you start tracking the sessions programatically.