Hi All,
My DB is 11.2 Exadata machine. I did the data migration to PROD and PROD team said my DML blocked their DDL. I want to get confirmed here before I email them to defend myself.
My DML is
insert /*+ append noparallel(t) */ into GPOS_XXX_XXX PARTITION(p3) t
SELECT /*+ noparallel(s)*/* FROM GPOS_XXX_XXX@adw3u_izoom_admin s WHERE srce_sys_id = 1;
commit;
Their DDL looks like
ALTER TABLE GPOS_XXX_XXX TRUNCATE PARTITION p4
I did the test and it shows they can ran in parallel very well, no resource busy error will be thrown out.
Do I miss something here, please?
Best regards,
Leon