Oracle Solution for Error ora-02786

ORA-02786: Size needed for shared region is greater than segment size

What triggered the Error:

The size of the shared segment that was specified for the shared buffer region is less than the number of bytes required. The first field of the "additional information" field is the size needed. The second is the size of the segment.

What should we do to fix it:

Use a larger size segment or let the package allocate its own.