Determining License High Water Mark without shutdown 2005-10-28 - By Goulet, Dick
Paul,
Does this help:
Linus2:9.2:GOULET> select * from v$license;
SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER
USERS_MAX
-- ---- ---- -- ---- ---- --- -- ---- ---- --- -- ---- ---- -----
-- ---- --
0 0 318 327
0
__ __
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Paul Vincent
Sent: Friday, October 28, 2005 4:29 AM
To: oracle-l@(protected)
Subject: Determining License High Water Mark without shutdown
Recently we needed to increase the PROCESSES parameter due to a major
increase in system usage. Rather than wait for a spate of reported
ORA-00020 (See ORA-00020.ora-code.com) messages, I'm keeping an eye on the "License High Water Mark"
entry in the alert log each time the instance is shut down, so I can
increase PROCESSES again if the demand starts to approach the limit
again. The problem is, this message only appears at shutdown, which
isn't very helpful. What I'd like to be able to do is, at any time, see
what the current High Water Mark is. Now, honest folks, I've RTFM'ed for
all I'm worth, but can't find the relevant system view that contains
this information. I should emphasise that I'm not looking for the
current number of sessions at a moment in time, I'm looking for the high
water mark figure since the last time the instance was started up.
Can anyone point me in the right direction, please, or let me know if
the information *can't* be determined other than at shutdown?
Thanks,
Paul Vincent
DBA
UCE Birmingham
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1515" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=602524913-28102005><FONT face=Arial
color=#0000ff size=2>Paul,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=602524913-28102005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=602524913-28102005> <FONT
face=Arial color=#0000ff size=2>Does this help:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=602524913-28102005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=602524913-28102005><FONT face=Arial
color=#0000ff size=2>Linus2:9.2:GOULET> select * from
v$license;</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV dir=ltr align=left><SPAN class=602524913-28102005><FONT face="Courier New"
color=#0000ff size=2>SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT
SESSIONS_HIGHWATER USERS_MAX<BR>-- ---- ---- -- ---- ---- ---
-- ---- ---- --- -- ---- ---- -----
-- ---- --<BR>
0
0
318
327
0</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] <B>On Behalf Of </B>Paul
Vincent<BR><B>Sent:</B> Friday, October 28, 2005 4:29 AM<BR><B>To:</B>
oracle-l@(protected)<BR><B>Subject:</B> Determining License High Water Mark
without shutdown<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=182352108-28102005><FONT face=Arial
color=#0000ff size=2>Recently we needed to increase the PROCESSES parameter due
to a major increase in system usage. Rather than wait for a spate of reported
ORA-00020 (See ORA-00020.ora-code.com) messages, I'm keeping an eye on the "License High Water Mark" entry
in
the alert log each time the instance is shut down, so I can increase PROCESSES
again if the demand starts to approach the limit again. The problem is, this
message only appears at shutdown, which isn't very helpful. What I'd like to be
able to do is, at any time, see what the current High Water Mark is. Now,
honest
folks, I've RTFM'ed for all I'm worth, but can't find the relevant system view
that contains this information. I should emphasise that I'm not looking for the
current number of sessions at a moment in time, I'm looking for the high water
mark figure since the last time the instance was started up.
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=182352108-28102005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=182352108-28102005><FONT face=Arial
color=#0000ff size=2>Can anyone point me in the right direction, please, or let
me know if the information *can't* be determined other than at
shutdown?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=182352108-28102005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=182352108-28102005><FONT face=Arial
color=#0000ff size=2>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=182352108-28102005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=182352108-28102005><FONT face=Arial
color=#0000ff size=2>Paul Vincent</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=182352108-28102005><FONT face=Arial
color=#0000ff size=2>DBA</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=182352108-28102005><FONT face=Arial
color=#0000ff size=2>UCE Birmingham</FONT></SPAN></DIV></BODY></HTML>
|
|
