-
Title
ASM query failed with ORA-4031, "ASMQueryReadViaDiskGroup_impl:ErrorBlockFreeStmtHp OCI_ERROR, Co -
Description
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]
> -
Cause
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;>
-
Resolution
Increase ASM SGA size, or apply for ST104260.
-
Defect ID
ST104260