Comparison of DB2 and Oracle?

#91

DA Morgan <damorgan@x.washington.edu> wrote

Quote:

michael newport wrote:

Linux, Apache and PHP are succesful because there is a strong developer
and user community. Ingres doesn't have this, and making something
OpenSource doesn't cause this community to automatically build.

Linux, Apache and PHP did not start off successful. They grew.

Ingres has existed for a long time, the base IS there
comp.databases.ingres

The "base" is database developers not people that write kernel code in
C. They will all die of old age before they figure out how to give the
Ingres kernel capabilities that were in Oracle 8i.

Linux in particular benefited from the focus companies like Oracle, IBM
and others placed on it. The same level of focus is unlikely to happen
for Ingres.

Companies focus on Linux because it is free. A huge advantage.

Nonsense. Absolute ignorant nonsense. I consult for a division of The
Boeing company. The cost of an operating system compared to the total
cost of an application is so small as to be invisible. Do you really
think we are going to build a $15,000,000 system and worry about the
lousy few hundred or few thousand dollars for the O/S?

We chose Linux because it gave us better performance, in lab tests with
our application than did Win2K, WinXP, Solaris 2.9 and HP/UX 11i.

and the reason that Linux exists is that it answers a market need !
people are fed up of paying licence fee's for bloatware.

and as you say yourself a free product can give better performance
than its expensively licenced rivals !!

#92

Quote:

$400 is less than we spend in a week for free softdrinks for our
employees. Get a life.

see a dentist !

#93

Why Oracle and not DB2? There are numerous sound technical reasons.

And this..

==
/home/billy/> sqlplus dataware@whs
SQL*Plus: Release 9.2.0.5.0 - Production on Mon Nov 15 15:27:06 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data
Mining options
JServer Release 9.2.0.4.0 - Production

SQL> set timing on
SQL> select count(*) from x25_calls;

COUNT(*)
----------
672839836

Elapsed: 00:00:35.18

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 -
64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data
Mining options
JServer Release 9.2.0.4.0 - Production
==

Now anyone that have an idea what databases are about, will know what
a SELECT COUNT entails, I/O wise.. and how critical table and index
designs plays in optimising access and lowering I/O.

Can any other database, Open Source or commercial, come anywhere close
to this? I doubt it.

And no, this nothing to do with hardware. The above was run against an
old K-class HP-UX platform.

--
Billy

#94

what a dork...

Pete H
vslabs (AT) onwe (DOT) co.za (Billy Verreynne) wrote in message news:<1a75df45.0411152122.2d957181 (AT) posting (DOT) google.com>...

Quote:

Why Oracle and not DB2? There are numerous sound technical reasons.

And this..

==
/home/billy/> sqlplus dataware@whs
SQL*Plus: Release 9.2.0.5.0 - Production on Mon Nov 15 15:27:06 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data
Mining options
JServer Release 9.2.0.4.0 - Production

SQL> set timing on
SQL> select count(*) from x25_calls;

COUNT(*)
----------
672839836

Elapsed: 00:00:35.18

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 -
64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data
Mining options
JServer Release 9.2.0.4.0 - Production
==

Now anyone that have an idea what databases are about, will know what
a SELECT COUNT entails, I/O wise.. and how critical table and index
designs plays in optimising access and lowering I/O.

Can any other database, Open Source or commercial, come anywhere close
to this? I doubt it.

And no, this nothing to do with hardware. The above was run against an
old K-class HP-UX platform.

#95

phazzard (AT) intellicare (DOT) com (Pete H) wrote:

Quote:

what a dork...

And that is the best you can do Pete in response to a [SELECT COUNT]
on a VLT containing 672,839,836 rows that returns the answer in 35
seconds?

I've read Oracle being slammed for this and that and what not. So
instead of responding in kind, I simply show what Oracle is capable of
in the real world.

It is also not about counting rows in general. It is *what* it entails
(think I/O) and *how* it does it.

And the How It Is Done is what differentiate Oracle from others.
Inovative means of providing accurate and consistent answers - thus
enabling this very visible performance with a [SELECT COUNT]. And
this type of innovation and performance is across the board. Not just
with a [SELECT COUNT]. Though the latter tend to drive home the point
with an extra sharp and shiny edge.

--
Billy

#96

In article <ed737cdd.0410262321.74457b00 (AT) posting (DOT) google.com> info (AT) Boecker-OCP (DOT) com (Yukonkid) wrote:

Quote:

"Rhino" <rhino1 (AT) NOSPAM (DOT) sympatico.ca> wrote

One of my friends, Scott, is a consultant who doesn't currently have
newsgroup access so I am asking these questions for him. I'll be telling him
how to monitor the answers via Google Newsgroup searches.

Scott has heard a lot of hype about DB2 and Oracle and is trying to
understand the pros and cons of each product. I'm quite familiar with DB2
but have never used Oracle so I can't make any meaningful comparisons for
him. He does not have a lot of database background but sometimes has to
choose or recommend a database to his clients.

Scott has enough life-experience to take the marketing information produced
by IBM and Oracle with a grain of salt and would like to hear from real
DBAs, especially ones who are fluent with both products, for their views on
two questions:

1. What are the pros and cons of the current releases of DB2 and Oracle?

2. What other sources of *independent* information are available to help
someone new to databases choose between DB2 and Oracle?

This is *not* a troll and we don't want to start a flame war! Scott just
want some honest facts to help him decide which product is best at which
jobs.

Hi,

Point made.

Quote:

without going into much religious talking, ask yourself:

Give neither counsel nor salt till you are asked for it.

Quote:

How many OS versions of DB2 are on the market?
How many OS versions of Oracle?

How?

Quote:

