Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why? Oracle 7.3 Server stalls Client

Re: Why? Oracle 7.3 Server stalls Client

From: Stevyn Dembo <sdembo_at_soliton.bc.ca>
Date: 18 Jul 1998 02:58:09 GMT
Message-ID: <01bdb1f7$c2d32d60$1d13c2cf@soldev>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US