Recent content by jeckels

I noticed on another thread about a 64-bit hotfix Is there a list of patch notes which outlines change history?

Yes, this is literally the only change. When False, no spiralling memory growth. When true, memory grows. I have an application with False, takes 45 minute; uses about 40M That exact same application with True, takes about 15 hours, and uses more and more (upwards to 1.4GIG).

I forgot to add this is Delphi 10, using 64bit windows builds

I am using StatementCache := true, StatementCache := 100. What I am seeing is that from the Oracle persecptive, there is 1 parse, and numerous executions; as I would expect. HOwever, I am also noticing that my application's memory has gone crazy. WIthout statment cache, it uses about 40M...

I will add that our latest test is a 32bit OS running this does not appear to have this problem. So, it looks like something with 32bit oracle client on a 64bit system (WOW).

Verified the DB performance for the queries is unchanged for all tests. What are the optimal settings for a multi-threaded application where each thread owns their own session, and all thread queries are against that thread session, and all thread queries are expected to run (and wait until...

I should add the specifics for TOracleSession .ThreadSafe := True; .AutoCommit := False; TOracleDataset .Session := MySession; .ReadOnly := True; .Unidirectional := True; .ReadBuffer := 1000; TOracleQuery .Session := MySession;

Some background My environment is Delphi 7, DOA 3.4.6.4 (preparing update to 4.1). Oracle access is non-visual. I am only using TOracleSession for connections (one / thread in my application), TOracleQuery (for update/delete/inserts), TOracleDataset (for selects). I have a windows scheduler...