Re: Error ORA-04031 - sort merge buffer

In article <5sgi87$eug$1_at_news.sas.ab.ca>,   suisum_at_freenet.edmonton.ab.ca () wrote:
>
> Subject: Error ORA-04031 - sort merge buffer
>
> Please explain the error ORA-04031 - Unable allocate 42000 bytes of shared
> momery {"unknown object", "cursor work he", "sort merge buffer"}.
>
> How can I get this error resolved?
>
> --
> Best regards,

Apparently the size of the shared pool buffer in SGA is insufficient. You have the following choices: 1. increase the shared_pool_size in init<oracle_sid>.ora 2. assuming the memory is fragmented, login as any dba user and issue: SQL> alter system flush shared_pool; Hope it helps.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet