SQL Performance (MOSC)

MOSC Banner

SQL to insert data is using conventional path load vs Direct path even though using APPEND hint

We moved our database to a new server:

Old database:

OS: SunOS 5.10

DB version: 11.2.0.1.0


New database:

OS: Oracle Linux 8.3.1-4.5.0.8

DB version: 19.13.0.0.0

SQL statement to insert 50+million rows into a table is not performing the same way. We are using the APPEND hint but execution plan says it is using conventional load path vs direct path. The same SQL uses direct path load. We are unable to copy SQL execution plan from the old database to the new database because the SQL IDs are different.

Is there anything in the optimizer parameters that can help?


Thank you

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