Re: Incremental Commits and Disappearing Sessions
Date: Tue, 26 Feb 2008 07:52:56 -0800 (PST)
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%
> 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