Subversion Repositories XServices

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
203 brianR 1
select
2
    (select count(*)  from MEM_INBOUND) as INBOUND_Queue,
3
    (select count(*)  from  MEM_OUTBOUND) as OUTBOUND_Queue ,
4
 
5
    (select count(*)  from mem_all_events) as IN_MEMORY_LOG,
6
    (select count(*) from brutex.tbl_events_all)  as FILE_LOG,
7
    (select count(*) from brutex.tbl_events_errors)  as ERROR_COUNT,
8
 
9
    ((select count(*) from brutex.tbl_events_all where btx_supersed_id is not null) +  (select count(*) from mem_all_events where btx_supersed_id is not null)) as MERGED_EVENTS
10
FROM DUAL;