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