Re: OCI and 8i

From: Jim Kennedy <>
Date: Sun, 12 Jan 2003 04:44:28 GMT
Message-ID: <Mo6U9.32712$%n.9757_at_sccrnsc02>

Rewritting them in C isn't going to make a difference. OCI is a C interface to Oracle so rewriting them in C isn't changing anything. I think the problem lies somewhere else. See what statements are being executed and see what that is doing. I don;t think the interface itself is the problem. Jim

Replace part of the email address:
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Tobie Berthon" <> wrote in message

> Hi All,
> I have a problem that has been causing us a fair bit of trouble
> and I was hoping someone might have a solution. We migrated to 8i
> (8.1.7) a couple of months ago and things have been running great for
> the most part. However, every once in a while, the server (AIX 4.3.3)
> freezes up solid on us and has to be restarted. The one pattern that
> we have noticed is that the only jobs that cause the server to freeze
> up are batch jobs that contain OCI. We only have a handful of jobs
> that use OCI and they seem to be a real problem. Besides rewriting the
> code in C, does anyone have any ideas for things that we can try?
> Thanks in advance.
Received on Sun Jan 12 2003 - 05:44:28 CET

Original text of this message