Re: [OffTopic] Curiosity about vision of the future for dba oracle ...
Date: Sat, 11 Nov 2017 09:18:03 +0100 (CET)
Message-ID: <779730484.115039.1510388283584_at_ox.hosteurope.de>
> 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 ....
- ... spent most time on logical I/O due to inefficient exec plans (single thread)
- ... spent most time on parsing (single thread)
- ... spent most time on sorting due to inefficient exec plans (single thread)
- ... spent most time on hashing/looping due to inefficient exec plans (single thread)
- ... 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-lReceived on Sat Nov 11 2017 - 09:18:03 CET