RE: logs

I use swatch http://sourceforge.net/projects/swatch

rr

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Grant Allen Sent: Wednesday, March 01, 2006 3:14 PM
To: jsilverman_at_solucient.com
Cc: Oracle-L_at_Freelists
Subject: Re: logs

On 3/2/06, Jim Silverman <jsilverman_at_solucient.com> wrote:
>
>
>
> You could examine the listener.log, located at
> $ORACLE_HOME/network/log. I've never found anything terribly useful
> there, but it is something you could check for network-type issues.

Believe me, it can be a very handy log file. I had a client in December with Listener crash and hang issues, and this little log showed the 470000 (yes, four hundred and seventy thousand) connections that had been made that month.

We shot the developer responsible :-)

I agree with Jared - automate monitoring of this. I hear perl is useful for this, right Jared? :-P

Ciao
Fuzzy
:-)

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



This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

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