Oracle DBA, How To, Error, Cause and Action

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

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


Cause:


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.



Action:


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

No comments:

Post a Comment

Thanks for your comment.