Hi Everybody,
I am using 2 OCI plug-in stages to fetch data from Oracle and do a lookup
I am dealing with 22 million rows so I thought a direct lookup from the table will be better
I am guessing this might either permission issue or space issue as I got my password recently reset and also the database is running out of space
I went through the forum to find some information but there was just one post regaring this
Somebody can help me better with these errors
SelectTestJoinforUpdate..ORAOCI8_64: ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 428 bytes of shared memory ("shared pool","TRIGGER$SYS","KQLS heap","KQLS MEM BLOCK")
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 324 by
SelectTestJoinforUpdate..ORAOCI8_64: ORA-04031: unable to allocate 4084 bytes of shared memory ("shared pool","unknown object","sga heap","session param values")
SelectTestJoinforUpdate..ORAOCI8_64: ORA-04031: unable to allocate 2196 bytes of shared memory ("shared pool","select con#,t","KQLS heap","KQLS MEM BLOCK")
Thank you
Regards,
Ragu
ORA-00604, ORA-04031
Moderators: chulett, rschirm, roy
Just DB problem
Thanks Everybody,
It was just a Database problem
The DBA had to bounce it back because of other issues
After that the job is running fine with no problem
Thanks again
Regards,
Ragu
It was just a Database problem
The DBA had to bounce it back because of other issues
After that the job is running fine with no problem
Thanks again
Regards,
Ragu