Recently we encountered ora-4031 at frequent intervals. We're unable to find the cause of this problem. Workaround is shutdown/startup db. However, this is unacceptable as this is a 24x7 operations.

Our original share pool was 100MB, and increased to 500MB, but the problem persists.

We pinned all packages, functions, triggers, triggers at start up, and problem still occurred.

Our Oracle version is 8.0.5.2.1 and os is Compaq Tru64 v4.2 unix.

How do we monitor and trace this problem? And most importantly, fix it.

Thanks.