Il giorno mar 22 gen 2013 21:13:58 CET, Vivien Malerba ha scritto:
On 22 January 2013 13:23, Andrea Zagli <[email protected]> wrote:
i have a program that read from a db oracle and write to a portgresql db
in oracle settings i see that i can open 900 cursors; that program reach
the maximum and it doesn't execute more queries
Can you tell me how you see that kind of information?
with this query
select * from v$parameter where name = 'open_cursors'
http://www.orafaq.com/node/758
and with
alter system set open_cursors = 5000 scope = both sid = '*'
you can increase the value
i'm pretty ignorant about oracle...
i'm quit sure that i unref every gdastatement and every gdadatamodel
what could be the problem?
Probably some bad usage of the OCI API. If you have a test case it helps a
lot, otherwise I'll have to write one myself.
i'll try to make one on the weekend
Can you file a bug report in Bugzilla, so it's easier to track bug
correction? See https://bugzilla.gnome.org/
i didn't open a bug because i didn't know if it is a libgda problem;
before open a bug i tried to ask if someone knows oracle better than me
thanks a lot
_______________________________________________
gnome-db-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnome-db-list
