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

SELECT COUNT(*) FROM v$session;
compare it to
SHOW PARAMETER licence_max_sessions;

Good luck!
- Catherine
http://profiles.yahoo.com/arcticturtle

In article <bjb12u$mj5$1_at_news.tamu.edu>, Bing Du <bing-du_at_tamu.edu> writes:
>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
>

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net