Memory usage for OracleDataReader

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Memory usage for OracleDataReader

Post by Shalex » Wed 22 Jun 2016 15:11

When oracleCommand.FetchSize=0, a value of FetchSize will be determined automatically (for better performance) and it will be changed dynamically when executing read operations.

The least amount of memory consumed with oracleCommand.FetchSize=1.

For more information about the FetchSize property, refer to https://www.devart.com/dotconnect/oracl ... hSize.html.

jizhu233
Posts: 10
Joined: Wed 11 May 2016 02:18

Re: Memory usage for OracleDataReader

Post by jizhu233 » Mon 10 Oct 2016 09:12

Hi,
I know the meaning of property 'FetchSize', and I wonder is there any other property or method which can help reducing the memory usage when FetchSize = 0 ?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Memory usage for OracleDataReader

Post by Shalex » Wed 12 Oct 2016 11:04

jizhu233 wrote:I wonder is there any other property or method which can help reducing the memory usage when FetchSize = 0 ?
There is no any other property. Please set FetchSize to some fixed value (1 or greater).

jizhu233
Posts: 10
Joined: Wed 11 May 2016 02:18

Re: Memory usage for OracleDataReader

Post by jizhu233 » Thu 16 Mar 2017 09:24

Hi,
Is there any new finding or suggestions about this problem?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Memory usage for OracleDataReader

Post by Shalex » Wed 22 Mar 2017 16:27

We will implement the Default Fetch Size connection string parameter (corresponds to oracleCommand.FetchSize) in the next public build and notify you when it is available for download.

Does Fetch Size setting solve the memory usage issue you have encountered?

Post Reply