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

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

It will give you more resources to execute other stuff, therefore making the crisis less critical.

>
> I thought that we already overcame the mindset of solving a software/SQL problem with hardware ;-)
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.

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

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

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