[AccessD] [dba-SQLServer] Oracle 11g EX (was: MySQL)

Jim Lawrence accessd at shaw.ca
Wed Sep 21 08:38:25 CDT 2011


Agreed.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, September 21, 2011 1:13 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] [dba-SQLServer] Oracle 11g EX (was: MySQL)

Hi Jim

Yes, as I remember OTN (haven't checked recently) - and contrary to MS, you
can download _everything_ to test with no limits and use in development.
However, as soon you use the software for whatever other purpose, you have
to pay the big money including the fee for your lawyer to check the
book-sized license agreement.

The XE, however, is free to use in production.

/gustav


>>> accessd at shaw.ca 20-09-2011 20:01 >>>
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




More information about the AccessD mailing list