win system monitoring

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. Received on Tue Jan 29 2008 - 13:24:48 CST