[ServletException in:/catalog/resultskeysub.jsp] SQLException while getting COUNT : select COUNT(*) from PRODUCT n, (select p.productid, min(t.discount) as price, min(t.specialprice) as specialprice, max(round((t.discount*1.25 - (case when t.SpecialPrice is null then t.discount*0.9 else t.SpecialPrice end))/ (t.discount*1.25) * 100, 0)) as savepercent from TIERPRICE t, (SELECT DISTINCT(p.PRODUCTID) FROM PRODUCT p, PRODUCTCATEGORY pc, category c WHERE p.statusid = 1 and c.categoryid = pc.categoryid and p.PRODUCTID = pc.PRODUCTID and (UPPER(p.SEARCHKEYWORD||' ') LIKE '%PROMOS %' OR UPPER(p.PRODUCTNAME||' ') LIKE '%PROMOS %' OR UPPER(p.SKU||' ') LIKE '%PROMOS %' OR UPPER(p.MANUFACTURERPARTNUM||' ') LIKE '%PROMOS %' OR UPPER(c.ancestorvalue||' ') LIKE '%PROMOS %' OR UPPER(p.SEARCHKEYWORD||' ') LIKE '%PROMO %' OR UPPER(p.PRODUCTNAME||' ') LIKE '%PROMO %' OR UPPER(p.SKU||' ') LIKE '%PROMO %' OR UPPER(p.MANUFACTURERPARTNUM||' ') LIKE '%PROMO %' OR UPPER(c.ancestorvalue||' ') LIKE '%PROMO %')) k, PRODUCT p where t.TIERCOST IS NULL and t.discount > 0 and k.PRODUCTID = p.PRODUCTID and t.productid = p.PRODUCTID AND p.STATUSID = 1 group by p.productid) x , (select productid,sum(salesprice) quantity from orderdetail where insertdate> sysdate-365 group by productid ) od ,(select productid, picture1, picture154, picture400 from picture where isdft = 'Y') pco where n.PRODUCTID = x.PRODUCTID and n.productid = od.productid(+) and n.productid = pco.productid(+) ORA-04030: out of process memory when trying to allocate 64768 bytes (session heap,frame segment) '