| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Insert Performance question
Mladen,
I can't use the append hint as it do table excusive lock and other
session=20
Are just waiting and decrease throughput.
SQL Server database is in full mode that is doing full logging.
Redo log files are 2G currently, what should be the recommended size?
Thanks
--Harvinder
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala
Sent: Tuesday, July 27, 2004 4:04 PM
To: oracle-l_at_freelists.org
Subject: Re: Insert Performance question
On 07/27/2004 03:45:54 PM, Harvinder Singh wrote:
> Hi,
>=20
> Also we are doing the same test on SQL Server. With 2 sessions
inserting
> 1M each by selecting from same table and inserting into 1st table
> inserts_rows_per_Second on SQL Server is 25000 whereas on Oracle is
only
> 10000.
Try it with the APPEND hint, and also try turning off dirty reads
on SQL server, which will bring SQL Server more in line with the normal
performance numbers. Make sure that SQL Server is doing journaling
(a thing that MS people occasionally forget to turn on and is
approximately
as insignificant as redo logging). Also, increase the size of redo log
files,=20
so that you don't do log switching and put redo logs on the fastest disk
available. Don't put anything else there, if you can help it. As a sales
support person for a company that used to sell WYSE Unix machines, which
were overgrown PC boxes with EISA I/O boards and a proprietary SMP
motherboards,
I was able to beat SGI Indigo workstation running then brand new 66MHZ
MIPS 4400
with a Wyse 7000 box running a 33MHZ 486. How did I do it? Well, there
is a
parameter called "_disable_logging".....Microsoft people tend to do the
same
thing if not carefully watched.
--=20
Mladen Gogala
Oracle DBA
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Jul 27 2004 - 15:08:56 CDT
 |
 |