REPOST: Re: Oracle and SQL Server

In article <5KZX7.36613$Q66.129567_at_NewsReader>, "Garrick Bigwood" <garrickb_at_software360.com> wrote:

> Hello,
>

 Looking at the trace files one of the problems with
> Oracle seems to be the amount of physical writes done to datafiles and
> rollback files(also redo of course), when I look at the SQL Server trace
> files there does'nt to be any writing done.

Just to clarify, are you doing a COMMIT after each update? I don't know exactly how SQL server handles these, but you may be right about delayed i/o. A commit should generate some kind of write to disk.

Oracle only requires a write to the redo log on commit; any writes to datafiles are from cache flushing, or a checkpoint. If your SGA is too small you're obviously going to see more I/O. Check the SGA and SQL Server's cache size - they should be the same size for a fair test.

Also, how many indexes are on the table/column? Is the column NULL before update?

• WAS CANCELLED BY =======: Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.media.kyoto-u.ac.jp!newsfeed.mesh.ad.jp!osa.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r From: "Kendall" <kendallwillets_at_yahoooo.com> Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.server Subject: cmsg cancel <pan.2001.12.31.10.31.05.466.8939_at_yahoooo.com> Control: cancel <pan.2001.12.31.10.31.05.466.8939_at_yahoooo.com> Date: Wed, 2 Jan 2002 03:22:20 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.pan.2001.12.31.10.31.05.466.8939_at_yahoooo.com> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009944993 21023 166.102.15.34 (2 Jan 2002 04:16:33 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 2 Jan 2002 04:16:33 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent? Xref: news.uni-stuttgart.de control:40280113

autocancel Received on Mon Dec 31 2001 - 12:31:05 CST