DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 29

Thread: Insert using /*+ append */ hint not reduced my time

Threaded View

  1. #28
    Join Date
    Jun 2005
    Posts
    12
    Hi willian,
    I have given select statement for counting the row immediatly after the INSERT there is no COMMIT or ROLLBACK. I am getting the same error.
    ORA-12838: cannot read/modify an object after modifying it in parallel
    ORA-06512: at "DW.P1", line 710
    ORA-06512: at line 2

    Autotrace for the INSERT is not displaying in TOAD, only for the select statements i can get the Autotrace.I am not sure i am looking the correct one. I will update you on this .

    thanks
    mallma
    Last edited by mallma; 07-06-2005 at 02:10 AM.

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