I imagine it's the remote DB server that's giving you the message. Either it has a low limit (set by your user license?), or you have a lot of scripts that are tying up connections. I know this doesn't quite answer your question, but in the absense of log information, look to the information you do have.

Additionally, I'd consult with your database vendor (Oracle? MS SQL server?) about client packages they offer that might have the monitoring features you're interested in. You don't tell us what type of environment you're running under so it's impossible to even guess at a Perl recommendation. You may be able to do this by parsing DBI trace data for all of your scripts, but this is going to be pretty complex and difficult to do in real-time.


In reply to Re: DBD::ODBC and possibly OT. by Fastolfe
in thread DBD::ODBC and possibly OT. by PsychoSpunk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.