Re: Determining License High Water Mark without shutdown

v$resource_limit is what you need to query.

Regards,

Talat.

Internet
Paul.Vincent_at_uce.ac.uk_at_freelists.org - 28/10/2005 09:28

Please respond to Paul.Vincent_at_uce.ac.uk

Sent by: oracle-l-bounce_at_freelists.org

To: oracle-l

cc:

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 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
(See attached file: C.htm)

This message and any attachments (the "message") is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified.

BNP Paribas Private Bank London Branch is authorised by CECEI & AMF and is regulated by the Financial Services Authority for the conduct of its investment business in the United Kingdom.

BNP Paribas Securities Services London Branch is authorised by CECEI & AMF and is regulated by the Financial Services Authority for the conduct of its investment business in the United Kingdom.   

BNP Paribas Fund Services UK Limited is authorised and regulated by the Financial Services Authority

--
http://www.freelists.org/webpage/oracle-l




text/html attachment: C.htm