Oracle 18c and Its Impact on DBAs

Oracle Database 18c the next generation of the industry-leading database.

Oracle introduces the world's first autonomous database cloud. Oracle Autonomous Database Cloud eliminates complexity, human error, and manual management, helping to ensure higher reliability, security, and more operational efficiency at the lowest cost.


Copied well written article by Joel Per├ęz and Skant Gupta regarding Oracle 18c from Oracle community which will definitely help to DBAs who are worrying about future. Below is the full article.

“DBAs will be fired.. ? It’s the end of DBAs because of the Autonomous Databases..?

Obviously not.. believe it or not.. now the DBAs will have more important role in enterprises.

I have +17 years as Oracle DBA and I could tell you how this profession have been evolving, having a tendency of:
  • More elaborated and advanced features.. that’s the essence of every new release..
  • More automated tasks release by release.. the DBAs and Enterprises must realise real advantages to perform early or convenient upgrades before the “Non support of Release” force them to do it..
  • and above all.. how to become DBA each day is even more complex than before.. and who will be affected by this.. this is the main point I want to focus in this short article.

Oracle Database 18c the next generation of the industry-leading database.
Oracle introduces the world's first autonomous database cloud. Oracle Autonomous Database Cloud eliminates complexity, human error, and manual management, helping to ensure higher reliability, security, and more operational efficiency at the lowest cost.

At the previous paragraph I have highlighted the sentences "database cloud" & "Oracle Autonomous Database Cloud", it means.. when we are talking about Cloud Databases, Oracle Autonomous Database Cloud is just another different kind of Cloud database service, so, in this article we will call it simply as "Cloud Databases".

Autonomous Databases/Cloud Databases.. is a subject that could be analyzed from different points of views. Most of articles and publications focus in how ideal would be a futuristic database etc..

but Let’s think for a minute..
Who will decide under what kind of service the databases will be.. ?
Who will implant the policies for those autonomous databases ?
Who will have the knowledge to decide or estimate the cost of these services based on the regular activities of those databases ?
Who will decide the complex design of IT Infrastructure when we have more and more options.. ?
The answer is obvious.. a DBA.. not any simple DBA.. a DBA that has evolved with all this new generation of databases on Cloud.

Oracle Autonomous Database as I mentioned before is a kind of different type of a Cloud Database. So.. in order to move that database from "On-prem" or create it from zero, a DBA must be needed..

Oracle Autonomous Database is a kind of database with a lot of mundane tasks already automated such as:
  • Applying of Patches
  • Upgrades
  • and Tunes itself..

The more important section of this article is the following

I will use the exact smart words of my colleague Tim Hall ( Oracle ACE Director ) "18c on-prem will have very little impact on DBAs. It is the Autonomous Database suite of services that have the impact"
  • “18c on-prem will have very little impact on DBAs”, Yes.. Exactly, Oracle 18c is just another higher version, “Oracle 18c” is not a relational database manager software that will work by default in autonomus mode
  • “It is the Autonomous Database suite of services that have the impact”, Autonomous databases is a kind of suit of services that will be available for “Oracle Public Cloud”, this means that “On-Prem” databases will not work in autonomous mode “until what we know up to now..”, perhaps later that kind of service could be available for “On-prem databases”

Most of DBAs currently are in fear believing “Autonomous Databases suite of Services” will let them without job.. but the reality is not even near to that.. actually there are several kind of services to lodge a database on Cloud:
  • Oracle Database Cloud Service
  • Oracle Bare Metal Cloud Database Service
  • Oracle Database Exadata Cloud Service
  • Oracle Database Exadata Cloud Machine
  • Oracle Database Express Cloud Service
“Autonomous Databases suite of Services”  will represent just other possible services you could contract
So:
Oracle 18c is not Autonomous Database suit of Services
Autonomous Database Service suit of Services is not Oracle 18c
Autonomous Database suit of Services is a kind of services available up to now just for Oracle Public Cloud
Oracle 18c is just one release more

So.. with those lines you have got the more important section of this article.
The conclusion is that "Oracle 18c" will have little impact for the regular "On-prem" databases.

Now, Let's extend this conversation..

