Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Changing isolation level? ++ scenarios
While stranded on information super highway Daniel Morgan wrote:
:)Joel Garry wrote:
:)
:)> vslabs_at_onwe.co.za (Billy Verreynne) wrote in message news:<1a75df45.0312042357.5c158776_at_posting.google.com>...
:)>
:)>>The bottom line IMO is information. Provide the business with
:)>>information in order for them to make their decisions. Isolation
:)>>levels are not an issue - not if you use Oracle correctly and not if
:)>>you design your app & database correctly.
:)>
:)>
:)> That's correct as far as it goes, but one of the OP's points was that
:)> it was designed correctly, and has been proven in the business for
:)> years. So he's asking how to use Oracle correctly to do what has been
:)> designed correctly, and unfortunately the answer is as hjr pointed
:)> out. Another way of saying it is, Oracle's design tradeoffs make this
:)> particular issue difficult to work with using Oracle's normal design
:)> constraints.
:)>
:)> jg
:)> --
:)> @home.com is bogus.
:)> The fan hits the crap:
:)> http://www.cnn.com/2003/US/West/12/04/blimp.crash/index.html The
:)> "ground" they refer to was actually a pile of manure.
:)
:)I completely disagree with your analysis. Turn the situation around and
:)you'll see why.
:)
:)Suppose the original application had been built in Oracle where is was
:)designed to be compatible with reads not blocking writes, writes not
:)blocking reads, no lock escallation, etc. It too would work perfectly.
:)
:)Then you would try to rehost on another RDBMS and you'd have the exact
:)same complaint.
:)
:)The point is not that one is right and one wrong. Not that one is better
:)and one worse. Rather that each is different and intelligent people read
:)the Concepts books, read the Architecture books, and make modifications
:)to optimize their work for the tool they are using. Same as there is
:)nothing that makes screws better than nails but you won't get very far
:)trying to get nails into a 2x4 with a screwdriver.
:)
I don't think anyone said that it was wrong. As I have said it and Joel also suggested the application has worked without any problems for years and over different data access method. Oracle is different so I have to code around that. It would be a nightmare, if I redesign application everytime I have to port to another data access method.
:)--
:)Daniel Morgan
:)http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
:)http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
:)damorgan_at_x.washington.edu
:)(replace 'x' with a 'u' to reply)
:)
-- Hemant Shah /"\ ASCII ribbon campaign E-mail: NoJunkMailshah_at_xnet.com \ / --------------------- X against HTML mail TO REPLY, REMOVE NoJunkMail / \ and postings FROM MY E-MAIL ADDRESS. -----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------ I haven't lost my mind, Above opinions are mine only. it's backed up on tape somewhere. Others can have their own.Received on Fri Dec 05 2003 - 17:19:06 CST