Hello,

  Our product gives the user a choice of using either Direct Mode or using an Oracle client.

  A customer has reported that when using Direct Mode, a particular query is taking 17 minutes, and when using an Oracle client, it takes only 18 seconds.

  What could be causing this difference?   I mean, clearly, Oracle is choosing a different execution plan when direct mode is used, but do you have any ideas why this is happening?

  We are using the latest version of ODAC, compiled 64 bit in Delphi 11.3.

Thanks,

John Dorlon