But Let's wait a minute.. Let's analyze every one of those.. how it can be done today with the regular "Oracle Database Cloud Service (DBCS)" and how we think Oracle will do it.. We talk about "How Oracle will do it.. because the debut of Autonomous Datawarehouse Database Cloud will be in December 2017.

Applying of Patches

Nowadays, if you want to apply a Patch using DBCA is just to go to the console, see on the screen if there is any available patch for that database and make some clicks to apply it.. So simple..

So.. I think is not "so difficult" for Oracle Corp, replace our clicks for an automated process..

There are some patches that require the database must be stopped because they change binaries.. etc.. well.. most probable Oracle had already a mechanism in order to apply patches having the database running and they have decided to release it now.. 

If we imagine how work the database inside running sequentially sentences.. etc.. every sentence.. operations.. etc all this can be coordinated so that patches affect in some way "post" sentences.. etc.. in a general way what I'm trying to say is.. the fact of applying patches by itself is not the big thing taking into account the level of development of the Oracle product during years.. So.. the applying patch by itself is just a step forward related to levels of automation.

Upgrades

Up to now when you are working with DBCS the only way to upgrade a database already working in the cloud is creating another service which will have another compute node and we apply a regular procedure to upgrade that database. However, we have to remember that Oracle has been working very hard in establish very advance mechanism to manage PDB. Nowadays we can clone PDB in hot, we can move PDBs from one container to another container in hot.. basically is very alike to the mechanism implanted to move a datafile online.. so.. this technology is extreme mature by the Oracle Software in these times.. So.. 

Upgrade a database must be surely a procedure a alike to what is done with PDB, the CDB in its root definition has the binaries of the corresponding version and we move just the data. I'm "sure".. that's the mechanism the Oracle software will use to upgrade databases in hot. So.. if we realise all I have commented.. all this is just a technology that we are using with the current release.. difference in autonomous databases is that they are applying this procedure with complete databases under this kind of new service.

Note : later of writing this article my colleague Tim Hall ( Oracle ACE Director ) had helped me to clarify that element, these are the exact words of Tim
"Oracle have explained how the upgrades and patches will work. These systems are based on 18c running on Exadata. Since 18c allows rolling upgrades and patches for everything, including OJVM, they are able to do online patches for these services"
Thanks Tim!!

Tunes itself

It is even more easy to explain.. when you tune queries using adaptive technics.. etc.. all this can happen with the databases running.. rebuild indexes online.. etc.. must of tune operations nowadays can be done online.. it's not so difficult to have an AI ( Artificial Intelligence ) engine collecting data and taking some decisions based on internal tests.. statistics.. etc.. so.. this new level of automation/autonomous is just what we have but being done automatically.

Let's talk with what frequency we do these tasks:

Applying of Patches: time to time.. It's not so frequent.. so.. there are not too much changes to appreciate in the time we employ in this task

Upgrades: even less.. it's very seldom when we apply upgrades to the databases.. so.. there are not too much changes to appreciate in the time we employ in this task

Tunes itself: tuning.. yes.. many companies.. consultants.. etc.. employ a lot of time in constant tuning to databases for many reasons.. it's very common that some objects.. some queries.. some code.. etc are added, removed.. changed in the database and of course this generation variations in the performance. This point could impact relatively high the cost of many enterprises, because tuning a database constantly imply constant high costs. Of course.. we have to see how good the engine can be done this. We have to remember that currently we have available "Tuning advisors" and they are not perfect.. sometimes we apply some recommendations and the performance of some executions.. etc.. become worst.. so.. the factor of "Tuning itself".. really.. thinking very honest.. we have to see how that will work. If the results are very good and convenient.. definitely this factor will reduce a lot of cost to enterprises and of course will affect in some way DBAs specialized or in charge of tuning.

So.. one important thing to think.. You guess Enterprises with extreme important databases will allow to run all these tuning.. etc.. by itself without someone that can be monitoring what the database is doing.. ?

We are going to be honest.. Enterprises with critical databases will not allow to give the 100% of confidence to an engine software to tune itself on demand without control or supervision of a human. Of course, there are some databases.. under some levels of importance.. circumstances that fit that model.. to be tuned 100% without supervision but that not the regular cases.

