Performance issue - Direct/Conventional Load - Oracle.DataAccess - System.Data.OracleClient - 12c

• Performance of the DB got degraded after 11G to 12C migration
• After investigation found that Direct load was not happening for insert (with append hint) and was causing slowness
• System.Data.OracleClient is deprecated.
• Issue resolved after replacing System.Data.OracleClient to Oracle.DataAccess for driver