I AM ATTACHING SOURCE CODE OF BOTH VIEWS. WHEN I USE TO RUN THESE VIEWS BY MAKING PART OF IT. THEY RUN SUCCESFULLY. I AM NOT GETTING WHAT IS THE PROBLEM.

PLEASE HELP WHAT IS THE REASON.

REGARDS

GURPREET SINGH SETHI

01-13-2004, 05:01 AM

julian

Re: Ora-04031 Unable To Allocate 316 Bytes Of Shared Memory

What do you mean by "RUN A VIEW"??

01-13-2004, 01:52 PM

gbrabham

It is probably because the SGA has become fragmented to the point
that there is not enough contiguous space for the object to be loaded.
As objects are aged out of the SGA, they leave "holes". Objects have to have contigous space in order to be loaded into SGA... You need to
1. reboot the database in order to clear the problem (flushing shared pool doesn't do it)
2. Look at the procs, functions, etc that are loaded into the SGA, their size and the number of executions and the reloads of them ... Find the problem ones and PIN them in SGA...

To determine what large PL/SQL objects are currently loaded in the shared pool
and are not marked 'kept' and therefore may cause a problem, execute the following: