drwilco

SQL> l
  1   select s.sid, s.program, count(1) from v$open_cursor c, v$session s
  2  where s.sid = c.sid and s.program like 'cni_tftp%'
  3  group by s.sid, s.program
  4*  order by 3
SQL> /

       SID PROGRAM                                            COUNT(1)
---------- ------------------------------------------------ ----------
        50 cni_tftp@vivaro (TNS V1-V3)                               1
       197 cni_tftp@meriva (TNS V1-V3)                               1
       202 cni_tftp@frontera (TNS V1-V3)                             1
       311 cni_tftp@agila (TNS V1-V3)                                1
       409 cni_tftp@zafira (TNS V1-V3)                               1
       259 cni_tftp@manta (TNS V1-V3)                                1
       288 cni_tftp@calibra (TNS V1-V3)                              2

7 rows selected.