[ServletException in:/catalog/resultskeysub.jsp] SQLException while getting multiple products for search : SELECT n.productid, n.productname, po.description FROM PRODUCT n, (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 '%PENS %' OR UPPER(p.PRODUCTNAME||' ') LIKE '%PENS %' OR UPPER(p.SKU||' ') LIKE '%PENS %' OR UPPER(p.MANUFACTURERPARTNUM||' ') LIKE '%PENS %' OR UPPER(c.ancestorvalue||' ') LIKE '%PENS %' OR UPPER(p.SEARCHKEYWORD||' ') LIKE '%PEN %' OR UPPER(p.PRODUCTNAME||' ') LIKE '%PEN %' OR UPPER(p.SKU||' ') LIKE '%PEN %' OR UPPER(p.MANUFACTURERPARTNUM||' ') LIKE '%PEN %' OR UPPER(c.ancestorvalue||' ') LIKE '%PEN %')) k, productdetail pd, productoption po where (upper(trim(pd.attrname)) = 'ITEM COLOR') and pd.attrtype = 'option' and n.PRODUCTID = k.PRODUCTID and n.productid = pd.productid and pd.productdetailid = po.productdetailid ORA-04030: out of process memory when trying to allocate 8192 bytes (sort subheap,sort key) '