For DB2 you find different databases for quite every platform (OS 390,
UNIX, AIX, mainframe...) - name it. For every problem they have a
database - incompatible between each other...
In Oracle you deal with the same architecture on every OS platform
they support.

Are you positive about that?

Quote:

Some of the things I like in Oracle

Do you wonder if you like in oracle?

Quote:

* a lot of features to select from (Oracles index types i.e.)
* the shared sql approach
* multi-versioning and read consistency implementation (SELECT without
being blocked by writes i.e.)

Those found in their towards world understanding report.

Quote:

yk

Oh ...

Quote:

at least, all databases return the data that you store,

Why are you so positive?

--
Lady Chatterly

"Getting your ass kicked again I see. Lady C is quickly becomeing my
hero." -- Crawdad

#97

In article <63b202d.0410290147.47f89e39 (AT) posting (DOT) google.com> michaelnewport (AT) yahoo (DOT) com (michael newport) wrote:

Quote:

Serge,

would you like to see these other IBM products OpenSourced ?

I see what you mean.

Quote:

Regards
Michael Newport

Why are you so sure?

--
Lady Chatterly

"I don't know who she is. I doubt that its a bot. I have my guess as
to who it is. Regard the frequency of posts. What frequent poster is
missing? That Be Packing, is an old mind trick. Ignore it." -- Pip

#98

Carex,

Totally not supported but try:

./runInstaller - ignoreSysPrereqs

Ofcourse no support and not recommended at all, but propably will work.

Cheers,

Jahudi

carex wrote:

Quote:

Hi,

A few years ago (2000 ?) I installed an oracle client on a linux server
(oracle8iR2 on Debian Woody) and everything went beautifully. (with
DBD::Oracle)

Now, I need an oracle client on my new laptop. (debian Sarge)

I tried oracle 10g instant client but whitout success. See below.

zorro@armada:~/tmpOra/instantclient10_1$ ls -al
total 85788
drwxr-xr-x 2 zorro zorro 4096 2005-05-24 17:11 .
drwxr-xr-x 3 zorro zorro 4096 2005-05-23 19:02 ..
-rwxr-xr-x 1 zorro zorro 14428 2005-05-24 17:11 a.out
-r--r--r-- 1 zorro zorro 1461081 2004-11-08 21:25 classes12.jar
-r--r--r-- 1 zorro zorro 1353 2004-11-08 21:25 glogin.sql
-rwxr-xr-x 1 zorro zorro 13495923 2004-11-08 21:25 libclntsh.so.10.1
-r-xr-xr-x 1 zorro zorro 2121849 2004-11-08 21:25 libnnz10.so
-rwxr-xr-x 1 zorro zorro 1229425 2004-11-08 21:51 libocci10_296.so.10.1
-rwxr-xr-x 1 zorro zorro 913575 2004-11-08 21:25 libocci.so.10.1
-rwxr-xr-x 1 zorro zorro 66159152 2004-11-08 21:25 libociei.so
-rwxr-xr-x 1 zorro zorro 96517 2004-11-08 21:25 libocijdbc10.so
-rwxr-xr-x 1 zorro zorro 760686 2004-11-08 21:25 libsqlplus.so
-r--r--r-- 1 zorro zorro 1397543 2004-11-08 21:25 ojdbc14.jar
-r--r--r-- 1 zorro zorro 21299 2004-11-08 21:25 README_IC.htm
-rwxr-xr-x 1 zorro zorro 14428 2004-11-08 21:25 sqlplus
zorro@armada:~/tmpOra/instantclient10_1$ ./sqlplus
./sqlplus: error while loading shared libraries: libsqlplus.so: cannot
open shared object file: No such file or directory
zorro@armada:~/tmpOra/instantclient10_1$

Then I tried to install the client (ship.client.lnx32.cpio)
But this seems not to be possibe on a Debian. Dee below

zorro@armada:~/tmpOra2/Disk1$ ls -al
total 36
drwxr-xr-x 6 zorro zorro 4096 2004-10-21 01:06 .
drwxr-xr-x 3 zorro zorro 4096 2005-05-24 15:37 ..
drwxrwxr-x 8 zorro zorro 4096 2004-10-21 20:40 doc
drwxr-xr-x 4 zorro zorro 4096 2004-10-20 07:56 install
drwxr-xr-x 2 zorro zorro 4096 2004-10-20 07:56 response
-rwxr-xr-x 1 zorro zorro 1487 2004-10-20 07:56 runInstaller
drwxr-xr-x 7 zorro zorro 4096 2004-11-21 22:25 stage
-rwxrwxr-x 1 zorro zorro 4408 2004-10-21 01:06 welcome.htm
zorro@armada:~/tmpOra2/Disk1$ ./runInstaller
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-2.1, redhat-3, SuSE-9,
SuSE-8 or UnitedLinux-1.0
Failed

And now I do not know what to do.
I did also try to install the old oracle8iR2 but also without success.

So, has someone already successfully installed an oracle client in Debian
Sarge ??? (and DBD::Oracle)

If yes, could I have a few tips about this install ??

Thanks
carex

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Comparison of DB2 and Oracle?

comp.databases.oracle comp.databases.oracle

Re: Comparison of DB2 and Oracle? - 10-30-2004 , 09:37 AM

Re: Comparison of DB2 and Oracle? - 10-31-2004 , 05:32 AM

Re: Comparison of DB2 and Oracle? - 11-15-2004 , 11:22 PM

Re: Comparison of DB2 and Oracle? - 11-16-2004 , 09:45 AM

Re: Comparison of DB2 and Oracle? - 11-17-2004 , 12:16 AM

Re: Comparison of DB2 and Oracle? - 11-17-2004 , 10:55 PM

Re: Comparison of DB2 and Oracle? - 11-17-2004 , 10:55 PM

Re: install oracle client on Debian - 05-28-2005 , 03:31 PM