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

From: Stefan Koehler <contact_at_soocs.de>
Date: Sat, 11 Nov 2017 09:18:03 +0100 (CET)
Message-ID: <779730484.115039.1510388283584_at_ox.hosteurope.de>


Hey Mladen,

> Cloud makes it easy to just add more memory and CPU and not bother with trifle things like optimizing your SQL for performance.

Just out of curiosity - How can adding more memory or CPU help you with SQLs that ....

  1. ... spent most time on logical I/O due to inefficient exec plans (single thread)
  2. ... spent most time on parsing (single thread)
  3. ... spent most time on sorting due to inefficient exec plans (single thread)
  4. ... spent most time on hashing/looping due to inefficient exec plans (single thread)
  5. ... etc.

I thought that we already overcame the mindset of solving a software/SQL problem with hardware ;-)

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> Mladen Gogala hat am 11. November 2017 um 02:30 geschrieben:
>
> Oracle 18c is a long time away. It will be at least 3-4 years until you
> see the first ones in production. DBA job is dead now, not because of
> the smart databases, but because of DBaaS stuff and cloud in general.
> Cloud makes it easy to just add more memory and CPU and not bother with
> trifle things like optimizing your SQL for performance. With RDS, you
> don't even need to do backup. However, job of a SME is not dead, it only
> requires a different set of skills. The IT technology is still not at
> the level that would eliminate need for professionals. However, the DBA
> job itself is dead, just like the job of a saddle maker. If you want to
> make a career decision, being an Oracle DBA is not a good one.

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Nov 11 2017 - 09:18:03 CET

Original text of this message