Re: rm RULE based optimizer != GOOD IDEA

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Sun, 24 Apr 2005 08:49:26 -0700 (PDT)
Message-ID: <20050424154926.21673.qmail@web52601.mail.yahoo.com>

I am not even sure after Oracle built the monster database with the monster CBO optimizer that they have the stuff to do the proper automated tests.

I used to learn that the test team (QA team) should be the best. I still have never seen such a company where the tests covered everything, and do not believe Oracle is going to spend more money that way then developing crazy database features except they are awaken from the "unbreakable" dream.

The phylosophy is to provide a lot of new features that only developers understand.
I am not even sure that in such big companies they can manage the quality of code. They are just firefighters for the biggest customers.

All these issues are becoming very big even for Oracle.
We were always laughing about Microsoft GPF and security bugs and so on, but it looks Oracle database in the last year or two are not to far.

They needed to drop RBO because could not cover the CBO code properly.
It looks that the CBO is so complex that our current databases are just Oracle's test environment. It will be nice to see the increase in the number of TAR's in the last few years and to which database areas they are related.

I am currently trying to explain to our customer DBA's how system statistics are good to collect, but it looks very hard when they can search and find so many bugs and issues related to them.
Internet is sometimes making things hard when you can find a lot of true/false stories.
Also because we need to test every fact Oracle is saying as fact becoming the bottleneck in developing IT systems.

It is looking ugly when you see that Oracle DBA's are frightened of new Oracle features or CBO.

Regards,
Zoran Martic

• Mladen Gogala <mgogala_at_allegientsystems.com> wrote:
  > Cary Millsap wrote:
  >
  > >But I don't think in 10g you can count on the
  > kernel always returning the
  > >right rows when you use it...
  > >
  > >
  > >
  > Which brings us back to the Lex de Haan's point
  > about regression
  > testing. He sad something to the effect
  > that we have no idea about the way that Oracle Corp.
  > is testing its
  > product when they allow such disastrous
  > bugs to slip through. I believe that Oracle is using
  > faith-based testing
  > algorithms. All we need is to have faith
  > and bugs will be gone.
  

  ---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Apr 24 2005 - 11:53:39 CDT