Oracle Video Server 3.0.3.1/OVS_3031_NT.iso/win32/tracesvr/otrcrpt1.sql

Text File | 1997-01-21 | 301 b | 8 lines

rem Number of SQL segment events per database session

select session_index, session_serial, count(*) "# SQL statments"
from v_192216243_f_5_e_7_7_3 e, epc_collection c
where c.collection_name = '&&cllctn' and
      c.collection_id = e.collection_number
group by session_index, session_serial;