Re: [OffTopic] Curiosity about vision of the future for dba oracle ...

From: Stefan Knecht <>
Date: Sun, 12 Nov 2017 15:42:53 +0700
Message-ID: <>

Perhaps what Mladen is implying is businesses that do not have proper operational DBAs and then attempt to simply solve the problem by throwing more hardware at it.

But I do also doubt that - even in the cloud - this is more cost effective than hiring a proper DBA, particularly in the long run.

If you're attempting to solve every performance issue (some of which probably can, some certainly can't) by throwing more virtual servers at it, your costs will in all likelihood soon exceed that of a DBA's monthly pay.

Plus, as Stefan has said, single-threaded "problems" can't be solved by using more machines. So if you have an order that takes half an hour to process and you're loosing customers & sales because they're sick of waiting that long after clicking submit, you need to optimize your code. You can't solve that with more RAM or more CPU.

My THB 0.02 :)

On Sun, Nov 12, 2017 at 3:32 PM, Stefan Koehler <> wrote:

> Hey guys,
> i am sorry but i disagree.
> _at_ Mladen: Sure - adding more CPU or memory will give more resources to
> execute other stuff but it won't necessarily make your slow SQL statement
> processing (due to inefficient exec plans / data access) faster. Why should
> anybody pay for more and more resources (as data has the tendency to grow)
> just because of inefficient execution plans or SQL processing. Care about
> your SQL and application implementation / code and it will save you a lot
> of money (especially in cloud) and time. Cloud does not change anything
> here. So IMHO your statement "Cloud makes it easy to just add more memory
> and CPU and not bother with trifle things like optimizing your SQL for
> performance." is not true :)
> _at_ Mark: Sure - hardware providers and cloud vendors want to sell you
> hardware and/or computing time but this does not mean that this make sense
> (from a technical and business/economical point of view). If you go down
> this "simple hardware road" you will face some things like this very soon:
> "We’re starting to see a reverse cloud trend, Strohmeyer says. CIOs who
> were once excited to save on the capital expense of building or leasing
> more of their own data centers are now starting to see the long-term impact
> of the operating expense costs for things like Box, Amazon Web Services, or
> Microsoft. That stuff starts to get really expensive so they’re now looking
> at which workloads they can host cheaper themselves and which are best
> suited to the cloud, Strohmeyer says." -
> amazon-microsoft-google-sap-cloud/
> Best Regards
> Stefan Koehler
> Independent Oracle performance consultant and researcher
> Website:
> Twitter: _at_OracleSK
> > "Mark W. Farnham" hat am 11. November 2017 um 16:49 geschrieben:
> >
> > I believe you are both correct to a certain extent from distinct
> viewpoints.
> >
> > Cloud vendors might well through hardware at a problem to charge higher
> total fees until some critical process is of the variety that cannot be
> "hardwared out of" sufficiently to be accepted. Then the last remaining
> bastion of full service experience DBAs comes into play and the most
> resource consumptive and elongated response time bits of the software and
> hardware stack are corrected.
> >
> > So will demand for doing things well drop over time?
> >
> > I don't know and I believe it is difficult to project solution spaces
> for the simultaneous equation including variables of at least:
> > 1) Overall hardware capabilities including, but not limited to, reducing
> memory into cpu lag time and effectiveness of parallelism from the system
> to the application interface
> > 2) Total demand for computer horsepower
> > 3) Total demand for reduced elapsed time of very complex problems where
> a mistake in choosing the solution path can vary by orders of magnitude.
> > 4) Relative improvements over time in the underlying software to avoid
> costly mistake in choosing the solution path
> > 5) Network latency and bandwidth versus the demand to collate data from
> a variety of sources on the fly into a useful aggregation.
> >
> > I probably have left out more than I have included.
> >
> > I believe the solution is to plan to be very good at what you do from an
> axiomatic approach so that you understand the fundamentals and can shift
> the application of your skills as needed or compete for the possibly
> dwindling open seats for "database operator" folks who we count amongst
> DBAs.
> >
> > That prediction I think CAN be made: User interfaces to operational
> tools will improve in the sense of becoming less and the things that are
> tedious and only require somewhat complex automation will be cheaper to do
> with machines, so those job seats are in peril.
> >
> > -----Original Message-----
> > From: [mailto:oracle-l-bounce_at_
>] On Behalf Of Mladen Gogala
> > Sent: Saturday, November 11, 2017 10:11 AM
> > To: Stefan Koehler;
> > Subject: Re: [OffTopic] Curiosity about vision of the future for dba
> oracle ...
> >
> > Hi Stefan,
> >
> > Replies in-line.
> >
> > It will give you more resources to execute other stuff, therefore making
> the crisis less critical.
> --

zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at | Support our Indiegogo campaign at |

Received on Sun Nov 12 2017 - 09:42:53 CET

Original text of this message