Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why? Oracle 7.3 Server stalls Client
The Delphi SQLLINKS environment is setup to autocommit. We don't do any
START TRANSACTION or END TRANSACTION, Delphi handles each SQL statement as
one atomic transaction.
I will look at the size of the redo logs.
Thanks.
JHY <jhy_at_earthling.net> wrote in article
<6onlik$k2f_at_bgtnsc02.worldnet.att.net>...
> Sounds like your redo logs are filling up. Try increasing the size of
your
> redo logs and see if your throughput improves. You didn't say how often
you
> commit. Do you commit after each insert?
>
>
Received on Fri Jul 17 1998 - 21:58:09 CDT
![]() |
![]() |