Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
Como monitorear las tablas MFQUEUE en Oracle Retail
select 'CODES_MFQUEUE' COLA, count(1) ENCOLADOS from CODES_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'RUA_MFQUEUE' COLA, count(1) ENCOLADOS from RUA_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'BANNER_MFQUEUE' COLA, count(1) ENCOLADOS from BANNER_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'ITEM_MFQUEUE' COLA, count(1) ENCOLADOS from ITEM_MFQUEUE I WHERE PUB_STATUS = 'U' AND I.APPROVE_IND = 'Y' union all
select 'SEEDOBJ_MFQUEUE' COLA, count(1) ENCOLADOS from SEEDOBJ_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'WH_MFQUEUE' COLA, count(1) ENCOLADOS from WH_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'STORE_MFQUEUE' COLA, count(1) ENCOLADOS from STORE_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'SUPPLIER_MFQUEUE' COLA, count(1) ENCOLADOS from SUPPLIER_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'TSF_MFQUEUE' COLA, count(1) ENCOLADOS from TSF_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'PARTNER_MFQUEUE' COLA, count(1) ENCOLADOS from PARTNER_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'DIFFGRP_MFQUEUE' COLA, count(1) ENCOLADOS from DIFFGRP_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'WOOUT_MFQUEUE' COLA, count(1) ENCOLADOS from WOOUT_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'ITEMLOC_MFQUEUE' COLA, count(1) ENCOLADOS from ITEMLOC_MFQUEUE Q WHERE Q.PUB_STATUS = 'U'
AND NOT EXISTS (SELECT 'X' FROM ITEM_PUB_INFO IPI WHERE IPI.ITEM = Q.ITEM AND IPI.PUBLISHED = 'N' AND ROWNUM = 1) union all
select 'MERCHHIER_MFQUEUE' COLA, count(1) ENCOLADOS from MERCHHIER_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'WOIN_MFQUEUE' COLA, count(1) ENCOLADOS from WOIN_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'DIFFID_MFQUEUE' COLA, count(1) ENCOLADOS from DIFFID_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'UDA_MFQUEUE' COLA, count(1) ENCOLADOS from UDA_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'DELIVERY_SLOT_MFQUEUE' COLA, count(1) ENCOLADOS from DELIVERY_SLOT_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'ORDER_MFQUEUE' COLA, count(1) ENCOLADOS from ORDER_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'ALLOC_MFQUEUE' COLA, count(1) ENCOLADOS from ALLOC_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'NB_EMERGENCYPRICE_MFQUEUE' COLA, count(1) ENCOLADOS from NB_EMERGENCYPRICE_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'RTVREQ_MFQUEUE' COLA, count(1) ENCOLADOS from RTVREQ_MFQUEUE WHERE PUB_STATUS = 'U'
order by 2 desc,1 ASC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment