-
Hi All,
This is my first time using the forum.
I have a question here where I experienced that one of
the parse statement for inesrt is real slow.
The statement is :
Insert into Pms_PrsIns_Trn (StoreId, PrescriptionNo,
ItmsequenceNo, InsSequenceNo,
Instruction, instrdescription, insquantity, inslabel)
values ( :1, :2, :3, :4, :5, :6, :7, :8)
I tracked the session and found out that the parsing
is around with 1 row inserted and having 2 parse count.
cpu elapsed
120.48 193.03
I checked the trace file and I found out that I have
lot of line of the following :
WAIT #6: nam='latch free' ela= 2 p1=-1861920608 p2=99 p3=1
WAIT #6: nam='latch free' ela= 0 p1=-2147431472 p2=98 p3=0
WAIT #6: nam='latch free' ela= 1 p1=-2147431472 p2=98 p3=8
WAIT #6: nam='latch free' ela= 0 p1=-2147431472 p2=98 p3=9
WAIT #6: nam='latch free' ela= 2 p1=-2147431472 p2=98 p3=10
This problem only started lately. I think the above
is trying to tell me that it is having SGA problem.
But, don't used to have that problem why it suddently
became a problem. And am I right about the SGA ?
-
You need to tune latches and enlarge shared pool size
-
you can try reorganizing specified table
