Created
January 23, 2016 05:48
-
-
Save arbo-hacker/b54b6382f0c043def08b to your computer and use it in GitHub Desktop.
Como monitorear las tablas MFQUEUE en Oracle Retail
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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