Re: is it possible for an end user to know how many licences an Oracle server has?

On Fri, 05 Sep 2003 17:01:12 -0500, Bing Du <bing-du_at_tamu.edu> wrote:

>Our Oracle server has returned 'ORA-00019: maximum number of session
>licenses exceeded' pretty frequently recently. Every time, our Oracle
>DBA just killed some inactive jobs to fix the problem. This licence
>problem has affected our applications that use the Oracle. What I want
>to know is what SQL command or utility I can use as an end user to
>monitor how many licenses have been used? Therefore, if it's
>approaching the limit, we can get the DBA informed right away rather
>than waiting for the customers to report the problem to us.
>
>Thanks in advance for any help,
>
>Bing

run show parameter lic
You can set an arbitrary high water mark below the hard limit

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Sep 05 2003 - 17:12:31 CDT