That self tuning will have sections.. factor.. policies.. etc.. and DBAs will choose what elements could be tune by itself.. and which of them will keep under control of DBAs. At the end.. always DBAs will be needed.. Now DBAs will have more facilities to do their jobs more easy.. but that fact of thinking to replace totally the humans is something difficult to happen in spite of the engine can take correct decisions.

Let's describe a simple example.. Oracle Data Guard has the option to FAILOVER automatically under some circumstances, but for some possible humans errors could happen a database can failover when the humans did not want it.. so.. most of enterprises they fear to use FSF ( Fast Start Failover ), It's a mechanism that works perfect technically but to give the total control to the software to apply something critical to the data is something most of enterprises are not allow to implant.

In a general way I think autonomous databases will reduce tons of working hours for DBAs but will not represent in a practical and real way the elimination of Human presence.

So, autonomous databases promises the following:

Less time on Administration
- Less time on infrastructure
- Less time on patching, upgrades
- Less time on ensuring availability
- Less time on tuning

More time on Innovation
- More time on database design
- More time on data analytics
- More time on data polices
- and very important.. More time on securing data

So.. with databases on Cloud, DBAs must strength their skills in Security

Now Let's jump to another point of analysis..

17 years ago.. it was so simple to design a database architecture. You had to decide to lodge your database in a:
  • Server..
  • Or in a Mainframe
  • Or even in a regular desktop machine in some cases..
Now, when DBAs will decide where to lodge databases must think in many options.. such as:
  • - Servers..
  • - Virtual Machines
  • - Engineering Systems such as “Exadata”
  • - and more..
They have to decide if the architecture will be implanted:
  • - “On-Prem” as the regular option
  • - Cloud in our own data center ( Private Cloud )
  • - Hybrid Cloud
  • - Public Cloud, now the public Cloud has more options with autonomous databases in Oracle18c.. etc

and more and more..

Before was so simple to design a database architecture.. now not.. Now we have a lot of options.. each one with pros and cons. Basically is a sea of options..

So.. the question is.. Who will be in charge of designing all this.. ?
The General Managers ? obviously not.. this will decide by Database Architects.. ( DBAs )

Now DBAs will be asked more to understand the business rather than just the mechanics of keeping the database healthy and running

Before the cost of Servers.. services.. etc.. was not the main thing with what DBAs had to deal.. they were focused just in keeping the database running and implanting them. Now is different.. , now creating a database in Cloud, for example.. implies a decision of what kind of service to use and in what mode.. “Metered.. Non-Metered..” etc.. those factors impact directly the economy of the enterprise and the mode of operating these databases, so.. now the DBAs are more related into the business.

Some years ago from the first minute Oracle Corp. announced the release of “Oracle Cloud”, another level of expertise for DBAs was born, turning this business more complex..
DBAs will not be fired.. now the roles of DBAs are even more important.. the role of DBAs is simply shifting to be more of a role of architect..

Who must worry because of all these changes.. ?

Those kind of operational DBAs who are or were in charge just of doing simple tasks.. such as:
- Checking Backups..
- Checking storage..
- Making some reports..
- Installing Patchs..
- Installing softwares..
- Creating constantly new environments for developers..

All those easy and simple tasks.. have been removing with the addition of automation in Oracle Releases..

For instance, now at the time of creating an Oracle Database Cloud Service, there are many elements created automatically including:

- The creation of compute node ( Host )
- Installation of Software
- and more..

So.. with just this simple example.. you can realise that at the time of working with Oracle Database Cloud Service you do not have to install softwares anymore..

If you want to create a RAC configuration in a using Oracle Database Cloud Service is just some simple clicks and you could have complex RAC-DG configurations.

The era of regular and boring tasks is getting away.. so.. if you are a DBA in charge of those kind of simple tasks.. yes.. worry about your future..

Contrary of this, if you are a DBA in charge of implanting MAA architectures.. Cloud Databases, Exadata.. etc.. happy for you.. the importance of your role now will be bigger..

