application problems

10.2.0.2 Ent Ed AIX 5.2 64 bit

We have a vendor app that we recently upgraded and in turn moved it from SQLServer to an Oracle database environment. All was well for about a month then we started seeing random application failures. I've looked at everything I know to look at in the database and don't see any kind of indication that it is something within the database causing the issues. In my opinion the app wasn't written well for an Oracle db to begin with, they don't use any bind variables. It is a fairly small (600M) oltp type of application but does have quite a few transactions. The SGA is about 600M total and I haven't seen any errors in the alert log to make me think that we are hitting any kind of memory errors related to SQL cursors using up all the sga, or core dumps, or anything for that matter to make me think there should be an issue. The parse percentages are ridiculously bad, but even with that I don't see extreme waits related to parse times.

Wouldn't I be seeing alert log errors if something in the sga was a miss and causing client side problems?

Their client side logging is pretty lack luster as well, just cryptic ole errors. Received on Mon Feb 11 2008 - 10:51:25 CST