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

Text File | 1997-01-21 | 321 b | 9 lines

rem Frequency of logical transactions ending per second

select to_char(t.timestamp_end, 'DD-MON-YY HH24:MI:SS') "Interval",
       count(*) "Frequency"
from v_192216243_f_5_e_11_7_3 t, epc_collection c
where c.collection_name = '&&cllctn' and
      c.collection_id = t.collection_number
group by timestamp_end;