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.
Printable View
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.
select * from v$resource_limit
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.
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.
Thanks for the input on v$resource_limit. I looked, I thought for all MAX_ fields and it did not show up.
Interesting.
Sounds like you need v$license :
http://otn.oracle.com/docs/products/...ch377.htm#5370
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.
I am looking for the maximum number of sessions reached since the database has been created, not since the instance started.Quote:
Originally posted by TimHall
Sounds like you need v$license :
http://otn.oracle.com/docs/products/...ch377.htm#5370
Thanks
Doesn't it show MAX_UTILIZATION col?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.
Probably you cannot find it unless you start tracking the sessions programatically.