ORA-12842: Cursor invalidated during parallel execution
Posted: Wed Apr 02, 2008 12:56 am
Hi All,
We have the server job which used to check the saletodateagainstdmsale tables. We usually ran the query with parallel hint SELECT /*+ parallel (SALETODATE,8 ) */ (...). The job ran quite good for couple of months but now the job was aborted by below warnings and error
ORA-24347: Warning of a NULL column in an aggregate function
ORA-12842: Cursor invalidated during parallel execution
When we forced the job after sometime it completed with the warning of a NULL column. Need your approach in order to resolve this issue.
Thanks,
Satheesh
We have the server job which used to check the saletodateagainstdmsale tables. We usually ran the query with parallel hint SELECT /*+ parallel (SALETODATE,8 ) */ (...). The job ran quite good for couple of months but now the job was aborted by below warnings and error
ORA-24347: Warning of a NULL column in an aggregate function
ORA-12842: Cursor invalidated during parallel execution
When we forced the job after sometime it completed with the warning of a NULL column. Need your approach in order to resolve this issue.
Thanks,
Satheesh