Re: Why doesn't Oracle care about Linux as IBM does?

Hi Mark (welcome back),

There is a difference between required and tuning. Lets take a look at a clustered benchmark result on Oracle vs. one on DB2. So far Oracle 9i has only published a clustered result on TPC-H so we cannot talk free of marketing hype about OLTP (TPC-C). It seems however DW is important for Oracle as much as it is to DB2. Please refer to the full disclosure reports of the new TPC-H 3TB benchmark.

Now please explain:
* 22 pages of Table PARTITIONING for indexes

• 29 Pages of LOAD statements (for what, 8 tables?)
• Why Oracle turns messes with the latest enhancements to cache fusion: gc_files_to_locks = 2-350=10EACH (Oracle RAC Deployment manual says you shall not do that...)
• from the same manual (RAC Deployment):
  • To avoid excess overhead during peak processing periods, you should schedule massive deletions to occur during off-peak hours.
    • To reduce Real Application Clusters overhead, each instance in a cluster should ideally perform most DML operations against a set of database tables that is not frequently modified by other instances.
• ..and since we are at it: Why the rollbacks tatements I thought these are done and over with?

Here is an eye opening summary (3TB Orcale vs. 1TB DB2)

Oracle:
800 rollback segments (15 pages of create statements) 194 tablespace creation commands (13 pages of create statements) 11 pages of alter tablespace creation statements. 5 pages of create table ddl (for 8 tables). 29 pages of load statements to load 8 tables. 22 pages of ddl to create 3 indexes

DB2:
1/2 page load statement
8 tablespace creation commands (2 pages of create statements) 1/2 page of create table ddl
1/2 page of create index ddl

.. and now please come again and talk about the transparancy.

Since we have just turned the ship hard into Flame.. Maybe (both having fired one salvo) we can also take this offline - Or simply aggree that by the end of the day a cluster does benefit from some DDL and system tweaking. With different sweetspots on both DBMS.

Cheers
Serge Received on Thu Aug 16 2001 - 07:08:26 CDT