Database Tuning (MOSC)

MOSC Banner

Insert row to table performance slow in 18c

edited May 2, 2020 7:16PM in Database Tuning (MOSC) 11 commentsAnswered

WE have a new job in Oracle 18c DB, but the ODI insert sql seems slow, insert 20,000,000 row to temp table time need 1 more hours.

please help to assist what is the problem and how to tune the insert performance, many thanks.

attached two awr report as below:

1. awrrpt_1_3177_3178(commit 5000).html

for parameter set to 5000 commit

ADDM report too many Commits

Finding NameAvg active sessions of the taskPercent active sessions of findingTask NameBegin Snap TimeEnd Snap Time
Commits and Rollbacks1.6559.38ADDM:2611718358_1_317828-Apr-20 16:0028-Apr-20 17:00

then change the commit parameter to 50000

2. awrrpt_1_3202_3203 (commit 50000).html

but found Unusual "Network" Wait Event in ADDM reoprt

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