A question about ORA-04031 error

From: Stan Brown <stanb_at_panix.com>
Date: Mon, 16 Sep 2002 12:38:05 +0000 (UTC)
Message-ID: <am4jbd$k8h$2@reader1.panix.com>

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 - 07:38:05 CDT