So.. now we come back to the central point of this article..
you can imagine what will the vision of a person that is starting as DBA with all these numerous options in the market.. A person that is barely learning SQL.. and “Create table..” etc.. when the market is talking about autonomous databases.. It’s a comparison like between a kid bike and one 1000cc Motorbike.. something like that..

My though about all this is:

#1.- DBAs with kind of regular maintenance tasks.. could be removing from their role or job if they do not evolve to be focused in all this new generation related to Cloud

#2.- DBAs that have got the privilege to work with Oracle Databases during the golden era of “On-prem” databases, now they are in the right time to grow in parallel with something that is defining the “before” and “after” of IT. Now the DBAs will have the opportunity to move into a more strategic role in their organisations and based on that the income "salary.. commissions.. etc" will be higher.. now you will be involved in important decisions for the company 

#3.- Sorry for new DBAs entering in this database world.. the journey you have to run is even harder than before to get the top level in this area because day by day are generated more and more options

Conclusion

1.- If you are a DBA kind #1 according to the previous description, perhaps you have several options.. evolve to #2, or if you decide to stay in the same role, your payment could be less over time or your role could be slowly disappear.

2.- If you are a DBA kind #2, keep on the track.. and your role will be more and more important in this field, by consequence your payment will have high probabilities to be increased. One more thing.. most of DBAs will not reach to be Cloud architects because this require time of study.. researching.. testing.. etc.. so.. feel proud if you reach it and take advantage of that inside your current or future organizations

3.-   If you are a DBA kind #3, do not give up.. do not see the journey too long as It really is, just keep learning and you will get the level to be a good competitor in the market.

Oracle Exadata Cloud Machine Features and Benefits

Oracle Exadata Cloud Machine delivers the full power of the Oracle Exadata Cloud Service that resides in Oracle's public cloud to customers who require or prefer their databases to be located on-premises.

For many years, Oracle Exadata has been the platform of choice for running mission critical Oracle databases at thousands of customers, and the Oracle Exadata Cloud Machine extends this value proposition to those customers who want cloud benefits but cannot or aren't yet ready to move to a public cloud.


The business model is just like a public cloud subscription; the hardware and software is the same; Oracle experts monitor and manage the infrastructure; and the same tools used in Oracle's public cloud are used to provision resources on the Cloud Machine.

With Oracle Exadata Cloud Machine, customers have subscription access to the most powerful Oracle Database with all options and features, like Real Application Clusters, Database In-Memory, Active Data Guard and Advanced Security, offering extremely high levels of performance, availability and security features for mission-critical workloads.  

Additionally, the Oracle Exadata Cloud Machine is 100 percent compatible with on-premises and Oracle Cloud applications and databases, ensuring any existing application can be quickly migrated to the cloud without changes.

Features:
  • Enables Oracle RAC Databases (11.2.0.4 or 12.1.0.2) on Exadata
  • Highly proven database hardware platform with NVMe Flash, InfiniBand networking, and the fastest servers
  • All Database Options, Enterprise Manager Database Packs available
  • Intelligent database platform with Smart Database Algorithms in storage, networking, and compute
  • Advanced database cloud platform with subscription based pricing and real-time online capacity bursting
  • Comprehensive database management through Oracle Enterprise Manager, as well as Cloud-based self-service
  • Flexible cloud that can be deployed in Oracle's public cloud or inside the customer's data center with Oracle managing all infrastructure
  • Simple and straightforward migration to the cloud - software and hardware are identical and 100 percent compatible
  • All Exadata performance optimizations available
  • Full compatibility with on-premises Oracle Databases
  • Full root OS and SYSDBA access to manage your databases
  • Supports OLTP / analytic / mixed workload databases
  • Enables consolidation, Test/Dev, proof-of-concept, certification, etc.
  • Secured network access; customer databases run in separate VM
  • Backup to Exadata or Oracle Database Backup Service
  • Server, storage, networking infrastructure managed by Oracle
  • Easy and rapid database provisioning in a few clicks
  • Cloud automation software reduces administration
  • Subscribe to only the compute cores needed by the application

 Benefits:
  • Metered Service: Providing the flexibility to meet your business needs
  • Proven: Exadata already running in thousands of mission-critical sites worldwide
  • Highly Available: Run your database across 2 to 8 nodes
  • Capacity on Demand: Between 16 and 272 cores
  • Cost effective: pay only for the CPU cores you enable.
  • Rapid Provisioning: dedicated, pre-built, fully functional Exadata environment
  • Ready to use: to deploy your Oracle databases in Cloud
  • All inclusive: Memory, storage, and network resources are all included
  • Optimized for performance: All the Exadata Database Machine features
  • Complete: Oracle Database Enterprise Edition—Extreme Performance options

