Re: win system monitoring

From: <fitzjarrell_at_cox.net>
Date: Tue, 29 Jan 2008 12:11:02 -0800 (PST)
Message-ID: <76971679-f31f-4130-8eb4-c309f31b789e@k2g2000hse.googlegroups.com>


On Jan 29, 2:01 pm, Ben <benal..._at_yahoo.com> wrote:
> 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....- Hide quoted text -
>
> - Show quoted text -

Then I hope they find some non-invasive process to investigate this problem.

"Sometimes you're the windshield, sometimes you're the bug."

David Fitzjarrell Received on Tue Jan 29 2008 - 14:11:02 CST

Original text of this message