Free Web Hosting by Netfirms
Web Hosting by Netfirms | Free Domain Names by Netfirms

AmZone

A m Z o n e


Sessions Highwater mark

Is it possible to find out the maximum number of concurrent sessions that would have connected to an Oracle database instance?

In other words, highwater mark of sessions.



V$LICENSE
This stores the maximum concurrent sessions that would have connected to an instance (SESSIONS_HIGHWATER).

V$SESSION will show you all users currently connected. It will not keep a highwater mark.


examples to follow


Press the Back button of you Browser to go to previous page
Home