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

From: Stefan Koehler <>
Date: Sun, 12 Nov 2017 09:32:21 +0100 (CET)
Message-ID: <>

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." -

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: [] 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.

Received on Sun Nov 12 2017 - 09:32:21 CET

Original text of this message