1Z0-338 Exadata Certification Exam Guide

Finally the wait is over...!!!

In recent days, we have received lots of inquiry for 1Z0-338 certification preparation guide. Today we have launched the guide in QUESTION BANK section. (Buy Now)

1Z0-338Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials


You will surprise to know the story behind how we have prepared this guide to make sure that whatever we are providing is the best.

Before releasing this question bank we have carried one exercise where we have given this guide to 10 readers of our website which were selected randomly based on the willingness to appear into the exam. 

We have provided this guide without any cost to prepare for the certification exam. However individual member has to bare the exam cost.

Believe us all of them cleared the exam with more than 95% score. We have carried this exercise to make sure whatever material we are providing here is 100% accurate.

Hope this guide will help you to beat the market competition and will add unique and beautiful feather in your career.

Don't hesitate to contact us any time even if you don't buy our product we will try our best to help you.

Best of luck for the certification and happy Exadating...!!!

1Z0-338 Oracle Exadata Certification Exam Dumps Download

Managing OS Statistics On Oracle Database Server

Operating system performance issues commonly involve process management, memory management, scheduling and storage management. 


Many times we get into the performance issue if we don't follow the common Oracle best practice like system parameters, improper swap allocation, hard/soft limit, not configuring hugepages wherever it requires.

If you have tuned the Oracle database instance and still need to improve performance, tune the OS, network and storage part.


Well, here we have given some of the basic statistics management which can help to boost the performance in your environment.

CPU Statistics: 

  • Doesn't exceed 95% in total
  • Check DB share on CPU 

Virtual Memory Statistics: 

  • Validate that memory usage does not increase after the system has reached a steady state after startup

Disk I/O Statistics: 

  • Current response time should be between 5 to 20 ms for a single block IO the length of the disk queues shouldn't exceed two

Network Statistics: 

  • Look at the network round-trip ping time and the number of collisions
  • Investigate it, if the network is causing large delays in response time

Reducing Disk Contention: 

  • Increase the number of disks in the storage system 
  • Separate the database and the redo log files 
  • For a large table, use partitions to reduce I/O 
  • Stripe the data either manually or by using a RAID disk-striping system 
  • Invest in cutting-edge technology, such as file caching, to avoid I/O bottlenecks 
  • Consider using ASM 

Top 10 Facts About Oracle Exadata Cloud Machine

This post is about the top facts about Oracle Exadata Cloud Machine from technical and business perspective.

                   YOU MUST SPEND MONEY TO MAKE MONEY



1. On-premise licenses cannot be transferred to ExaCM.

2. The minimum commitment to both the ExaCM and OCM is 4 years and the minimum configuration is Eighth Rack.

3. The subscription price for Oracle Database Exadata Cloud Machine X6 Eighth Rack is $40,000 per month (= $2,500 X 16) and that includes all DB options/features, Exadata Software and OEM DB Packs.

4. Standalone products such as Oracle Secure Backup and Oracle GoldenGate are not included in the ExaCM subscription. 

Only the database options (such as RAC, In-Memory, Partitioning, Active Data Guard, etc.), the database OEM packs and the Exadata storage server software are included.

5. ExaCM requires Oracle Cloud Machine to deploy Exadata Cloud Control Plane (separate subscription). OCM subscription requires similar minimum term commitment as ExaCM. 

If a customer already has an OCM, that can be leveraged to deploy Exadata Control Plane at no extra cost. One OCM Model 288 can manage 6 ExaCM Full Racks (i.e. 24 ExaCM Quarter Racks or 12 ExaCM Half Racks). 

