-
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.
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
select * from v$resource_limit
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
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.
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
-
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.
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
-
-
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.
Thanks
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
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?
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
Probably you cannot find it unless you start tracking the sessions programatically.
Sridhar R Patnam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|