Jim Lawrence
accessd at shaw.ca
Tue Sep 20 13:01:19 CDT 2011
Gustav: Actually, you can down load Oracles full enterprise version (at least the last time I looked...Oracle version 11i) but it is limited in how many connection and users can have access to it. In addition, if you do call for support you will be directed to a local resource person(s). This system was created so computer science students and small consultant firms could get up to speed in the product. The major difference between Oracle and MS SQL is that in Oracle you can modify and optimize everything. Managing queues, temp tables, transactions, sizes and recovery points. Microsoft has chosen to eliminate or automate most of the fine-tuning part of data management. This is good and it is bad. OOH, a tech can spend years learning the black-art of database control, tuning everything to the nth degree as well as building a very precise set of reports and intergrating various Oracle servers. Rest assured, if a company has a medium and larger site there must be a full-time tech there. Oracle is also very careful on just how many techs are allowed to pass their exams so the rate at which a fully qualified Oracle tech is paid very well. OTOH, a MS SQL site is far more easily setup. A person with a bit of database knowledge can put together a stable SQL site in less than a day. It may not be a fully optimized site but it will work and render the expected results. Some tech can learn as they go and MS is not concerned about whether the person asking for database support is a person that owns a plumbing company or a fully certified tech. Microsoft's exams, though thorough, do not restrict the number of qualified graduates...the more the merrier. The rate a small company will pay a MS SQL qualified person is usually much lower than an Oracle tech with similar qualifications. Much like Microsoft has entrenched itself in new desktop computers and the office application markets, Oracle has tied up most of the high end database market. The other major difference is cost; MS SQL is about a third of the cost of an Oracle suite. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Tuesday, September 20, 2011 12:25 AM To: accessd at databaseadvisors.com; dba-sqlserver at databaseadvisors.com Subject: Re: [AccessD] [dba-SQLServer] Oracle 11g EX (was: MySQL) Hi Arthur et al Also Oracle sports a free Express version, Oracle 11g XE with these limitations: * Maximum database size is 11 GB * Maximum RAM it will use is 1 GB * Only one instance can be installed on a single computer * Uses only a single CPU Here is a guide for the Windows installation (for people like JC encountering the unknown!): http://www.codeproject.com/KB/database/InstallOracle11gXE.aspx Not that I have used it or intend to do so. The last time I tried (Oracle 8i?) it installed a monster suite of tools and yet you had to deal with manual editing of ora files etc. ... I felt much like JC does now facing the WAMP package. Things may have changed, I know, I'm just not ready to meet the challenge (= have no purpose for it). /gustav -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Saturday, September 17, 2011 6:53 PM To: Discussion concerning MS SQL Server Subject: Re: [dba-SQLServer] [AccessD] MySQL There are some nice things about MySQL but on the other hand I definitely do not like where Oracle is going with this puppy since its acquisition of Sun and by inheritance MySQL. I'm still on the fence about these developments, but quite frankly I am leaning against Oracle on all these transmutations of what was originally a simple, straightforward approach. At last recollection, Monty has departed, and with him, I fear, has the guiding vision of this product. Frankly, I am all over the place on where next to go: I look at Mongo and see it exquisite for web-apps but not for OLTP situations. I look at PostGreSQL and think it's got a bunch of things right. I look at Oracle and MS-SQL and think they have some things right as well. I frankly do not have any clue into which basket to toss my next eggs. Arthur -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com