Oracle 18c Impact on DBAs | Cons of Oracle 18c | Oracle 18c Disadvantages!

June 22, 2019  

Oracle 18c Impact on DBAs:

Larry Ellison has launched Oracle 18c which is fully autonomous database we can call it as future database has lot of automotive features. Different kind of rumors are spreading in the world that DBAs will be fired after the entry of this world’s first autonomous database which has capability to do complex task automatically. Oracle 18c is huge change. in Oracle technology. Most of Companies operational cost waste in Performance tuning and maintenance activities of database which are the key day to day activities of DBA. The patching activity is also costly and time consuming activity till oracle 12c.So in the world of automation we have seen the changes in technologies and oracle also needs to change its technology and reduce the cost in maintenance and tuning activities. So Oracle has developed new technology which is fully based on total automation based on machine learning which will reduce Human Efforts, Human Errors and Manual Tuning. So everyone have question in mind that what will be Oracle 18c Impact on DBAs?

Will DBA’s be fired?

Answer: “Big No”

So no need to worry for DBA’s. In each and every release every product will come up with new features. So oracle has come up with the new features like “self driving” and “Automotive” database. Following are day to day activities are every database administrators:

1.    Patching

2.    Database Tuning

3.    SQL Tuning

4.    Maintenance of database

5.    Database upgrades

6.    Database Installation 

Oracle 18c Advantages:

The oracle 18c uses machine learning robotic technology which will do all above activities automatically. It does not mean that database will automatically complete all instruction. Human needs to give the instructions to machine so that it will work as per given human instructions. So the DBA needs to get involved in giving those specific instructions to machine.

These are the following advantages of Oracle 18c database:

Reduce Complexity

Reduce Human Errors

Reduce Manual Management

Reduce Manual Performance Tuning

High Reliability

High Security

Less human Cost

Reduce human efforts

Here we note the word “Reduce” in spite of “Eliminate”. So Oracle 18c database is reduces the human efforts it does not mean that DBAs are not needed anymore to do any activities. DBA needs to ensure that all the functionalities will work fine and ensuring that security features of oracle is working fine.

Oracle 18c – DBA Tasks:

We know that oracle 18c is self driving and autonomous database there are lot of tasks needs to be taken care of DBA only. I explained in above paragraph that DBAs needs to give the machine different instructions regarding patching, installation and tuning. DBAs are also responsible for the security and backup maintenance of database. Following are some bullet points DBAs needs to work on while working with this new age database technology.

ð  Designing the different kind of Services of database

ð  Designing the memory space and hardware for the database

ð  DBAs are the resources who know about the cost of query in tuning and they will decide what will be the best execution plan for the query.

ð  Designing different kind of policies of database.

ð  Deciding the complex design of database.

Manage the new database technology that is Cloud based database technology.

So the Oracle 18c Impact on DBAs is they need to learn new technology which is actually the new age database management system. The DBAs are currently is fear of losing their database administration jobs but that is not true. Actually there are lot of new technologies DBA needs to learn to handle oracle 18c.There are following kinds of cloud services DBA needs to grab :

ð  Oracle Database Cloud Service

ð  Oracle bare metal cloud database service

ð  Oracle Database ExaData Cloud Service

ð  Oracle Database Express Cloud Service

ð  Autonomous Mode of Database.

With these kinds of services DBA also needs to learn about the new database mode that is “Autonomous Mode” of database. 

Changes in Database Activities:

In Oracle 18c the following database activates gets changed with this new version:

Oracle patching Automation:

Oracle already has mechanism of automation of patching activities but they are releasing this with this new age database technology. Now a days DBAs go to console and apply the different patches and releases. In this new age database technology they try to replace the patching activity through console to “Click”.

Just like any other software installation DBAs needs to install the patches or apply the patches by clicking it. Here DBA also needs to have the knowledge of where to apply the patches.

Database Performance Tuning:

Oracle uses version to version row based to cost based optimization. Tuning is nothing but improving the performance of sql query using different kind of techniques like indexing, re-indexing, partitioning which will improve the operational cost. Oracle 18c uses the artificial intelligence engine to tune the queries. We are using tuner advisors now a days to tune queries but they are not that much perfect. In 18c the indexing will done automatically and indexes are applied to specific table automatically to tune the queries.

Database Upgrades:

Oracle has worked hard to manage and automate the Database upgrades and PDB mechanisms. The database upgrades the new version by using the autonomous mode of database which is fully automatic using machine learning.

Less Administration:

Using this new age technology the administration cost reduces and time reduced for infrastructure management as well as patching upgrades and tuning too.

Innovation:

DBAs need to spend time on new innovations in database design, analytics and policies. Oracle 18c Impact on DBAs they need to spend the time on research and development of database design and analytics.  

Cons of Oracle 18c / Disadvantages of Oracle 18c Database:

The main and important question is who needs to be frightened with this new technology. Each system has pros and cons. There are bunch of people who will not accept the change and always working on old technologies. The DBAs who are always concentrating on doing the following simple tasks needs to be frightened with this new Oracle 18c Database:

ð  Operational DBA Checking backups

ð  DBAs that are only checking storage

ð  DBAs not involved in Performance Tuning activities

ð  DBAs doing only installation and patching activities manually

ð  DBAs that are creating duplicate environments

Note: Hope you like this article; If you like this article don’t forget to share it.