SQL Id | SQL Text |
0c9272hgmxrdy | select f_sale_price from product_sale_price where f_product_id=:product_id and F_PRICE_BM='ECBJ' |
0gn6g291nvc8u | SELECT MAX(a.f_inventory_amount - a.f_out_amount - a.f_sale_amount - a.f_shatter_amount) FROM inventory a WHERE a.f_product_id=:product_id |
0w18y2bj06rq3 | begin package_page.proc_page(p_tablename=>:p_tablename, p_tablecolumn=>:p_tablecolumn, p_pagesize=>:p_pagesize, p_curpage=>:p_curpage, p_order=>:p_order, p_where=>:p_where, p_rowcount=>:p_rowcount, p_pagecount=>:p_pagecount, p_cursor=>:p_cursor); end; |
0z64k20dy8zut | select brandname from sw_brand where id = :brandId |
168ybx4zj6bw2 | select * from sw_PRODUCTS_TYPE where ID=:ID |
1k4432m7yzh52 |
SELECT SPT.ID, SPT.TYPENAME, SUM(CASE WHEN SP.ID IS NULL THEN 0 ELSE 1 END) PROD_NOR_CNT, SUM(CASE WHEN SP_TH.ID IS NULL THEN 0 ELSE 1 END) PROD_TH_CNT FROM SW_PRODUCTS_TYPE SPT LEFT JOIN(SELECT SP.TYPEID, SP.ID FROM SW_PRODUCTS SP WHERE SP.ISONSALE=1 AND SP.SDELL=0 AND (((((((((((((((UPPER(SP.PRODUCTSNAME) LIKE '%空气断路器%' OR UPPER(SP.CONTENT) LIKE '%空气断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%空气断路器%' OR UPPER(SP.SEOKEYS) LIKE '%空气断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%框架式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%框架式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%框架式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%框架式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型断路器%' OR UPPER(SP.CONTENT) LIKE '%微型断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型断路器%' OR UPPER(SP.SEOKEYS) LIKE '%微型断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型隔离开关%' OR UPPER(SP.CONTENT) LIKE '%微型隔离开关%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型隔离开关%' OR UPPER(SP.SEOKEYS) LIKE '%微型隔离开关%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%小型断路器附件%' OR UPPER(SP.CONTENT) LIKE '%小型断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%小型断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%小型断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳配电保护%' OR UPPER(SP.CONTENT) LIKE
'%塑壳配电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳配电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳配电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳电动机保护%' OR UPPER(
SP.CONTENT) LIKE '%塑壳电动机保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳电动机保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳电动机保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器附件%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器本体%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器本体%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器本体%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器本体%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳漏电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳漏电保护%'))) )SP ON SP.TYPEID=SPT.ID LEFT JOIN(SELECT SP.TYPEID, SP.ID FROM SW_PRODUCTS SP WHERE SP.TH_PROD_ONSALE=1 AND SP.SDELL=0 AND (((((((((((((((UPPER(SP.PRODUCTSNAME) LIKE '%空气断路器%' OR UPPER(SP.CONTENT) LIKE '%空气断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%空气断路器%' OR UPPER(SP.SEOKEYS) LIKE '%空气断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%框架式负荷隔离%' OR UPPER(SP.CONTENT
) LIKE '%框架式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%框架式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%框架式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型断路器%' OR UPPER(SP.CONTENT) LIKE '%微型断
路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型断路器%' OR UPPER(SP.SEOKEYS) LIKE '%微型断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型隔离开关%' OR UPPER(SP.CONTENT) LIKE '%微型隔离开关%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型隔离开关%' OR UPPER(SP.SEOKEYS) LIKE '%微型隔离开关%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%小型断路器附件%' OR UPPER(SP.CONTENT) LIKE '%小型断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%小型断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%小型断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳配电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳配电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳配电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳配电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳电动机保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳电动机保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳电动机保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳电动机保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器附件%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器本体%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器本体%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器本体%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器本体%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑
壳式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT)
LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳漏电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳漏电保护%'))) )SP_TH ON SP_TH.TYPEID=SPT.ID AND SP.ID=SP_TH.ID GROUP BY SPT.ID, SPT.TYPENAME ORDER BY SPT.ID |
1nfbydjcv21k4 | SELECT T1.TYPENAME, T1.Id, T2.NUM FROM sw_products_type T1, (SELECT typeid, COUNT(*) AS NUM FROM vw_products WHERE ISONSALE=1 and SDELL=0 and brandid=81GROUP BY typeid) T2 WHERE T1.Id=T2.typeid |
3am9cfkvx7gq1 | CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values) |
3dhrg4hrbgk69 | /* SQL Analyze(73, 1) */ select count(id) from (SELECT * from vw_products m inner join SW_PRODUCTS_TEMP n on m.id=n.productsid) where ISONSALE=1 and SDELL=0 and TYPEID=265 and brandid=85 and seriesid=1461 and ATTR_404='1094' |
3j1x4pd50mfpb | /* SQL Analyze(73, 1) */ select * from (select id, productsname, typeId, productsid, unit, seriesid, pic, typename, brandname, seriesPrice, F_SALE_PRICE, PRODUCTSPRICE, isonsale, ISNEW, ISRECOMMONDL, ISSPECIALOFFER, ISHOT, stock, MINNUM, weight, sdell from v_products_all_list_stock where 1=1 and SDELL=0 and typeid in (select ID from sw_products_type t where t.pid in (select ID from sw_products_type t where t.pid=5)) order by ID DESC) where rownum<=10 |
3ppbwcr995f1x | SELECT T1.TYPENAME, T1.Id, T2.NUM FROM sw_products_type T1, (SELECT typeid, COUNT(*) AS NUM FROM vw_products WHERE ISONSALE=1 and SDELL=0 and brandid=85GROUP BY typeid) T2 WHERE T1.Id=T2.typeid |
3sq8sqw641nta | begin PRO_EC_IIS_LOG_MONI(p_ret=>:p_ret, p_msg=>:p_msg, p_cur=>:p_cur); end; |
3zqmg3y6vprtb | select b.attrname as 属性名称, a.avalue as 属性值 from SW_PRODUCTS_ATTR a inner join sw_attr b on a.aid=b.id where productsid=:ID
and a.aid in (select distinct(a.attrid) from sw_bas a inner join
(select typeid, seriesid from sw_products where id=:ID) b on a.typeid=b.typeid and a.seriesid=b.seriesid) ORDER BY f_Sortorder ASC |
40046a8b6vs4d |
SELECT SB.ID, SB.BRANDNAME, SUM(CASE WHEN SP.ID IS NULL THEN 0 ELSE 1 END) PROD_NOR_CNT, SUM(CASE WHEN SP_TH.ID IS NULL THEN 0 ELSE 1 END) PROD_TH_CNT FROM SW_BRAND SB LEFT JOIN(SELECT SP.BRANDID, SP.ID FROM SW_PRODUCTS SP WHERE SP.ISONSALE=1 AND SP.SDELL=0 AND (((((((((((((((UPPER(SP.PRODUCTSNAME) LIKE '%空气断路器%' OR UPPER(SP.CONTENT) LIKE '%空气断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%空气断路器%' OR UPPER(SP.SEOKEYS) LIKE '%空气断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%框架式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%框架式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%框架式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%框架式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型断路器%' OR UPPER(SP.CONTENT) LIKE '%微型断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型断路器%' OR UPPER(SP.SEOKEYS) LIKE '%微型断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型隔离开关%' OR UPPER(SP.CONTENT) LIKE '%微型隔离开关%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型隔离开关%' OR UPPER(SP.SEOKEYS) LIKE '%微型隔离开关%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%小型断路器附件%' OR UPPER(SP.CONTENT) LIKE '%小型断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%小型断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%小型断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳配电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳配
电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳配电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳配电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳电动机保护%' OR UPPER(SP.CONTEN
T) LIKE '%塑壳电动机保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳电动机保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳电动机保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器附件%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器本体%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器本体%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器本体%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器本体%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳漏电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳漏电保护%'))) )SP ON SP.BRANDID=SB.ID LEFT JOIN(SELECT SP.BRANDID, SP.ID FROM SW_PRODUCTS SP WHERE SP.TH_PROD_ONSALE=1 AND SP.SDELL=0 AND (((((((((((((((UPPER(SP.PRODUCTSNAME) LIKE '%空气断路器%' OR UPPER(SP.CONTENT) LIKE '%空气断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%空气断路器%' OR UPPER(SP.SEOKEYS) LIKE '%空气断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%框架式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '
%框架式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%框架式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%框架式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型断路器%' OR UPPER(SP.CONTENT) LIKE '%微型断路器%' OR
UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型断路器%' OR UPPER(SP.SEOKEYS) LIKE '%微型断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型隔离开关%' OR UPPER(SP.CONTENT) LIKE '%微型隔离开关%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型隔离开关%' OR UPPER(SP.SEOKEYS) LIKE '%微型隔离开关%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%小型断路器附件%' OR UPPER(SP.CONTENT) LIKE '%小型断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%小型断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%小型断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳配电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳配电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳配电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳配电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳电动机保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳电动机保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳电动机保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳电动机保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器附件%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器本体%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器本体%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器本体%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器本体%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳式负荷隔
离%' OR UPPER(SP.CONTENT) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%
微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳漏电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳漏电保护%'))) )SP_TH ON SP_TH.BRANDID=SB.ID AND SP.ID=SP_TH.ID GROUP BY SB.ID, SB.BRANDNAME ORDER BY SB.ID |
43ruajmwv9fus | insert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue)values(:1, :2, :3, :4, :5, :6, :7) |
4y1y43113gv8f | delete from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 |
5b9n551qcguc1 | select * from sw_Cart where 1!=1 |
5myvzcwq9kc1b |
SELECT * FROM (SELECT ROWNUM rn, a.* FROM (SELECT t1.cnt+t2.cnt as cnt FROM( SELECT COUNT(1) cnt FROM SW_PRODUCTS SP JOIN SW_PRODUCTS_TYPE SPT ON SP.TYPEID=SPT.ID JOIN SW_BRAND SB ON SP.BRANDID=SB.ID JOIN SW_SERIES SS ON SS.ID=SP.SERIESID WHERE 1=1 AND SP.ISONSALE=1 AND SP.SDELL=0 AND (((((((((((((((UPPER(SP.PRODUCTSNAME) LIKE '%空气断路器%' OR UPPER(SP.CONTENT) LIKE '%空气断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%空气断路器%' OR UPPER(SP.SEOKEYS) LIKE '%空气断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%框架式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%框架式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%框架式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%框架式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型断路器%' OR UPPER(SP.CONTENT) LIKE '%微型断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型断路器%' OR UPPER(SP.SEOKEYS) LIKE '%微型断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型隔离开关%' OR UPPER(SP.CONTENT) LIKE '%微型隔离开关%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型隔离开关%' OR UPPER(SP.SEOKEYS) LIKE '%微型隔离开关%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%小型断路器附件%' OR UPPER(SP.CONTENT) LIKE '%小型断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%小型断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%小型断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳配电保护%' OR UPPER(SP
.CONTENT) LIKE '%塑壳配电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳配电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳配电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳电动
机保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳电动机保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳电动机保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳电动机保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器附件%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器本体%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器本体%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器本体%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器本体%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳漏电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳漏电保护%'))) ) t1, ( SELECT COUNT(1) cnt FROM SW_PRODUCTS SP JOIN SW_PRODUCTS_TYPE SPT ON SP.TYPEID=SPT.ID JOIN SW_BRAND SB ON SP.BRANDID=SB.ID JOIN SW_SERIES SS ON SS.ID=SP.SERIESID WHERE 1=1 AND SP.TH_PROD_ONSALE=1 AND SP.SDELL=0 AND (((((((((((((((UPPER(SP.PRODUCTSNAME) LIKE '%空气断路器%' OR UPPER(SP.CONTENT) LIKE '%空气断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%空气断
路器%' OR UPPER(SP.SEOKEYS) LIKE '%空气断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%框架式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%框架式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%框架式负荷隔离
%' OR UPPER(SP.SEOKEYS) LIKE '%框架式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型断路器%' OR UPPER(SP.CONTENT) LIKE '%微型断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型断路器%' OR UPPER(SP.SEOKEYS) LIKE '%微型断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型隔离开关%' OR UPPER(SP.CONTENT) LIKE '%微型隔离开关%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型隔离开关%' OR UPPER(SP.SEOKEYS) LIKE '%微型隔离开关%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%小型断路器附件%' OR UPPER(SP.CONTENT) LIKE '%小型断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%小型断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%小型断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳配电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳配电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳配电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳配电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳电动机保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳电动机保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳电动机保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳电动机保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器附件%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器本体%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器本体%' OR UPPER
(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器本体%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器本体%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE
'%塑壳式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳漏电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳漏电保护%'))) ) t2) a WHERE ROWNUM <=20) WHERE rn >= 1 |
5qv7r97puku65 | SELECT T1.TYPENAME, T1.Id, T2.NUM FROM sw_products_type T1, (SELECT typeid, COUNT(*) AS NUM FROM vw_products WHERE ISONSALE=1 and SDELL=0 and brandid=84GROUP BY typeid) T2 WHERE T1.Id=T2.typeid |
625rn54ngknu6 | select psp.f_sale_price from zyd.product_sale_price psp where psp.f_price_bm =:priceType and psp.f_product_id =:product_sid |
63rtmgkxf3gfk | select count(*) from sw_Info where InfoIsDisplay='1' and columnid in(1, 2, 3, 9, 10, 11) |
6crb2ju7y6zvu | select * from (select * from sw_Info where InfoIsDisplay='1' and columnid in(1, 2, 3, 9, 10, 11) order by InfoOrders asc, InfoIsTop desc, InfoDateTime desc) where rownum<=10 |
6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
7mdacxfm37utk | SELECT COUNT(*) FROM MGMT_FAILOVER_TABLE WHERE SYS_EXTRACT_UTC(SYSTIMESTAMP)-LAST_TIME_STAMP_UTC > NUMTODSINTERVAL(HEARTBEAT_INTERVAL*:B1 , 'SECOND') |
7mgr3uwydqq8j | select decode(open_mode, 'MOUNTED', 0,
'READ WRITE', 1,
'READ ONLY', 1,
'READ ONLY WITH APPLY', 1,
2) dbstate
into :dbstate
from v$database |
8szmwam7fysa3 | insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE')) |
8vwv6hx92ymmm | UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1 |
abam683fqr6b2 | select * from (select * from sw_Info where InfoIsDisplay='1' and columnid in(1, 2, 3, 9, 10, 11) order by InfoDateTime desc) where rownum<=10 |
b6fwkg2dxr1t3 | select b.pmt_goodsdiscount, b.pmt_goodsdiscountproductids from vw_product_acrivity b |
c0j6cx9kzjf7g | SELECT EXTRACTVALUE(VALUE(T), '/select_list_item/pos') + 1 POS, EXTRACTVALUE(VALUE(T), '/select_list_item/value') RES, EXTRACTVALUE(VALUE(T), '/select_list_item/nonnulls') NONNULLS, EXTRACTVALUE(VALUE(T), '/select_list_item/ndv') NDV, EXTRACTVALUE(VALUE(T), '/select_list_item/split') SPLIT, EXTRACTVALUE(VALUE(T), '/select_list_item/rsize') RSIZE, EXTRACTVALUE(VALUE(T), '/select_list_item/rowcnt') ROWCNT, EXTRACT(VALUE(T), '/select_list_item/hash_val').GETCLOBVAL() HASHVAL FROM TABLE(XMLSEQUENCE(EXTRACT(:B1 , '/process_result/select_list_item'))) T |
cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
dcssauxd5hhtf | SELECT T1.TYPENAME, T1.Id, T2.NUM FROM sw_products_type T1, (SELECT typeid, COUNT(*) AS NUM FROM vw_products WHERE ISONSALE=1 and SDELL=0 and (UPPER(productsname) like UPPER('%断路器%') or UPPER(CONTENT) like UPPER('%断路器%') or UPPER(SEOKEYS) like UPPER('%断路器%'))GROUP BY typeid) T2 WHERE T1.Id=T2.typeid |
dymnwp8k35qs7 | SELECT COUNT(1) FROM (SELECT DISTINCT T.USERAGENT FROM IIS.SW_PAGE_VIEW_LOG T WHERE 1 = 1 AND T.CLIENTHOST = :B3 AND T.LOGTIME BETWEEN :B2 AND :B1 ) |
f75asf6dp7u2y | select count(id) from (SELECT * from vw_products m inner join SW_PRODUCTS_TEMP n on m.id=n.productsid) where ISONSALE=1 and SDELL=0 and brandid=84 and typeid =54 |
fa5n395tn6pza | select * from sw_PRODUCTS where ID=:ID |
fdjtrdaz8hpvg |
INSERT /*+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, machine, port, ecid , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.
flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.delta_write_io_requests)), decode(a.delta_time, 0, to_number(null),
decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y') |
fy3c2z3n3v17d | /* SQL Analyze(73, 1) */ SELECT B.ID, B.PRODUCTSNAME, B.PRODUCTSPRICE, B. PRODUCTSID, B.TYPEID, B.PIC, B.PRODUCTSNO, B.SHORTCONTENT, B.typeid FROM (SELECT ROWNUM ROWNO, A.* FROM (SELECT m.* from (select a.*, nvl(b.f_sale_price, '0') as f_sale_price from vw_products a left join Product_Sale_Price b on a.Productsid=b.f_product_id and b.f_price_bm='ECBJ') m inner join SW_PRODUCTS_TEMP n on m.id=n.productsid where 1=1 and ISONSALE=1 and SDELL=0 and TYPEID=265 and brandid=85 and seriesid=1461 and ATTR_404='1094' order by ORDERS desc , addtime desc )A )B WHERE (B.ROWNO > (1 -1 ) * 24 AND B.ROWNO <= 1 * 24) OR 1 IS NULL |
g1zrcv11nstpd | select spt.typename, sb.brandname from sw_products sp , sw_products_type spt , sw_brand sb where 1=1 and sp.id=:ID and sp.typeid=spt.id and sp.brandid=sb.id |
gauspxfd79xbj | select * from sw_SERIES where ID=:ID |
ghpzw5mg1ys8c | select count(id) from (SELECT * from vw_products m inner join SW_PRODUCTS_TEMP n on m.id=n.productsid) where ISONSALE=1 and SDELL=0 and brandid=85 and typeid =265 |
gjm43un5cy843 | SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME) |
gyy3zhvk0sufp | SELECT T1.TYPENAME, T1.Id, T2.NUM FROM sw_products_type T1, (SELECT typeid, COUNT(*) AS NUM FROM vw_products WHERE ISONSALE=1 and SDELL=0 and (UPPER(productsname) like UPPER('%接触器%') or UPPER(CONTENT) like UPPER('%接触器%') or UPPER(SEOKEYS) like UPPER('%接触器%'))GROUP BY typeid) T2 WHERE T1.Id=T2.typeid |
Statistic | Total | per Second | per Trans |
Batched IO (bound) vector count | 0 | 0.00 | 0.00 |
Batched IO (full) vector count | 0 | 0.00 | 0.00 |
Batched IO block miss count | 0 | 0.00 | 0.00 |
Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
Batched IO double miss count | 0 | 0.00 | 0.00 |
Batched IO same unit count | 0 | 0.00 | 0.00 |
Batched IO single block count | 0 | 0.00 | 0.00 |
Batched IO slow jump count | 0 | 0.00 | 0.00 |
Batched IO vector block count | 0 | 0.00 | 0.00 |
Batched IO vector read count | 0 | 0.00 | 0.00 |
Block Cleanout Optim referenced | 104 | 0.03 | 0.01 |
CCursor + sql area evicted | 82 | 0.02 | 0.01 |
CPU used by this session | 1,007,266 | 278.59 | 124.63 |
CPU used when call started | 945,356 | 261.47 | 116.97 |
CR blocks created | 134 | 0.04 | 0.02 |
Cached Commit SCN referenced | 11,777 | 3.26 | 1.46 |
Commit SCN cached | 90 | 0.02 | 0.01 |
DB time | 11,289,459 | 3,122.44 | 1,396.86 |
DBWR checkpoint buffers written | 7,702 | 2.13 | 0.95 |
DBWR checkpoints | 5 | 0.00 | 0.00 |
DBWR object drop buffers written | 64 | 0.02 | 0.01 |
DBWR parallel query checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
DBWR tablespace checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR transaction table writes | 144 | 0.04 | 0.02 |
DBWR undo block writes | 3,826 | 1.06 | 0.47 |
DFO trees parallelized | 0 | 0.00 | 0.00 |
HSC Heap Segment Block Changes | 85,824 | 23.74 | 10.62 |
HSC IDL Compressed Blocks | 1,799 | 0.50 | 0.22 |
Heap Segment Array Inserts | 856 | 0.24 | 0.11 |
Heap Segment Array Updates | 361 | 0.10 | 0.04 |
IMU CR rollbacks | 0 | 0.00 | 0.00 |
IMU Flushes | 0 | 0.00 | 0.00 |
IMU Redo allocation size | 0 | 0.00 | 0.00 |
IMU commits | 0 | 0.00 | 0.00 |
IMU contention | 0 | 0.00 | 0.00 |
IMU ktichg flush | 0 | 0.00 | 0.00 |
IMU pool not allocated | 8,886 | 2.46 | 1.10 |
IMU recursive-transaction flush | 0 | 0.00 | 0.00 |
IMU undo allocation size | 0 | 0.00 | 0.00 |
IMU- failed to get a private strand | 8,886 | 2.46 | 1.10 |
LOB table id lookup cache misses | 1 | 0.00 | 0.00 |
Number of read IOs issued | 337,380 | 93.31 | 41.74 |
PX local messages recv'd | 0 | 0.00 | 0.00 |
PX local messages sent | 0 | 0.00 | 0.00 |
Parallel operations downgraded 1 to 25 pct | 0 | 0.00 | 0.00 |
Parallel operations downgraded 25 to 50 pct | 0 | 0.00 | 0.00 |
Parallel operations downgraded 50 to 75 pct | 0 | 0.00 | 0.00 |
Parallel operations not downgraded | 0 | 0.00 | 0.00 |
RowCR - row contention | 0 | 0.00 | 0.00 |
RowCR attempts | 120 | 0.03 | 0.01 |
RowCR hits | 120 | 0.03 | 0.01 |
SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
SMON posted for undo segment shrink | 9 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 663,956 | 183.64 | 82.15 |
SQL*Net roundtrips to/from dblink | 90 | 0.02 | 0.01 |
TBS Extension: tasks created | 0 | 0.00 | 0.00 |
TBS Extension: tasks executed | 0 | 0.00 | 0.00 |
active txn count during cleanout | 974 | 0.27 | 0.12 |
application wait time | 2 | 0.00 | 0.00 |
background checkpoints completed | 3 | 0.00 | 0.00 |
background checkpoints started | 3 | 0.00 | 0.00 |
background timeouts | 13,028 | 3.60 | 1.61 |
branch node splits | 2 | 0.00 | 0.00 |
buffer is not pinned count | 29,404,010 | 8,132.57 | 3,638.21 |
buffer is pinned count | 47,417,100 | 13,114.63 | 5,867.00 |
bytes received via SQL*Net from client | 365,987,005 | 101,224.78 | 45,284.21 |
bytes received via SQL*Net from dblink | 49,390 | 13.66 | 6.11 |
bytes sent via SQL*Net to client | 854,433,643 | 236,319.48 | 105,720.57 |
bytes sent via SQL*Net to dblink | 37,678 | 10.42 | 4.66 |
calls to get snapshot scn: kcmgss | 1,319,741 | 365.01 | 163.29 |
calls to kcmgas | 32,377 | 8.95 | 4.01 |
calls to kcmgcs | 149,750 | 41.42 | 18.53 |
cell physical IO interconnect bytes | 7,145,505,280 | 1,976,305.72 | 884,125.87 |
change write time | 908 | 0.25 | 0.11 |
cleanout - number of ktugct calls | 52,465 | 14.51 | 6.49 |
cleanouts and rollbacks - consistent read gets | 41 | 0.01 | 0.01 |
cleanouts only - consistent read gets | 51,417 | 14.22 | 6.36 |
cluster key scan block gets | 53,353 | 14.76 | 6.60 |
cluster key scans | 34,964 | 9.67 | 4.33 |
commit batch performed | 128 | 0.04 | 0.02 |
commit batch requested | 128 | 0.04 | 0.02 |
commit batch/immediate performed | 140 | 0.04 | 0.02 |
commit batch/immediate requested | 140 | 0.04 | 0.02 |
commit cleanout failures: block lost | 80 | 0.02 | 0.01 |
commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 168 | 0.05 | 0.02 |
commit cleanout failures: cannot pin | 0 | 0.00 | 0.00 |
commit cleanouts | 31,674 | 8.76 | 3.92 |
commit cleanouts successfully completed | 31,426 | 8.69 | 3.89 |
commit immediate performed | 12 | 0.00 | 0.00 |
commit immediate requested | 12 | 0.00 | 0.00 |
commit nowait performed | 122 | 0.03 | 0.02 |
commit nowait requested | 122 | 0.03 | 0.02 |
commit txn count during cleanout | 52,299 | 14.46 | 6.47 |
commit wait/nowait performed | 122 | 0.03 | 0.02 |
commit wait/nowait requested | 122 | 0.03 | 0.02 |
concurrency wait time | 9,211,901 | 2,547.83 | 1,139.80 |
consistent changes | 6,999 | 1.94 | 0.87 |
consistent gets | 64,582,397 | 17,862.22 | 7,990.89 |
consistent gets - examination | 4,427,400 | 1,224.53 | 547.81 |
consistent gets direct | 337,554 | 93.36 | 41.77 |
consistent gets from cache | 64,244,842 | 17,768.86 | 7,949.13 |
consistent gets from cache (fastpath) | 59,047,041 | 16,331.25 | 7,305.99 |
cursor authentications | 1,331 | 0.37 | 0.16 |
data blocks consistent reads - undo records applied | 324 | 0.09 | 0.04 |
db block changes | 457,313 | 126.48 | 56.58 |
db block gets | 423,813 | 117.22 | 52.44 |
db block gets direct | 3,848 | 1.06 | 0.48 |
db block gets from cache | 419,965 | 116.15 | 51.96 |
db block gets from cache (fastpath) | 102,055 | 28.23 | 12.63 |
deferred (CURRENT) block cleanout applications | 16,863 | 4.66 | 2.09 |
dirty buffers inspected | 40,506 | 11.20 | 5.01 |
enqueue conversions | 1,655 | 0.46 | 0.20 |
enqueue releases | 71,111 | 19.67 | 8.80 |
enqueue requests | 71,147 | 19.68 | 8.80 |
enqueue timeouts | 3 | 0.00 | 0.00 |
enqueue waits | 9 | 0.00 | 0.00 |
exchange deadlocks | 0 | 0.00 | 0.00 |
execute count | 237,783 | 65.77 | 29.42 |
failed probes on index block reclamation | 2 | 0.00 | 0.00 |
file io service time | 0 | 0.00 | 0.00 |
file io wait time | 886,234,458 | 245,114.96 | 109,655.34 |
free buffer inspected | 442,954 | 122.51 | 54.81 |
free buffer requested | 442,364 | 122.35 | 54.73 |
heap block compress | 883 | 0.24 | 0.11 |
hot buffers moved to head of LRU | 48,725 | 13.48 | 6.03 |
immediate (CR) block cleanout applications | 51,458 | 14.23 | 6.37 |
immediate (CURRENT) block cleanout applications | 5,733 | 1.59 | 0.71 |
index crx upgrade (positioned) | 56,999 | 15.76 | 7.05 |
index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
index fast full scans (direct read) | 0 | 0.00 | 0.00 |
index fast full scans (full) | 4,525 | 1.25 | 0.56 |
index fast full scans (rowid ranges) | 0 | 0.00 | 0.00 |
index fetch by key | 4,506,030 | 1,246.28 | 557.54 |
index scans kdiixs1 | 4,463,548 | 1,234.53 | 552.28 |
leaf node 90-10 splits | 143 | 0.04 | 0.02 |
leaf node splits | 459 | 0.13 | 0.06 |
lob reads | 340,515 | 94.18 | 42.13 |
lob writes | 3,498 | 0.97 | 0.43 |
lob writes unaligned | 3,498 | 0.97 | 0.43 |
logons cumulative | 237 | 0.07 | 0.03 |
max cf enq hold time | 2,621 | 0.72 | 0.32 |
messages received | 17,880 | 4.95 | 2.21 |
messages sent | 17,880 | 4.95 | 2.21 |
min active SCN optimization applied on CR | 2 | 0.00 | 0.00 |
no buffer to keep pinned count | 0 | 0.00 | 0.00 |
no work - consistent read gets | 59,503,187 | 16,457.41 | 7,362.43 |
non-idle wait count | 1,530,801 | 423.39 | 189.41 |
non-idle wait time | 9,756,403 | 2,698.43 | 1,207.18 |
opened cursors cumulative | 224,333 | 62.05 | 27.76 |
parse count (describe) | 20 | 0.01 | 0.00 |
parse count (failures) | 641 | 0.18 | 0.08 |
parse count (hard) | 12,581 | 3.48 | 1.56 |
parse count (total) | 175,182 | 48.45 | 21.68 |
parse time cpu | 54,873 | 15.18 | 6.79 |
parse time elapsed | 69,693 | 19.28 | 8.62 |
physical read IO requests | 435,958 | 120.58 | 53.94 |
physical read bytes | 6,326,091,776 | 1,749,672.12 | 782,738.40 |
physical read total IO requests | 445,751 | 123.29 | 55.15 |
physical read total bytes | 6,486,625,280 | 1,794,072.52 | 802,601.49 |
physical read total multi block requests | 8,922 | 2.47 | 1.10 |
physical reads | 772,228 | 213.58 | 95.55 |
physical reads cache | 434,610 | 120.20 | 53.78 |
physical reads cache prefetch | 336,166 | 92.98 | 41.59 |
physical reads direct | 337,618 | 93.38 | 41.77 |
physical reads direct (lob) | 337,488 | 93.34 | 41.76 |
physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 11,594 | 3.21 | 1.43 |
physical write bytes | 547,954,688 | 151,553.45 | 67,799.39 |
physical write total IO requests | 23,914 | 6.61 | 2.96 |
physical write total bytes | 658,880,000 | 182,233.20 | 81,524.38 |
physical write total multi block requests | 2,321 | 0.64 | 0.29 |
physical writes | 66,889 | 18.50 | 8.28 |
physical writes direct | 3,908 | 1.08 | 0.48 |
physical writes direct (lob) | 72 | 0.02 | 0.01 |
physical writes direct temporary tablespace | 742 | 0.21 | 0.09 |
physical writes from cache | 62,981 | 17.42 | 7.79 |
physical writes non checkpoint | 61,611 | 17.04 | 7.62 |
pinned buffers inspected | 6 | 0.00 | 0.00 |
pinned cursors current | 20 | 0.01 | 0.00 |
prefetch clients - default | 0 | 0.00 | 0.00 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 14,154 | 3.91 | 1.75 |
process last non-idle time | 3,606 | 1.00 | 0.45 |
queries parallelized | 0 | 0.00 | 0.00 |
recovery blocks read | 0 | 0.00 | 0.00 |
recursive calls | 732,905 | 202.71 | 90.68 |
recursive cpu usage | 86,431 | 23.91 | 10.69 |
redo blocks checksummed by FG (exclusive) | 26,215 | 7.25 | 3.24 |
redo blocks read for recovery | 0 | 0.00 | 0.00 |
redo blocks written | 144,757 | 40.04 | 17.91 |
redo buffer allocation retries | 0 | 0.00 | 0.00 |
redo entries | 261,768 | 72.40 | 32.39 |
redo k-bytes read for recovery | 0 | 0.00 | 0.00 |
redo k-bytes read total | 0 | 0.00 | 0.00 |
redo log space requests | 0 | 0.00 | 0.00 |
redo log space wait time | 0 | 0.00 | 0.00 |
redo ordering marks | 3,398 | 0.94 | 0.42 |
redo size | 69,334,208 | 19,176.47 | 8,578.84 |
redo size for direct writes | 10,612 | 2.94 | 1.31 |
redo subscn max counts | 57,591 | 15.93 | 7.13 |
redo synch time | 9,619 | 2.66 | 1.19 |
redo synch writes | 7,062 | 1.95 | 0.87 |
redo wastage | 1,927,676 | 533.16 | 238.51 |
redo write time | 695 | 0.19 | 0.09 |
redo writes | 10,050 | 2.78 | 1.24 |
rollback changes - undo records applied | 23 | 0.01 | 0.00 |
rollbacks only - consistent read gets | 93 | 0.03 | 0.01 |
root node splits | 0 | 0.00 | 0.00 |
rows fetched via callback | 249,500 | 69.01 | 30.87 |
scheduler wait time | 362,568 | 100.28 | 44.86 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 162,543 | 44.96 | 20.11 |
session logical reads | 65,006,270 | 17,979.45 | 8,043.34 |
shared hash latch upgrades - no wait | 113,616 | 31.42 | 14.06 |
shared hash latch upgrades - wait | 71 | 0.02 | 0.01 |
sorts (disk) | 0 | 0.00 | 0.00 |
sorts (memory) | 31,939 | 8.83 | 3.95 |
sorts (rows) | 26,800,546 | 7,412.50 | 3,316.08 |
sql area evicted | 11,900 | 3.29 | 1.47 |
sql area purged | 684 | 0.19 | 0.08 |
summed dirty queue length | 320,273 | 88.58 | 39.63 |
switch current to new buffer | 2,657 | 0.73 | 0.33 |
table fetch by rowid | 29,945,130 | 8,282.23 | 3,705.16 |
table fetch continued row | 3,103,865 | 858.47 | 384.05 |
table scan blocks gotten | 33,689,170 | 9,317.76 | 4,168.42 |
table scan rows gotten | 410,645,221 | 113,576.36 | 50,809.85 |
table scans (direct read) | 0 | 0.00 | 0.00 |
table scans (long tables) | 13 | 0.00 | 0.00 |
table scans (rowid ranges) | 0 | 0.00 | 0.00 |
table scans (short tables) | 32,308 | 8.94 | 4.00 |
temp space allocated (bytes) | 1,048,576 | 290.02 | 129.74 |
total cf enq hold time | 6,660 | 1.84 | 0.82 |
total number of cf enq holders | 53 | 0.01 | 0.01 |
total number of times SMON posted | 9 | 0.00 | 0.00 |
transaction rollbacks | 18 | 0.00 | 0.00 |
transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
undo change vector size | 22,903,512 | 6,334.66 | 2,833.89 |
user I/O wait time | 75,907 | 20.99 | 9.39 |
user calls | 803,591 | 222.26 | 99.43 |
user commits | 8,079 | 2.23 | 1.00 |
user rollbacks | 3 | 0.00 | 0.00 |
workarea executions - multipass | 0 | 0.00 | 0.00 |
workarea executions - onepass | 0 | 0.00 | 0.00 |
workarea executions - optimal | 36,963 | 10.22 | 4.57 |
write clones created in background | 0 | 0.00 | 0.00 |
write clones created in foreground | 15 | 0.00 | 0.00 |
Latch Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct NoWait Miss |
AQ deq hash table latch | 1 | 0.00 | | 0 | 0 | |
ASM db client latch | 2,360 | 0.00 | | 0 | 0 | |
ASM map operation hash table | 1 | 0.00 | | 0 | 0 | |
ASM network state latch | 62 | 0.00 | | 0 | 0 | |
AWR Alerted Metric Element list | 28,741 | 0.00 | | 0 | 0 | |
Change Notification Hash table latch | 1,207 | 0.00 | | 0 | 0 | |
Consistent RBA | 10,057 | 0.00 | | 0 | 0 | |
DML lock allocation | 28,697 | 0.00 | | 0 | 0 | |
Event Group Locks | 163 | 0.00 | | 0 | 0 | |
FOB s.o list latch | 1,127 | 0.00 | | 0 | 0 | |
File State Object Pool Parent Latch | 1 | 0.00 | | 0 | 0 | |
IPC stats buffer allocation latch | 1 | 0.00 | | 0 | 0 | |
In memory undo latch | 1 | 0.00 | | 0 | 8,885 | 0.01 |
JS Sh mem access | 9 | 11.11 | 1.00 | 0 | 0 | |
JS mem alloc latch | 19 | 0.00 | | 0 | 0 | |
JS queue access latch | 20 | 0.00 | | 0 | 0 | |
JS queue state obj latch | 25,792 | 0.00 | | 0 | 0 | |
KFC FX Hash Latch | 1 | 0.00 | | 0 | 0 | |
KFC Hash Latch | 1 | 0.00 | | 0 | 0 | |
KFCL LE Freelist | 1 | 0.00 | | 0 | 0 | |
KGNFS-NFS:SHM structure | 1 | 0.00 | | 0 | 0 | |
KGNFS-NFS:SVR LIST | 1 | 0.00 | | 0 | 0 | |
KJC message pool free list | 1 | 0.00 | | 0 | 0 | |
KJCT flow control latch | 1 | 0.00 | | 0 | 0 | |
KMG MMAN ready and startup request latch | 1,043 | 0.00 | | 0 | 0 | |
KTF sga latch | 18 | 0.00 | | 0 | 960 | 0.00 |
KWQMN job cache list latch | 3 | 0.00 | | 0 | 0 | |
KWQP Prop Status | 452 | 0.00 | | 0 | 0 | |
KWQS pqsubs latch | 4 | 0.00 | | 0 | 0 | |
KWQS pqueue ctx latch | 75 | 0.00 | | 0 | 0 | |
Locator state objects pool parent latch | 1 | 0.00 | | 0 | 0 | |
Lsod array latch | 1 | 0.00 | | 0 | 0 | |
MQL Tracking Latch | 0 | | | 0 | 72 | 0.00 |
Memory Management Latch | 1 | 0.00 | | 0 | 1,043 | 0.00 |
Memory Queue | 456 | 0.00 | | 0 | 0 | |
Memory Queue Message Subscriber #1 | 1 | 0.00 | | 0 | 0 | |
Memory Queue Message Subscriber #2 | 1 | 0.00 | | 0 | 0 | |
Memory Queue Message Subscriber #3 | 1 | 0.00 | | 0 | 0 | |
Memory Queue Message Subscriber #4 | 1 | 0.00 | | 0 | 0 | |
Memory Queue Subscriber | 1 | 0.00 | | 0 | 0 | |
MinActiveScn Latch | 20 | 0.00 | | 0 | 0 | |
Mutex | 1 | 0.00 | | 0 | 0 | |
Mutex Stats | 1 | 0.00 | | 0 | 0 | |
OS process | 952 | 0.00 | | 0 | 0 | |
OS process allocation | 1,712 | 0.00 | | 0 | 0 | |
OS process: request allocation | 281 | 0.00 | | 0 | 0 | |
PL/SQL warning settings | 8,136 | 0.00 | | 0 | 0 | |
PX hash array latch | 1 | 0.00 | | 0 | 0 | |
QMT | 1 | 0.00 | | 0 | 0 | |
Real-time plan statistics latch | 3,513 | 0.00 | | 0 | 0 | |
SGA IO buffer pool latch | 30,850 | 0.00 | 0.00 | 0 | 30,856 | 0.00 |
SGA blob parent | 1 | 0.00 | | 0 | 0 | |
SGA bucket locks | 1 | 0.00 | | 0 | 0 | |
SGA heap locks | 1 | 0.00 | | 0 | 0 | |
SGA pool locks | 1 | 0.00 | | 0 | 0 | |
SQL memory manager latch | 1 | 0.00 | | 0 | 923 | 0.00 |
SQL memory manager workarea list latch | 100,229 | 0.00 | | 0 | 0 | |
Shared B-Tree | 3,006 | 0.00 | | 0 | 0 | |
Streams Generic | 229 | 0.00 | | 0 | 0 | |
Testing | 1 | 0.00 | | 0 | 0 | |
Token Manager | 1 | 0.00 | | 0 | 0 | |
WCR: sync | 1 | 0.00 | | 0 | 0 | |
Write State Object Pool Parent Latch | 1 | 0.00 | | 0 | 0 | |
X$KSFQP | 1 | 0.00 | | 0 | 0 | |
XDB NFS Security Latch | 1 | 0.00 | | 0 | 0 | |
XDB unused session pool | 1 | 0.00 | | 0 | 0 | |
XDB used session pool | 1 | 0.00 | | 0 | 0 | |
active checkpoint queue latch | 7,899 | 0.00 | | 0 | 0 | |
active service list | 8,207 | 0.00 | | 0 | 2,398 | 0.00 |
begin backup scn array | 199 | 0.00 | | 0 | 0 | |
bq:time manger info latch | 128 | 0.00 | | 0 | 0 | |
buffer pool | 1 | 0.00 | | 0 | 0 | |
bufq statistics | 456 | 0.00 | | 0 | 0 | |
business card | 1 | 0.00 | | 0 | 0 | |
cache buffer handles | 29,050 | 0.01 | 0.00 | 0 | 0 | |
cache buffers chains | 126,639,112 | 0.14 | 0.00 | 1 | 2,013,883 | 0.00 |
cache buffers lru chain | 79,098 | 0.07 | 0.00 | 0 | 2,097,675 | 0.01 |
cache table scan latch | 0 | | | 0 | 30,031 | 0.00 |
call allocation | 4,263 | 0.00 | | 0 | 0 | |
cas latch | 1 | 0.00 | | 0 | 0 | |
change notification client cache latch | 1 | 0.00 | | 0 | 0 | |
channel handle pool latch | 313 | 0.00 | | 0 | 0 | |
channel operations parent latch | 18,525 | 0.00 | | 0 | 0 | |
checkpoint queue latch | 387,366 | 0.00 | 0.00 | 0 | 61,209 | 0.00 |
client/application info | 2,174 | 0.00 | | 0 | 0 | |
compile environment latch | 237 | 0.00 | | 0 | 0 | |
corrupted undo seg latch | 87 | 0.00 | | 0 | 0 | |
cp cmon/server latch | 1 | 0.00 | | 0 | 0 | |
cp pool latch | 1 | 0.00 | | 0 | 0 | |
cp server hash latch | 1 | 0.00 | | 0 | 0 | |
cp sga latch | 62 | 0.00 | | 0 | 0 | |
cvmap freelist lock | 1 | 0.00 | | 0 | 0 | |
deferred cleanup latch | 62 | 0.00 | | 0 | 0 | |
dml lock allocation | 66 | 0.00 | | 0 | 0 | |
done queue latch | 1 | 0.00 | | 0 | 0 | |
dummy allocation | 432 | 0.00 | | 0 | 0 | |
enqueue hash chains | 143,873 | 0.01 | 0.00 | 0 | 0 | |
enqueues | 89,877 | 0.05 | 0.00 | 0 | 0 | |
fifth spare latch | 1 | 0.00 | | 0 | 0 | |
file cache latch | 649 | 0.00 | | 0 | 0 | |
flashback copy | 1 | 0.00 | | 0 | 0 | |
gc element | 1 | 0.00 | | 0 | 0 | |
gcs commit scn state | 1 | 0.00 | | 0 | 0 | |
gcs partitioned table hash | 1 | 0.00 | | 0 | 0 | |
gcs pcm hashed value bucket hash | 1 | 0.00 | | 0 | 0 | |
gcs resource freelist | 1 | 0.00 | | 0 | 0 | |
gcs resource hash | 1 | 0.00 | | 0 | 0 | |
gcs resource scan list | 1 | 0.00 | | 0 | 0 | |
gcs shadows freelist | 1 | 0.00 | | 0 | 0 | |
ges domain table | 1 | 0.00 | | 0 | 0 | |
ges enqueue table freelist | 1 | 0.00 | | 0 | 0 | |
ges group table | 1 | 0.00 | | 0 | 0 | |
ges process hash list | 1 | 0.00 | | 0 | 0 | |
ges process parent latch | 1 | 0.00 | | 0 | 0 | |
ges resource hash list | 1 | 0.00 | | 0 | 0 | |
ges resource scan list | 1 | 0.00 | | 0 | 0 | |
ges resource table freelist | 1 | 0.00 | | 0 | 0 | |
ges value block free list | 1 | 0.00 | | 0 | 0 | |
global KZLD latch for mem in SGA | 63 | 0.00 | | 0 | 0 | |
global tx hash mapping | 37 | 0.00 | | 0 | 0 | |
granule operation | 1 | 0.00 | | 0 | 0 | |
hash table column usage latch | 541 | 0.18 | 0.00 | 0 | 17,368,257 | 0.03 |
hash table modification latch | 96 | 0.00 | | 0 | 0 | |
heartbeat check | 1 | 0.00 | | 0 | 0 | |
internal temp table object number allocation latch | 24 | 0.00 | | 0 | 0 | |
intra txn parallel recovery | 1 | 0.00 | | 0 | 0 | |
io pool granule metadata list | 1 | 0.00 | | 0 | 0 | |
job workq parent latch | 73 | 0.00 | | 0 | 72 | 1.39 |
job_queue_processes free list latch | 153 | 0.00 | | 0 | 0 | |
job_queue_processes parameter latch | 843 | 0.00 | | 0 | 0 | |
k2q lock allocation | 1 | 0.00 | | 0 | 0 | |
kcbtsemkid latch | 3 | 0.00 | | 0 | 0 | |
kdlx hb parent latch | 1 | 0.00 | | 0 | 0 | |
kgb parent | 1 | 0.00 | | 0 | 0 | |
kks stats | 75,248 | 0.06 | 0.00 | 0 | 0 | |
kokc descriptor allocation latch | 1,027 | 0.00 | | 0 | 0 | |
ksfv messages | 1 | 0.00 | | 0 | 0 | |
kss move lock | 41 | 0.00 | | 0 | 0 | |
ksuosstats global area | 245 | 0.00 | | 0 | 0 | |
ksv allocation latch | 142 | 0.00 | | 0 | 0 | |
ksv class latch | 81 | 0.00 | | 0 | 0 | |
ksv msg queue latch | 1 | 0.00 | | 0 | 0 | |
ksz_so allocation latch | 281 | 0.00 | | 0 | 0 | |
ktm global data | 36 | 0.00 | | 0 | 0 | |
kwqbsn:qsga | 2,213 | 0.00 | | 0 | 0 | |
lgwr LWN SCN | 10,455 | 0.38 | 0.00 | 0 | 0 | |
list of block allocation | 623 | 0.00 | | 0 | 0 | |
loader state object freelist | 638,930 | 0.27 | 0.01 | 0 | 0 | |
lob segment dispenser latch | 1 | 0.00 | | 0 | 0 | |
lob segment hash table latch | 13 | 0.00 | | 0 | 0 | |
lob segment query latch | 1 | 0.00 | | 0 | 0 | |
lock DBA buffer during media recovery | 1 | 0.00 | | 0 | 0 | |
logical standby cache | 1 | 0.00 | | 0 | 0 | |
logminer context allocation | 2 | 0.00 | | 0 | 0 | |
logminer work area | 1 | 0.00 | | 0 | 0 | |
longop free list parent | 230 | 0.00 | | 0 | 156 | 0.00 |
mapped buffers lru chain | 1 | 0.00 | | 0 | 0 | |
message pool operations parent latch | 760 | 0.00 | | 0 | 0 | |
messages | 92,229 | 0.10 | 0.00 | 0 | 0 | |
mostly latch-free SCN | 10,431 | 0.36 | 0.08 | 0 | 0 | |
msg queue latch | 1 | 0.00 | | 0 | 0 | |
multiblock read objects | 105,970 | 0.00 | | 0 | 0 | |
name-service namespace bucket | 1 | 0.00 | | 0 | 0 | |
ncodef allocation latch | 62 | 0.00 | | 0 | 0 | |
object queue header heap | 65,984 | 0.00 | | 0 | 2,418 | 0.00 |
object queue header operation | 1,075,768 | 0.01 | 0.00 | 0 | 0 | |
object stats modification | 149 | 0.00 | | 0 | 0 | |
parallel query alloc buffer | 465 | 0.00 | | 0 | 0 | |
parallel query stats | 1 | 0.00 | | 0 | 0 | |
parameter list | 912 | 0.00 | | 0 | 0 | |
parameter table management | 434 | 0.00 | | 0 | 0 | |
peshm | 1 | 0.00 | | 0 | 0 | |
pesom_free_list | 1 | 0.00 | | 0 | 0 | |
pesom_hash_node | 1 | 0.00 | | 0 | 0 | |
post/wait queue | 10,769 | 0.00 | | 0 | 7,125 | 0.00 |
process allocation | 380 | 0.00 | | 0 | 162 | 0.00 |
process group creation | 281 | 0.00 | | 0 | 0 | |
process queue | 1 | 0.00 | | 0 | 0 | |
process queue reference | 1 | 0.00 | | 0 | 0 | |
qmn task queue latch | 3,821 | 2.41 | 0.97 | 0 | 0 | |
query server freelists | 1 | 0.00 | | 0 | 0 | |
queued dump request | 12 | 0.00 | | 0 | 0 | |
queuing load statistics | 1 | 0.00 | | 0 | 0 | |
recovery domain hash list | 1 | 0.00 | | 0 | 0 | |
redo allocation | 31,264 | 0.08 | 0.00 | 0 | 261,780 | 0.01 |
redo copy | 1 | 0.00 | | 0 | 261,788 | 0.02 |
redo writing | 40,073 | 0.00 | | 0 | 0 | |
resmgr group change latch | 522 | 0.00 | | 0 | 0 | |
resmgr:active threads | 1,213 | 0.00 | | 0 | 611 | 0.00 |
resmgr:actses change group | 201 | 0.00 | | 0 | 0 | |
resmgr:actses change state | 24 | 0.00 | | 0 | 0 | |
resmgr:free threads list | 461 | 0.00 | | 0 | 0 | |
resmgr:plan CPU method | 1 | 0.00 | | 0 | 0 | |
resmgr:resource group CPU method | 4 | 0.00 | | 0 | 0 | |
resmgr:schema config | 839 | 0.00 | | 0 | 61 | 0.00 |
resmgr:session queuing | 1 | 0.00 | | 0 | 0 | |
rm cas latch | 1 | 0.00 | | 0 | 0 | |
row cache objects | 31,081,070 | 0.09 | 0.00 | 0 | 1,149 | 0.26 |
rules engine aggregate statistics | 2 | 0.00 | | 0 | 0 | |
rules engine rule set statistics | 104 | 0.00 | | 0 | 0 | |
second spare latch | 1 | 0.00 | | 0 | 0 | |
sequence cache | 25,818 | 0.01 | 0.00 | 0 | 0 | |
session allocation | 23,270 | 0.00 | | 0 | 7,783 | 0.00 |
session idle bit | 1,614,610 | 0.04 | 0.01 | 0 | 0 | |
session queue latch | 1 | 0.00 | | 0 | 0 | |
session state list latch | 411 | 0.00 | | 0 | 0 | |
session switching | 658 | 0.00 | | 0 | 0 | |
session timer | 1,304 | 0.00 | | 0 | 0 | |
shared pool | 919,577 | 0.24 | 0.11 | 0 | 0 | |
shared pool sim alloc | 1 | 0.00 | | 0 | 0 | |
shared pool simulator | 126,519 | 0.00 | 0.00 | 0 | 0 | |
sim partition latch | 1 | 0.00 | | 0 | 0 | |
simulator hash latch | 5,394,199 | 0.00 | 0.02 | 0 | 0 | |
simulator lru latch | 57,460 | 0.27 | 0.00 | 0 | 5,288,953 | 0.65 |
sort extent pool | 273 | 0.00 | | 0 | 0 | |
space background state object latch | 6 | 0.00 | | 0 | 0 | |
space background task latch | 2,427 | 0.12 | 0.33 | 0 | 2,086 | 0.00 |
state object free list | 2 | 0.00 | | 0 | 0 | |
statistics aggregation | 560 | 0.00 | | 0 | 0 | |
tablespace key chain | 3 | 0.00 | | 0 | 0 | |
temp lob duration state obj allocation | 5 | 0.00 | | 0 | 0 | |
temporary table state object allocation | 3 | 0.00 | | 0 | 0 | |
test excl. parent l0 | 1 | 0.00 | | 0 | 0 | |
test excl. parent2 l0 | 1 | 0.00 | | 0 | 0 | |
third spare latch | 1 | 0.00 | | 0 | 0 | |
threshold alerts latch | 217 | 0.00 | | 0 | 0 | |
transaction allocation | 1,285 | 0.00 | | 0 | 0 | |
transaction branch allocation | 1,316 | 0.00 | | 0 | 0 | |
undo global data | 91,384 | 0.00 | | 0 | 0 | |
virtual circuit buffers | 1 | 0.00 | | 0 | 0 | |
virtual circuit holder | 1 | 0.00 | | 0 | 0 | |
virtual circuit queues | 1 | 0.00 | | 0 | 0 | |