Re: Introduce an innovative machine tuning tool for SQL statements
Date: Sat, 23 Dec 2017 21:08:31 -0000 (UTC)
Message-ID: <p1mgkf$n4g$1_at_dont-email.me>
On Thu, 14 Dec 2017 11:49:43 -0800, Ed Prochak wrote:
+AD4 On Tuesday, December 12, 2017 at 4:53:18 AM UTC-5, trac...+AEA-gmail.com
+AD4 wrote:
+AD4APg On Tuesday, December 12, 2017 at 5:46:08 PM UTC+-8, Noons wrote:
+AD4APg +AD4 On 12/12/2017 8:36 +AEA-wiz, tracyto41+AEA-gmail.com wrote:
+AD4APg +AD4
+AD4 +AFsAXQ
+AD4APg +AD4 +AD4 there are more than 100 hints from Oracle, if you pick 3 out from
+AD4APg +AD4 +AD4 the 100 hints, the permutations is up to 1 million. No brute force
+AD4APg +AD4 +AD4 can do it in your database.
+AD4APg +AD4 +AD4
+AD4APg +AD4 +AD4
+AD4APg +AD4
+AD4APg +AD4 Precisely. So why advertise that Tosska crap as a product that can
+AD4APg +AD4 do it? Unless of course this:
+AD4APg +AD4
+AD4APg +AD4 +ACI-in which the engine tries every possible Oracle Hints combinations
+AD4APg +AD4 for a SQL statement to improve the execution speed+ACI
+AD4APg +AD4
+AD4APg +AD4 doesn't now mean a brute force approach?
+AD4APg
+AD4APg Yes, you are right. It should be
+AD4APg
+AD4APg +ACI-in which the engine tries every possible effective Oracle Hints
+AD4APg combinations for .....+ACI
+AD4
+AD4 So it uses some heuristic algorithms.
+AD4 Somehow it is better than an experienced DBA?
Probably cheaper. Not the same results, but accurate enough and cheaper.
One of the few defeats for Oracle RDBMS was handed down to Larry by the
Microsoft Corp. The most prevalent marketing pitch for SQL Server at the
time was that anyone who knows Windows can be a DBA for SQL Server. And
Oracle has worked hard to eliminate the role of a DBA. They have almost
succeeded. Unfortunately for them, SQL Server pitch is no longer +ACI-it's
much cheaper and you don't need a DBA+ACI, but +ACI-it's almost as good as
Oracle and much cheaper than Oracle. A good SQL Server DBA is much
cheaper than a good Oracle DBA+ACI. What Oracle needs is a DBA who will know
every nook and cranny of the product and make much greater investment
into the database software worthwhile, if it's even possible.
[Quoted] [Quoted] Unfortunately, Oracle Corp. has turned a caste of competent DBA personnel
[Quoted] [Quoted] into bitter enemies. Unfortunately, such people would be needed now more
than ever, to employ their vast technical knowledge and experience and
give Oracle some wind beneath its wing. I am afraid that DEC story is
about to be repeated.
+AD4
+AD4 I'm not seeing the benefit.
+AD4
It's not meant for you, it's meant for your PHB. Your PHB is the guy who signs the check.
-- Mladen Gogala Database Consultant http://mgogala.byethost5.comReceived on Sat Dec 23 2017 - 22:08:31 CET