Parse Insert statement slow
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Parse Insert statement slow

  1. #1
    Join Date
    Jul 2001
    Posts
    1
    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 ?

  2. #2
    Join Date
    Jun 2000
    Posts
    179
    You need to tune latches and enlarge shared pool size
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

  3. #3
    Join Date
    Jul 2001
    Posts
    45
    you can try reorganizing specified table

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width