Re: [gnome-db] "maximum cursors opened" in oracle

[Andrea Zagli <azagli libero it>]

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