Re: win system monitoring

On Jan 29, 3:11 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

my thoughts exactly. Received on Tue Jan 29 2008 - 14:13:07 CST