ORA-00604, ORA-04031

[ragu]

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

[kcbland]

See your DBA, this is all Oracle.

[ketfos]

Hi,

It could be that you may pass characters into number variables or your variable size is not enough to hold the value.

Ketfos

[ragu]

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