This content has been marked as final. Show 10 replies
Welcome 2 oracle forums :)
Please refer MOS tech note:
*ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KKOCXJ : PJPCTX] When Executing a SQL [ID 566823.1]*
see Workaround section and make sure parameter optimizerpush_pred_cost_based* is set to false.
If this doesn't help, please see trace file for the specific session.
X A H E E R
Till now i have find this issue for three views, all of them on different tables.
example is below
if i use count(*) its working fine
from View1 f
from View2 i
But if i use
select f.ID, f.TYPE, f.RELEASE, f.PRIMARY_RELEASE, f.TEAM
from view1 f
select i.ID, i.TYPE, i.RELEASE, i.PRIMARY_RELEASE, i.TEAM
from view2 i
Then i get
ORA-00600: internal error code, arguments: [kkqtSetOp.1], , , , , , , , , , , 
Edited by: 832546 on Feb 8, 2011 3:06 AM
Above errors ORA-00600: internal error is resolved after i submit SR. They suggest to change parameter “_optimizer_join_factorization” to false.
But i am still facing with another error with view on oracle 11gr2
ORA-03113: end-of-file on communication channel...
Below is the work around i done for "ORA-03113: end-of-file on communication channel"
Join Condition for view is
If i run by just removing any one of above join condition is works fine but since i dont know business logic so i come up with solution below
1. create table t111 as select * from t1;
2. rename table t1 to abc
3. rename t111 to t1
Now it is starts working.
I don't know what had happen but i find workaround not solution.
If somebody suggest the solution and reason why this happening highly appreciated.
Edited by: 832546 on Feb 14, 2011 3:24 AM
Please check below notes which could be helpful to understand your issue:
Connections To Database Terminate With ORA-3113 end-of-file on communication channel [ID 1104673.1]
DIAGNOSING ORA-3113 ERRORS [ID 1020463.6]
ORA-03113 on Unix - What Information to Collect [ID 17613.1]
OERR: ORA 3113 "end-of-file on communication channel" [ID 19790.1]