Hello,
I am having an issue with a client where, during a logical export, the following error occurs: "unable to allocate 1024 bytes of shared memory"
I was using AMM (switched to ASMM) and increased the amount of memory to the shared pool, however my question is I am unsure how to investigate the cause of consumption of the SGA. I am concerned about problematic code, missing indices or incorrectly defined indices that may cause the issue. I know my question is not specific, I was hoping to get some guidance as to how to investigate the root cause as to how I got to the lack of space in the shared_pool, any ideas are welcome.
full error stack:
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04031: unable to allocate 1024 bytes of shared memory ("shared pool","SELECT /*+rule*/ SYS_XMLGEN(...","SQLA^9ff2fad7","KGHSC_ALLOC_BUF:buf")
ORA-06512: at "SYS.KUPW$WORKER", line 1838
ORA-06512: at line 2
Job "SYS"."SYS_EXPORT_FULL_01" stopped due to fatal error at 01:06:06