Recent content by gc@siospa.it

Another strange behavior of the component is that doesn't leak if the CacheSize property of the session is below the number of different queries to execute. For example, if the application periodically does 10 different queries and the CacheSize is set to 9 there is no memory spill. But this...

We use 2 instances of oracle: 11 and 19 For Oracle 11: SERVER VERSION : Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production CLIENT VERSION : 11.2.0.1.0 Production For Oracle 19: SERVER VERSION : Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production...

Hi, I'm the maintener of some Delphi 7 / 10 Windows services using our DOA components. They poll the DB with many similar queries, so our dba asks me if is possible to cache the queries these services do. Ok. I set to true the StatementCache property of the TOracleSession component. The query...