What is the specific error message it is showing ?
or check the shared pool free memory by
select * from v$sgastat
where name ='free memory'
and pool = 'shared pool'
The bind variables seems ok, need not require to parse the statement again.
You can search in v$sql for how many versions of the statement exists.
cheers




Reply With Quote