Path: news.easynews.com!easynews!peer1-sjc1.usenetserver.com!usenetserver.com!cyclone.bc.net!newsfeed.direct.ca!look.ca!news.noc.cabal.int!resurrector!guidorepost!not-for-mail From: "Jim Kennedy" Subject: REPOST: Re: Oracle and SQL Server Newsgroups: comp.databases.oracle.server X-Repost-Date: 2 Jan 2002 20:52:20 GMT Message-ID: <3$--$$-$-%-$-$$$-$@news.noc.cabal.int> X-Original-Path: sn-us!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!wn1feed!worldnet.att.net!204.127.198.203!attbi_feed3!attbi.com!rwcrnsc54.POSTED!not-for-mail X-Original-Message-ID: X-Original-NNTP-Posting-Host: 12.224.242.123 References: <5KZX7.36613$Q66.129567@NewsReader> X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-Complaints-To: abuse@attbi.com X-Trace: rwcrnsc54 1009910955 12.224.242.123 (Tue, 01 Jan 2002 18:49:15 GMT) NNTP-Posting-Date: Tue, 01 Jan 2002 18:49:15 GMT Organization: AT&T Broadband Date: Tue, 01 Jan 2002 18:49:15 GMT Sender: resurrector@mindspring.com (Guido the Resurrector) X-Reposted-By: resurrector@mindspring.com (Guido the Resurrector) X-Comments: GtR Repost: The following Usenet article was cancelled, more X-Comments: than likely by someone other than the original poster. Please X-Comments: see the end of this posting for a copy of the cancel. X-Comments: Guido the Resurrector can be contacted at X-Comments: resurrector@mindspring.com. Xref: easynews comp.databases.oracle.server:129448 X-Received-Date: Thu, 03 Jan 2002 09:49:37 MST (news.easynews.com) Good points. Also I believe the default in the sql query tool is autocommit. Jim "Kendall" wrote in message news:pan.2001.12.31.10.31.05.466.8939@yahoooo.com... > In article <5KZX7.36613$Q66.129567@NewsReader>, "Garrick Bigwood" > 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.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!newsfeed1.earthlink.net!newsfeed.earthlink.net!uunet!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r From: "Jim Kennedy" Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.server Subject: cmsg cancel Control: cancel Date: Wed, 2 Jan 2002 03:03:43 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009944080 21023 166.102.15.34 (2 Jan 2002 04:01:20 GMT) X-Complaints-To: abuse@navix.net NNTP-Posting-Date: 2 Jan 2002 04:01:20 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent? autocancel