Oracle Simple Conventional INSERT/UPDATE are generating multiple Child#
Oracle Simple Conventional INSERT/UPDATE are generating multiple Child# and showing high Hard Parses in them for the same SQL Insert with Bind values. At one time can see 100 of Child and even try to clear them, start generting multiple Child for same Sqlid/Hash Value. It is Oracle 12.2 on Exadata and not more thant 5-10 Concurrent Single Row Insert are running. ALso No Wait like ITL list is reported in the AWR/ASH Below is one Example where more than 150 Child are created for same Insert. Issue is for all such INSERT to multiple tables
INSERT INTO custz (more than 200 Cols) VALUES (:1 , CURRENT_TIMESTAMP , :2 ,