Path: news.easynews.com!easynews!news.he.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 19:26:40 GMT Message-ID: <0$--$$-$-%%-_--$$$@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.204!attbi_feed4!attbi.com!rwcrnsc52.POSTED!not-for-mail X-Original-Message-ID: <3RlY7.624$dK4.7119@rwcrnsc52> X-Original-NNTP-Posting-Host: 12.224.242.123 References: <5KZX7.36613$Q66.129567@NewsReader> <3L9Y7.118665$BX4.7693026@e3500-atl1.usenetserver.com> 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: rwcrnsc52 1009904063 12.224.242.123 (Tue, 01 Jan 2002 16:54:23 GMT) NNTP-Posting-Date: Tue, 01 Jan 2002 16:54:23 GMT Organization: AT&T Broadband Date: Tue, 01 Jan 2002 16:54:23 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. Lines: 74 Xref: easynews comp.databases.oracle.server:129440 X-Received-Date: Thu, 03 Jan 2002 09:48:29 MST (news.easynews.com) That is not correct. SQL Server you need to start a transaction and then commit or rollback the transaction. You don't need to use an update statement to undo your work. (If you did SQLServer wouldn't be ACID.) If you choose to run in autocommit mode then you would need to do such a thing, but that forgoes one of the major reasons one buys a commercial database product; for it's atomicity.(a series of statements either work as a unit or they do not - all or nothing, the end use shouldn't have to program the undo.) Jim "Kevin Krause" wrote in message news:3L9Y7.118665$BX4.7693026@e3500-atl1.usenetserver.com... > Actually, in SQL Server, there is no concept of a COMMIT (nor a ROLLBACK). > Quite different approaches in this area. Oracle is likely doing quite a bit > more work here, but is giving you options. If you change your mind using > SQL Server you would have to issue an UPDATE statement to undo your work > (easier said than done sometimes) or perform a recovery. In Oracle, if you > don't like what you see, you issue a ROLLBACK and voila, clean slate. > > Besides what has been recommended you could put the table in NOLOGGING mode > to get a little closer comparison. > > HTH. -Kevin > > "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.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!dfw.uu.net!sea.uu.net!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 <3RlY7.624$dK4.7119@rwcrnsc52> Control: cancel <3RlY7.624$dK4.7119@rwcrnsc52> Date: Wed, 2 Jan 2002 01:56:35 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009944084 21023 166.102.15.34 (2 Jan 2002 04:01:24 GMT) X-Complaints-To: abuse@navix.net NNTP-Posting-Date: 2 Jan 2002 04:01:24 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent? Xref: news.uni-stuttgart.de control:40277458 autocancel