Re: Ora 1000 - Questions

From: <slniemann_at_my-dejanews.com>
Date: Mon, 16 Nov 1998 19:55:15 GMT
Message-ID: <72pvv3$qu$1@nnrp1.dejanews.com>

David,

You state that it only happens at certain times. What are these times? Does this then sometimes work? How does he call the app? Is it in a loop/contain a loop?

I'd first check the code calling the application if this only occurs sometimes. It sounds like, IMHO, the application is getting called in some sort of loop, possibly infinite...

S Niemann

In article <01be0d8e$8fb6edc0$12f21cac_at_dspaisman>, "David Spaisman" <david.spaisman_at_compaq.com> wrote:
> One of the developers here is using the JDBC client on a Java application
> running on Oracle 8.0.4.
>
> At certain times, he receives an ORA 1000 error. We tried resetting open
> cursors higher and then setting closed_cached_open_cursors to true from its
> default of false didn't help. We also raised the sort_area_size from 64k to
> 512k but that didn't do any good. Also, v$open_cursors shows only one
> open cursor. ORacle offered the abpve suggestions but none of the
> suggestions have helped
>
> Does any one have suggestions how to eliminate the ORA 100 error?
>
> Thanks.
>
> Dave
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 16 1998 - 13:55:15 CST