Re: OCI and 8i

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: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Tobie Berthon" <tberthon_at_adapsys.ca> wrote in message
news:e9946f43.0301111808.31818469_at_posting.google.com...


> 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.