The values for the bind variables are :1 => 1133, :2 => 10. Below please find the cleaned-up SQL with values instead if bind variables + Failure Message + Execution Plan. Please let me know if anything else is missing. ----------------------------------------------------------------------------------------- -- SQL BEGIN ----------------------------------------------------------------------------------------- Error starting at line 3 in command: SELECT * FROM (SELECT Mp.Channelproductid AS Channelproductid, Mp.Id AS Mappedproductid, Mp.Isactive AS Active, Mp.Reportermappedproductstatus AS Status, Mp.Apluscontentstatus AS Pppcontentstatus, Mp.Filteroutproductinminisite AS Filteroutpms, Mp.Filteroutproductinppp AS Filteroutppp, Pp.Active AS Partnerproductactive, Pp.Partnerproductname AS Partnerproductname, C.Canuseapluscontent AS Pppcontentinconnectionenabled, C.Productcontentstatus AS Pmsconnectionpackagestatus, C.Apluscontentstatus AS Pppconnectionpackagestatus, C.Id AS Connectionid, Ss.Ms_Issmartbuttonenabled AS Smartbuttonenabledforsite, Ss.Deliverpmsusingcustomfeed AS Deliverpmsusingcustomfeed, Ss.Ppp_Isfeedlinksenabled AS Pppfeedlinkenabled, Ss.Ms_Isenable AS Pmsenabledforsite, Ss.Ppp_Isenabled AS Pppenabledforsite, M.Includeapluscontent AS Includeapluscontentinmodule, M.Id AS Moduleid, M.Code AS Modulecode, M.Name AS Modulename, (SELECT Id FROM Contentproviders Cp WHERE Cp.Id=M.Contentprovidersid ) AS Contentproviderid, Site.Code AS Sitecode, Site.Id AS Siteid, P.Id AS Productid, P.Internalcode AS Wcpc FROM Mappedproducts Mp INNER JOIN Connections C ON Mp.Connectionid=C.Id INNER JOIN Sitessetup Ss ON Ss.Setupmode>0 AND Ss.Siteid =C.Contentconsumersiteid INNER JOIN Products P ON Mp.Productid=P.Id INNER JOIN Contentmodules M ON M.Id=C.Contentmoduleid INNER JOIN Contentconsumerssites Site ON Site.Id=Ss.Siteid LEFT OUTER JOIN Partnerproducts Pp ON Mp.Partnerproductid =Pp.Id WHERE mp.isactive =1 AND site.id =1133 AND (c.productcontentstatus IN (40, 50, 400) OR c.apluscontentstatus IN (40, 50, 400)) ORDER BY partnerProductActive DESC nulls last, mp.channelproductid ASC, Mp.Id Asc ) WHERE rownum <= 10 ----------------------------------------------------------------------------------------- -- SQL END ----------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------- -- OUTPUT BEGIN (Fresh from Just Now) ----------------------------------------------------------------------------------------- Error at Command Line:3 Column:0 Error report: SQL Error: ORA-00600: internal error code, arguments: [12406], [], [], [], [], [], [], [], [], [], [], [] 00600. 00000 - "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]" *Cause: This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition. *Action: Report as a bug - the first argument is the internal error number ----------------------------------------------------------------------------------------- -- OUTPUT END ----------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------- -- EXECUTION PLAN BEGIN ----------------------------------------------------------------------------------------- explain plan succeeded. PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Plan hash value: 3628576061 ------------------------------------------------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ------------------------------------------------------------------------------------------------------------------------ | 0 | SELECT STATEMENT | | 10 | 34550 | 10 (10)| 00:00:01 | |* 1 | INDEX UNIQUE SCAN | PK_CONTENTPROVIDERS_1 | 1 | 4 | 1 (0)| 00:00:01 | |* 2 | COUNT STOPKEY | | | | | | | 3 | VIEW | | 123 | 415K| 10 (10)| 00:00:01 | |* 4 | SORT ORDER BY STOPKEY | | 123 | 31611 | 10 (10)| 00:00:01 | | 5 | NESTED LOOPS | | | | | | | 6 | NESTED LOOPS | | 123 | 31611 | 9 (0)| 00:00:01 | | 7 | NESTED LOOPS OUTER | | 123 | 29274 | 8 (0)| 00:00:01 | | 8 | NESTED LOOPS | | 123 | 21156 | 5 (0)| 00:00:01 | | 9 | NESTED LOOPS | | 1 | 101 | 4 (0)| 00:00:01 | | 10 | NESTED LOOPS | | 1 | 65 | 3 (0)| 00:00:01 | | 11 | NESTED LOOPS | | 1 | 42 | 2 (0)| 00:00:01 | | 12 | TABLE ACCESS BY INDEX ROWID| CONTENTCONSUMERSSITES | 1 | 19 | 1 (0)| 00:00:01 | |* 13 | INDEX UNIQUE SCAN | PK_CC_SITE | 1 | | 1 (0)| 00:00:01 | | 14 | TABLE ACCESS BY INDEX ROWID| SITESSETUP | 1 | 23 | 1 (0)| 00:00:01 | |* 15 | INDEX RANGE SCAN | PK_SITESSETUP_1 | 1 | | 1 (0)| 00:00:01 | |* 16 | TABLE ACCESS BY INDEX ROWID | CONNECTIONS | 1 | 23 | 1 (0)| 00:00:01 | |* 17 | INDEX RANGE SCAN | CONNECTIONS_CONSUMERSITEID_ACT | 2 | | 1 (0)| 00:00:01 | | 18 | TABLE ACCESS BY INDEX ROWID | CONTENTMODULES | 1 | 36 | 1 (0)| 00:00:01 | |* 19 | INDEX UNIQUE SCAN | PK_CONTENTMODULES | 1 | | 1 (0)| 00:00:01 | |* 20 | TABLE ACCESS BY INDEX ROWID | MAPPEDPRODUCTS | 139 | 9869 | 1 (0)| 00:00:01 | |* 21 | INDEX RANGE SCAN | MAPPEDPRODUCTS_I1 | 264 | | 1 (0)| 00:00:01 | | 22 | TABLE ACCESS BY INDEX ROWID | PARTNERPRODUCTS | 1 | 66 | 1 (0)| 00:00:01 | |* 23 | INDEX RANGE SCAN | PARTNERPRODUCTS_I2 | 1 | | 1 (0)| 00:00:01 | |* 24 | INDEX UNIQUE SCAN | PK_PRODUCTS | 1 | | 1 (0)| 00:00:01 | | 25 | TABLE ACCESS BY INDEX ROWID | PRODUCTS | 1 | 19 | 1 (0)| 00:00:01 | ------------------------------------------------------------------------------------------------------------------------ Predicate Information (identified by operation id): --------------------------------------------------- 1 - access("CP"."ID"=:B1) 2 - filter(ROWNUM<=10) 4 - filter(ROWNUM<=10) 13 - access("SITE"."ID"=1133) 15 - access("SS"."SITEID"=1133 AND "SS"."SETUPMODE">0) 16 - filter("C"."PRODUCTCONTENTSTATUS"=40 OR "C"."PRODUCTCONTENTSTATUS"=50 OR "C"."PRODUCTCONTENTSTATUS"=400 OR "C"."APLUSCONTENTSTATUS"=40 OR "C"."APLUSCONTENTSTATUS"=50 OR "C"."APLUSCONTENTSTATUS"=400) 17 - access("C"."CONTENTCONSUMERSITEID"=1133) 19 - access("M"."ID"="C"."CONTENTMODULEID") 20 - filter("MP"."ISACTIVE"=1) 21 - access("MP"."CONNECTIONID"="C"."ID") 23 - access("MP"."PARTNERPRODUCTID"="PP"."ID"(+)) 24 - access("MP"."PRODUCTID"="P"."ID") 49 rows selected ----------------------------------------------------------------------------------------- -- EXECUTION PLAN END -----------------------------------------------------------------------------------------