Re: Future of Oracle DBA - Man vs Machine

Well, personally I don't think there's much more to it than marketing noise at this point.

Automatic upgrades - well, sounds fancy, but who actually wants that? Upgrades needs to be tested, evaluated, tested again, etc etc... And well, obviously there's the downtime involved, which needs to be scheduled, and so on and so forth. Unless they have magically overcome the need to actually do any of those things I don't see that happening. It's been a long standing issue with "zero downtime upgrades" ever since Oracle started announcing it, what, 10 years ago? I still haven't seen one to date (it is somewhat possible using application technologies, but not database technologies). If you were to present me a database with "automatic upgrade"; my first question would be "how do I turn it off?".

Automatic patches / security updates is the same thing. And I kinda doubt they can actually do that, particularly because as of today they still need a full cluster outage to apply an OJVM PSU (maybe Larry forgot about those since they are already getting rid of Java IIRC?).

The self-tuning they have already introduced in 12.1 with the adaptive optimizer. And we've seen where that went. They've apparently now disabled some of it again in 12.2 by default since it simply didn't work as expected in live environments.

Automated backups, well, most of us would already have that won't we? We schedule them and from that point on they are running automated. The one thing that's needed is of course to validate the backups and do the occasional test and I highly doubt anyone would blindly trust automation in that area. At least not if you care about your business.

I think that at this point, nothing will change. The one thing to take away from it for me personally is that it indicates the general direction Oracle is heading, which sounds a bit like a "hands-free don't touch it" black box.

At least that's my THB 0.02 :)

Stefan

On Wed, Oct 4, 2017 at 12:07 PM, AMIT VERMA <verma.labs_at_gmail.com> wrote:

> Hello Gurus,
>
> I was looking át OpenWorld, in which Larry presented Oracle18c in which
> many of the Oracle DBAs tasks are automated like-
>
> - Database Automatically Upgrades
>
> - Applying Software Patches
>
> - Oracle Tunes itself while running
>
> - Automates security updates
>
> - Backing up of data
>
> - Less compute & storage because of ML & Automatic compression
>
> After having 18c, The World first Autonomous Database than
>
> 1. What will be future of Oracle DBA roles for the new learner & existing
> DBAs?
> 2. Will Oracle guarantee 100% Autonomous Tuning, as we have observed many
> of the recommendation by existing tool even doesn't work in real production?
>
> Look forward to your valuable time on this Man vs Machine.
>
>
> --
> Amit Verma
> v.amit84_at_skype.com
>
>
> "Winning takes talent but it takes character to keep winning"
>

-- 
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | Support our Indiegogo campaign at igg.me/at/zztat |
_at_zztat_oracle

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