Hi
I am getting this error every day ..
Errors in file /opt/oracle/admin/QTFEEDB/bdump/diag/rdbms/qtfeedb/QTFEEDB/trace/QTFEEDB_dm00_20139.trc (incident=21331):
ORA-04031: unable to allocate 81160 bytes of shared memory ("shared pool","KUPM$MCP","PLMCD^86cf633e","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called: "SYS.KUPM$MCP"
Every day I am commented ORA-Errors as .. my name initials in the log file . then flushing the shared pool memory ..
SQL >alter system flush shared_pool;
for that day .. it won't repeat this error . again next day .. alerting ..
Shared pool memory , we have 2G. Senior DBAs saying that .. flushing shared pool memory is not a solution .. and don't increase the shared pool memory.
so I am bit confused here .. Please give me the solution .. it is very nice of you .. Adv. Thanks.
BR
Frd