| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Very bad performances on Oracle
A copy of this was sent to "Jim DeCicco" <decj1_at_interaccess.com>
(if that email address didn't require changing)
On Sun, 14 Feb 1999 07:17:53 -0600, you wrote:
>As I'm sure you're aware, there are times when record by record processing
>is appropriate (not to mention that SQL Server might perform better with a
>set based update as well).
>
yes i am but given the example, doing it row by row would be a waste.
>Asside from the redo log sizing, is there anything else that could explain
>the diference in performance? I have an interest in this, as I'm
>experiencing slower than expected update performance in Oracle.
>
there could be many reasons for the difference. the primary one, and the one to start with, would be redo log sizing. next might be disk contention or archiving or SGA size or checkpointing or too many indexes or side effects from triggers or ........
would need to know alot more about the system, the conditions, the sizing of, etc, etc and the expected performance before anyone could comment more in dept.
>Thanks,
>
>Jim
>
>Thomas Kyte wrote in message <36c53073.6268924_at_192.86.155.100>...
[snip]
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sun Feb 14 1999 - 09:07:32 CST
 |
 |