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

[hrishy]

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

Hi Mallma

If you are getting that error it means direct path insert is indeed actually working :-D

regards
Hrishy