Oracle C# drive is already pretty fast with the default configuration. But we can always tweak it a little to make it even faster.
By controlling the FetchSize property in ODP.NET we can make fewer round trips to Oracle Database and fetch the data faster.
Let's take a look