Il giorno mer 23 gen 2013 08:37:43 CET, Andrea Zagli ha scritto:
[...]
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
try to exec a query inside gda-browser and then in another oracle
client (for example tora) try to monitor cursors with the following
statement
select sum(a.value) total_cur, avg(a.value) avg_cur, max(a.value) max_cur,
s.username, s.machine
from v$sesstat a, v$statname b, v$session s
where a.statistic# = b.statistic# and s.sid=a.sid
and b.name = 'opened cursors current'
group by s.username, s.machine
order by 1 desc;
then click execute in gda-browse several times (same query): you will
see that re-executing query for cursors monitoring the value increase
whenever you click
i'm using instant client 10.2.0.5; under windows mingw/msys; libgda 4.2.x
_______________________________________________
gnome-db-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnome-db-list
