Hi Stefan,
Replies in-line.
On 11/11/2017 03:18 AM, Stefan Koehler wrote:
Hey Mladen,
Cloud makes it easy to just add more memory and CPU and not bother with trifleJust out of curiosity - How can adding more memory or CPU help you with SQLs
things like optimizing your SQL for performance.
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.
Define "we"? You are talking to a guy who has spent most of his 33 years long career as an Oracle DBA and is fairly adept at tuning. On the other end are management types who have never abandoned throwing hardware as a solution. Hardware vendors and now cloud vendors have always been promoting this approach.
I thought that we already overcame the mindset of solving a software/SQL
problem with hardware ;-)
Regards
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: @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.