Theoretically one OCM can support a much larger number of ExaCM full racks: about 50.

6. The 1/8th rack SKU is very similar to the on-premises 1/8th rack – i.e. minimum configuration of 16 OCPUs (cores), 240 GB RAM per database server, 144 TB raw storage (42 TB usable), 19.2TB of Flash. 

Compared to the Quarter Rack, it ships with less RAM, disk storage and flash. Those will be field installed if the customer chooses to go for the 1/8th to Quarter Rack upgrade. 

Note that this 1/8th rack enables customers to have an entry level configuration that is similar to what exists in Exadata Cloud Service.

7. Hourly Online Compute Bursting is supported with ExaCM. The commercial terms are the same as in Exadata Cloud Service – i.e. 25% premium over the Metered rate, calculated on an hourly basis. 

Customers can scale up or down, dynamically. Bursting does not kick in automatically based on load. Bursting of OCPUs needs to be configured by customers as needed. 

Once customer initiates bursting, the OCPU update is done dynamically without downtime. Customers will be billed later on the hours of bursting usage. Price: $8.401 per OCPU per hour.

8. If Cloud Control Plane is down, it doesn’t affect the availability of steady state runtime operations. However, cloud-based management (e.g. selfservice UI and REST API access) will be impacted.

9. Access: the Exadata Cloud Machine compute nodes are each configured with a Virtual Machine (VM). You have root privilege for the Exadata compute node VMs, so you can load and run additional software on the Exadata compute nodes. 

However, you do not have administrative access to the Exadata infrastructure components, including the physical compute node hardware, network switches, power distribution units (PDUs), integrated lights-out management (ILOM) interfaces, or the Exadata Storage Servers, which are all administered by Oracle.

10. Patching and backups: you can produce a list of available patches using the exadbcpatchmulti command as follows

# /var/opt/oracle/exapatch/exadbcpatchmulti -list_patches 
-sshkey=/home/opc/.ssh/id_rsa 
-oh=hostname1:/u01/app/oracle/product/12.2.0.1/dbhome_1

When you create a database deployment on Exadata Cloud Machine, you must choose from the following automatic backup configuration options:

– Remote Storage Only: uses remote NFS storage to store periodic full (RMAN level 0) backups and daily incremental backups, with a seven day cycle between full backups and an overall retention period of thirty days.

– None: no automatic backups are configured. Automatic backups cannot be configured later if you select the None option when you create a database deployment.

Oracle Exadata Cloud Administrator and Implementation Certification Exam Available

1Z0-485   Oracle Exadata Database Machine 2014 Implementation Essentials
1Z0-027   Oracle Exadata X3 and X4 Administration

1Z0-338 Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials
1Z0-070   Oracle Exadata X5 Administration



Top Two Parameters in Oracle Exadata

You must have question in your mind that why only two parameters as there are n number of parameters related Exadata and all have it's own importance.

Well, we have choose these two because exadata performance more over dependent on these parameters and major two functionality works on these parameters.

These two parameters are:

_KCFIS_STORAGEIDX_DISABLED
CELL_OFFLOAD_PROCESSING


_KCFIS_STORAGEIDX_DISABLED

- There is not much you can do to control storage index behavior. However, the developers have built in a few hidden parameters that provide some flexibility.

- Above parameter is one of them to control the storage index functionality on exadata.

- This is undocumented and hidden parameter which is used to control the storage index function. It is highly recommended to check with the Oracle support before using it. 

- This parameter tells oracle storage if storage index need to be used while performing query execution. 

- It is used to enable and disable the usage of storage index when exadata is used for the database. 

- By default it is FLASE means storage index is enabled. If you need to disable the usage of storage index than make the value of this parameter TRUE.

Disable storage index:

SQL>alter system set _KCFIS_STORAGEIDX_DISABLED=TRUE;

Enable storage index:

SQL>alter system set _KCFIS_STORAGEIDX_DISABLED=FALSE;

You can also test this on session level.


CELL_OFFLOAD_PROCESSING

- Second parameter is related to the smart scan function of exadata. There are several parameters that apply to offloading. 

- The main one is CELL_OFFLOAD_PROCESSING, which turns offloading on and off.

