Re: win system monitoring

From: Ben <benalvey_at_yahoo.com>
Date: Tue, 29 Jan 2008 12:01:34 -0800 (PST)
Message-ID: <78007dcf-29df-46a5-8f34-b661d7b368f0@l32g2000hse.googlegroups.com>


On Jan 29, 2:59 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Jan 29, 1:24 pm, Ben <benal..._at_yahoo.com> wrote:
>
>
>
>
>
> > 10.2.0.2 AIX5.2 64bit Ent Ed is our database system in question.
>
> > We have an application that keeps crashing periodically and can't seem
> > to find the issue to address. It is a vendor package so we don't
> > control the logging or the actual fixing of the issues. I have pretty
> > much ruled out a database issue but would like to be able to totally
> > rule it out. The only other specific problem that I could see is the
> > fact that most all of the sql that is ran against that database uses
> > literals. Is it possible that connections would get killed off due to
> > shared pooled memory issues? I would think if we had major issues
> > there would be some various ora- errors related to shared pool memory.
> > I never have any errors in the alert log though.
>
> > I've supspected it is a hardware or network issue, but don't really
> > have the means of monitoring that side of the system. Anyone know of a
> > way to determine if anything bad is going on with the network or
> > hardware? I've setup some pings to see if we ever lose connection to
> > that server and they don't reveal any issues.
>
> > I've also thought it might be related to the post I made titled "the
> > opposite of DCD (dead connection detection)??" but I've tested that
> > and it doesn't seem to be an issue with connections from win servers.
>
> Client tracing might reveal something normal pings don't.  You can
> enable this via the sqlnet.ora file.  Read here:
>
> http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/apxtblsh...
>
> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

I did think of that and just asked about enabling it, unfortunately they don't want the overhead.... Received on Tue Jan 29 2008 - 14:01:34 CST

Original text of this message