Database Tuning (MOSC)

MOSC Banner

Oracle Simple Conventional INSERT/UPDATE are generating multiple Child#

edited Aug 29, 2019 12:55PM in Database Tuning (MOSC) 6 commentsAnswered ✓

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  ,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center