- By default the value of this parameter is TRUE which means smart scan is enabled. In case if you want to test measure the performance of database using or without smart scan , you can use this parameter. 

- If it is disabled, it means that predicate filtering and storage indexes cannot be used to cut down the volume of data.

Disable smartscan:

SQL>alter system set CELL_OFFLOAD_PROCESSING=FALSE;

Enable smartscan:

SQL>alter system set CELL_OFFLOAD_PROCESSING=TRUE;

This parameter also can be tested on session level.

Why Exadata for Oracle Databases?

Many time it comes in our mind that why we should go for Exadata, what benefits we can get if we go for Exadata so here we have given some views based on the Exadata architecture, experience and features. This is the most common question in interview.



No doubt there can be many more advantages than what we have given below as we have only given high level views.

  • Exadata is high performance and high available pre-configured device.
  • It consists of servers,storage networking and software in single pre-configured box which is massively scalable, secure and redundant.
  • Multiple compression tiers are available on Exadata which can help customer to compress data as per business requirement to save storage space.
  • Implementation time is very less compare to non-Exadata systems as it's comes as pre-configured and pre-tested.
  • In case on any issue with the Exadata than we need to communicate with only single vendor which doesn't required to contact multiple vendor like non-Exadata setup so solution of issue could be done quicker.
  • Only DMA (Database Machine Administrator) would be required to manage the Exadata so it can manage with lower TCO which reduce the huge cost of manageability.
  • Exadata provides extreme performance for both DW and OLTP databases which is making it and ideal platform for database consolidation.

Top 14 Commands for Exadata Health Check

There are multiple ways, utilities or commands to monitor Exadata machine. Here we have mentioned the list of dcli commands which can help to get the list of cell alerts, resource consumption details and configuration details in shortest time.


Exadata alert

dcli -l root -g ~/cell_group "cellcli -e list metriccurrent where alertState!=\'Normal\'"

Exadata cell CPU utilization

dcli -l root -g ~/cell_group "cellcli -e list metriccurrent CL_CPUT"

Exadata cells flashdisk with status NOT present

dcli -l root -g ~/cell_group "cellcli -e list physicaldisk attributes name, id, slotnumber where disktype=\"flashdisk\" and status=\'not present\'"

Exadata cell current temperature

dcli -l root -g ~/cell_group 'cellcli -e list cell detail' | egrep temperature 

Exadata alert history

dcli -l root -g ~/cell_group "cellcli -e list metrichistory where alertState!=\'Normal\'" 

Exadata cells battery replacement checks

dcli -l root -g ~/cell_group '/opt/MegaRAID/MegaCli/MegaCli64 -adpbbucmd -aALL' |grep replaced

Exadata cells harddisk with status NOT present

dcli -l root -g ~/cell_group "cellcli -e list physicaldisk attributes name, id, slotnumber where disktype=\"harddisk\" and status=\'not present\'" 

Exadata cells services checks

dcli -l root -g ~/cell_group 'cellcli -e list cell detail' | egrep '(cellsrvStatus)|(msStatus)|(rsStatus)'

Exadata cells memory checks

dcli -l root -g ~/cell_group --vmstat="-a 3 2"

Exadata physical memory checks

dcli -g ~/all_group -l root "cat /proc/meminfo | egrep '^MemTotal:|^MemFree:|^Cached:

Exadata physical disk checks

dcli -g ~/all_group -l root /opt/MegaRAID/MegaCli/MegaCli64 AdpAllInfo -aALL | grep "Device Present" -A 8

Exadata cell fan status

dcli -l root -g ~/cell_group 'cellcli -e list cell detail' | egrep fan 

Exadata storage cell model detail

dcli -l root -g ~/cell_group 'cellcli -e list cell detail' | egrep makeModel -- For cell

dcli -l root -g ~/dbs_group 'dmidecode -s system-product-name'  -- For DB node

Exadata cells power status

dcli -l root -g ~/cell_group 'cellcli -e list cell detail' | egrep power


You can follow our Oracle Exadata Exam Certification Materials  to achieve the maximum success in your Oracle Exadata Certification Exam.