ORA-4031'KQR M PO' When Purging Recyclebin
Last updated on NOVEMBER 10, 2011
Applies to:Oracle Server - Enterprise Edition - Version: 18.104.22.168 to 22.214.171.124 - Release: 11.2 to 11.2
Information in this document applies to any platform.
ORA-4031: unable to allocate 1260 bytes of shared memory ("shared pool","unknown object","sga heap(1,1)","KQR M PO").
In the recycle bin there is around 200,000 partition and subpartition objects all belonging to the same table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms