Event_log
<
Error 2012-04-08 19:56:13.219219 24607 3679832976 Capture: Error
reading block 88290 from file
+DATA/orbqa/onlinelog/group_2.1183.777937515:
ASMQueryReadViaDiskGroup_impl:ErrorBlockFreeStmtHp OCI_ERROR, Code 4031:
ORA-04031: unable to allocate 3896 bytes of shared memory ("shared
pool","DECLARE .hdl number; .blk_nu...","sga heap(1,0)","kglsim object
batch"). (capturing from SPORBQA) [module oct]
>
ASM SQL query doesn't use bind variables,
<
DECLARE
hdl number;
blk_num number;
bytes number;
BEGIN
hdl := 1;
blk_num := 158639;
bytes := 32256;
BEGIN
dbms_diskgroup.read(hdl,blk_num,bytes,:data_ptr);
EXCEPTION
WHEN OTHERS then
:rc := SQLCODE;
:err_msg := SQLERRM;
return;
END;
:data_len := bytes;
:rc := 0;
END;
>
Increase ASM SGA size, or apply for ST104260.
