Menu
How can I find the high water mark (the historical maximum number of concurrent users) in an oracle database (9i).
578
This is a term used with table segments stored in the database. If you envision a table, for example, as a 'flat' structure or as a series of blocks laid one after the other in a line from left to right, the high-water mark (HWM) would be the rightmost block that ever contained data, as illustrated in Figure 10-1.
High water mark is the maximum amount of database blocks used so far by a segment. This mark cannot be reset by delete operations.
The High Water Mark is the maximum number of blocks which have ever contained data. Deleting records from a table frees up the space but does not move the HWM. In order to reset the High Water Mark we have to drop and recreate the table, or just truncate it.
Viewing SessionsIn SQL Developer, click Tools, then Monitor Sessions. A Sessions tab is displayed. Figure 8-1 shows part of the display. See the chapter about monitoring database operations in Oracle Database Administrator's Guide for more information.
This should do the trick:
SELECT sessions_highwater FROM v$license;
select max_utilization from v$resource_limit where resource_name = 'sessions';
A good overview of Oracle system views can be found here.
37
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
