Re: Incremental Commits and Disappearing Sessions

On 26 Feb, 00:54, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> Oracle 10.2.0.3.0
> Windows 2003 Server
> 16GB Memory (93% SGA( 93% Buffer Cache,<3% Shared Pool, <3% Large Pool), 7%
> PGA)
>
> In my continuing saga of disappearing sessions our off-site DBA has told us
> to do incremental commits.

Is your DBA on drugs?

> It's always been my understanding that you only want to commit at the end of
> your logical transaction.  After reading Tom Kyte's book that only
> reinforced that understanding.
>
> Could anybody shed any light on why he would suggest this?

No idea. Ask him his reasons. I'd love to see them.

HTH -g Received on Tue Feb 26 2008 - 09:52:56 CST