=========================
Test case On 29-SEP-2005
=========================
Original Statement:
INSERT INTO pvm
SELECT *
FROM pvm1;
Source table : pvm1 has 2.3 million rows. If statement executes normally it will take long time to execute. So i modified following statement and 2.3 Million rows processed in Approx 30 seconds.
10:39:11 CIF@CIF:-> set feedback 1
10:39:11 CIF@CIF:-> INSERT /*+ append parallel (pvm, 4) */ INTO pvm
10:39:19 2 SELECT /*+ parallel (CIF_CUSTOMER_SYSTEM_ID_XREF, 4) */ *
FROM pvm1 ;10:39:19 3
2349912 rows created.
Elapsed: 00:00:25.51
10:39:51 CIF@CIF:->
10:39:51 CIF@CIF:-> 10:39:51 CIF@CIF:-> 10:39:51 CIF@CIF:-> select count(*) from pvm;
select count(*) from pvm
*
ERROR at line 1:
ORA-12838: cannot read/modify an object after modifying it in parallel
Elapsed: 00:00:00.00
10:40:48 CIF@CIF:-> commit;
Commit complete.
Elapsed: 00:00:00.02
10:40:59 CIF@CIF:-> select count(*) from pvm;
COUNT(*)
———
2349912
1 row selected.