Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: autocommit ON but no commits visible in v$sqlarea
On Wed, 25 Dec 2002 13:44:39 GMT, "Jim Kennedy"
<kennedy-down_with_spammers_at_attbi.com> wrote:
> Try not using auto commit. The waits will probably go away if you do.
> Autocommit is not a good idea.
> Jim
Could you expand on that for me.
I'll take a guess that one good reason is that it is a pretty d'uh approach to implementing business logic.
Are there also good technical reasons to avoid this? ...as in; what's the difference between autocommit and issuing an explicit commit on every statement?
TIA Steve Roach Received on Thu Dec 26 2002 - 18:43:20 CST