Re: A question about ORA-04031 error

Stan-

Are you by any chance using MTS connections?

• ricky

Stan Brown wrote:
>
> I've got a 7.3.4.5 instance running on HP-UX 10.20. It's been up and running
> for several months now without problems.
>
> However now one of the processes that manipulates it, specificly a perl DBI
> script that trims older records out of it has started returning:
>
> +/opt/local/bin/trim_tables line 448.
> DBD::Oracle::st execute failed: ORA-04031: unable to allocate 42000 bytes of
> +shared memory ("unknown object","cursor work he","sort merge buffer") (DBD:
> +oexfet error) at /opt/local/bin/trim_tables line 508.
>
> I've looked at the machine that this instance runs on, and it has plenty of
> free swap space.
>
> Any ideas where to start looking for the culprit on this?
>
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
> -- Benjamin Franklin
Received on Mon Sep 16 2002 - 16:20:49 CDT