Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Memory consumption when processing many records
Luch wrote:
>
> Something we notice... If we simply disconnect the sqlca object (the
> transaction object the PowerBuilder application uses to connect to the
> database) and then simply re-connect, say, every 100 records or so...
> the problem goes away. We simply disconnect, re-connect, and pick up
> at the point where we left off. This shows me the memory gets flushed
> every time the session is disconnected.
Dump PowerBuilder - it even tries to use it's own locking mechanism. Oracle is quite good at that, and does not require locks on reads.
What you are witnessing is a PB thing.
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Thu Nov 15 2007 - 13:26:16 CST
![]() |
![]() |