Hi,
Gerald Richter wrote:
> I guess your mod_perl is compiled as dynamic module (with
> USE_DSO) and _not_ linked staticly into Apache?
Actually, we are using modperl statically compiled with apache.
I do not know whether the following will help in identifying
the problem:
We are running Oracle's 'analyze' on all our tables once every
day. Oracle support person us told that there is some problem
with the cost-based optimization that is done by Oracle (after
'analyze'), which causes Oracle to core dump (rarely).
So, we tried to hint Oracle to not use cost-based optimization (by
adding '/*+ RULE */' in the query).
With this change, the problem is not happening.
Even without any of these changes, the script with plain DBI version of
the same query is not having this problem. So, I guess there
is something that DBIx::Recordset does in addition to our query,
which is causing this problem.
Thanks,
dhanabal
