Free Certification for Rapidly Growing Cloud Provider

Oracle, One of the rapid growing Cloud Provider made all content free for everyone till 30th Sep which includes all OCI certifications. It is the right time to jump into Oracle Cloud to make your self more valuable.

Go to below link for more information:

https://education.oracle.com/oracle-oci-certification#oracle-cloud-infrastructure

5 Reasons to be Oracle Exadata Certified

The Oracle Exadata Database Administrator and Implementation Certified Professional confirms that applicants have the DMA (Database Machine Administrator) skill to implement and manage the Oracle Exadata Machine. It also indicates a certification holder can do everyday tasks whether it is Database or Exadata Machine which also helps to increase productivity of employee.

There are two exams for Oracle Exadata as below. Based on your role you can choose any of the exam or both.

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

2.  1Z0-070 - Oracle Exadata X5 Administration

So why to choose Oracle Exadata Certification?

Now days Oracle is coming with new version of Database with lots of new features which eliminate many of the DBA tasks so if you are traditional DBA then one day DBA role will be eliminated which may impact your career if you are not upgrading yourself with the technology so better to prepare yourself to be DMA which is hot demand in the database market. This certification will help you to transform from DBA to DMA where you can manage database as well the underlying infrastructure where database is running.

Reason 1: Opens the door for better job as it will add weight to your resume without a doubt

Reason 2:  No doubt it will boost your earning if you are certified and transforming from DBA to DMA.

Reason 3: Certified candidate having more chance to get sort listed for any of the interview process.

Reason 4:  Provides you a feeling of accomplishment which will help you to drive your career towards more success

Reason 5: Demand of Oracle Exadata Certified increasing rapidly which enables you to stand out of the group

Ultimate Guide to Clear Oracle Exadata Certification

Oracle Exadata Interview Questions and Answers

Oracle 18c and Its Impact on DBA

Cheatsheet : Interview Preparation

You can take the reference of below questions and how you can answer each of them during interview. This is just hint to think to that direction which can boost your confidence and you can be well prepared before the interview.

 

No doubt all the questions are not applicable to all of you which you can ignore. Our intend is only to help you in such crisis if it can help.

 ​​

First we would suggest to go though your CV and only write what you know, never keep anything as showcase, many time it cab be the reason why you get rejected.

 

Question: Describe your overall experience

Upskill Your Resume With Free Premium Online Courses

Covid-19 situation has affected the whole world. Working professionals are forced to work from home. The pandemic is going to affect the economy at large. There is a big threat that this situation can have on the jobs. For those that are staying at home, many e-learning platforms are offering free online courses. Upgrading your tech skills is the most assured way of staying relevant in the post-Covid job market. Here are the top companies and platforms that are offering free e-learning courses. 

1. Simplilearn 

Don't Miss :: Free Oracle Training and Certification

Last month Oracle made all content free for everyone for next 45 days which includes OCI certifications and Oracle Autonomous Database Certification.

Go to below link for more information:

https://www.oracle.com/corporate/blog/free-certifications-oracle-oci-autonomous-033020.html

​4 Actions to Perform Before Updating Exadata Software

Oracle Exadata Database machine built on multiple software which required updates periodically. Effective plan to update the software help to execute task effectively.

Exadata software updates apply to three major component on exadata machine. 

• Exadata Database Server Update
• Exadata Storage Server Update
• Exadata RDMA Network Fabric switches​​

Further Exadata Server and Storage server updates contains.

• Database Server Operating System
• Exadata System Software
• Oracle Database
• Oracle Grid Infrastructure
• Firmware for various hardware components

Below are the 4 actions you should perform before updating any software on Exadata machines, this can be consider as pre-requisite for update process.

Exadata Quick Reference 6: Important Oracle Exadata Configuration Files

Oracle Exadata and Storage cell having multiple configuration files which define the Exadata configuration. We have listed down the important configuration files for Compute and Storage node which can be used as quick reference for any kind of troubleshooting during Exadata support.

Exadata Compute Node:

/opt/oracle - contains dbserver software

World's Fastest Database Machine....

Recently Oracle announced World's fastest database machine Oracle Exadata Machine X8M.

Mainly two technologies has been adopted by this new machine.

• Persistent Memory, adding a new shared storage acceleration tier
• RDMA over Converged Ethernet (RoCE) network fabric, enabling 100 Gb/sec RDMA

OLTP, Analytics and Mixed workload can get significant benefits from Oracle Exadata X8M machine.

For more information on Oracle Exadata X8M, see datasheet of Exadata X8M.

Clear any interview by referring Cloud Edition of Oracle Exadata Interview Questions and Answers eBook.

You would also like our question bank for 1Z0-070 and 1Z0-338 exadata certification.

Exadata Quick Reference 5: Top Exadata Wait Events

Here listed down top and most critical Exadata wait events for the quick reference.

cell list of blocks physical read 

cell manager cancel work request

cell manager closing cell    

cell manager discovering disks   

cell manager opening cell    

cell multiblock physical read   

cell single block physical read  

cell smart file creation   

cell smart flash unkeep    

cell smart incremental backup   

cell smart index scan    

cell smart restore from backup   

cell smart table scan    

cell statistics gather     

cell worker idle     

cell worker online completion   

cell worker retry  

Newly Released: Oracle Exadata X8-2

This post is bit late but important if still you are not updated.

Recently Oracle announced Latest Oracle Exadata X8 which is specially design to expand more capacity in terms of storage by increasing the size of storage disk.

There no huge changes compare to Exadata X7. The major change is the size of disk from 10TB to 14TB which will ultimately help to reduce cost as Oracle Exadata storage includes license cost for storage disk also.

There are not change in number of CPU but clockspeed of CPU has been increased in newer version. There is no change in size of memory.

Third type of storage has been introduced, Storage Server XT. This is a storage node without flash cards and with less memory and only a single CPU. This type of node is intended for long term data storage for archiving purposes. It will cost considerably less than the regular storage nodes.

Check out this data sheet for the full specification overview: 

https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x8-2-ds.pdf

New Launch Cloud Edition : Oracle Exadata Interview Questions and Answers

A big THANK YOU to all of you for your overwhelming response for our first edition of eBook Oracle Exadata Interview Questions & Answers,We were delighted to sold off 5730+ copies till date. We have never thought to reach this mark when we have released this eBook. We have received lot of positive feedback on this book how it helps to crack the interview.

As a part of update now we are introducing ORACLE EXADATA CLOUD SERVICE interview questions and answers in our second edition of eBook. Total questions now more than 500+ with detailed answers.

It was very worthwhile book for us to launch as many people put their effort to make it possible. We are sure that happiness will be brought to all the readers as a result of our efforts. If you haven't yet read this book, we thank you for exploring our website.

"Stay miles ahead of the competition"

We appreciate the wealth of comments/appreciations we received telling us of your expert review of book and interview experience. Your feedback means the world to us. 

With profound gratitude, and with hope for your continued reading pleasure.

Exadata Certification Team

Exadata Quick Reference 4: Top 33 Oracle Exadata Parameters

Here listed down Top 33 Oracle Exadata Parameters, Exadata performance more over dependent on these parameters. It includes traditional database parameters also but those parameters also applied for Exadata environment and playing important role in terms of configuration and performance.

cell_offload_decryption

cell_offload_plan_display

cell_offload_processing 

_cell_index_scan_enabled

_small_table_threshold 

_serial_direct_read 

_serial_direct_read 

_kcfis_storageidx_disabled 

_kcfis_storageidx_diag_mode 

_cell_storidx_mode 

_cell_storidx_minmax_enabled 

Exadata Quick Reference 3: Oracle Exadata Patching Commands

Compute Node Patching: 

Patching on Database server can be performed serially or in parallel using DCLI utility.

dbnodeupdate.sh utility is used to perform the database server patching

What dbnodeupdate.sh utility does?

• Stop/unlock/disable CRS for host restart
• Perform LVM snapshot backup of / filesystem
• Mount yum ISO image and configure yum
• Apply OS updates via yum
• Relink all Oracle homes for RDS protocol
• Lock GI home and enable CRS upon host restart

Exadata Quick Reference 2: Oracle Exadata Diag Utilities

exawatcher

Location: /opt/oracle.ExaWatcher/GetExaWatcherResults.sh 

What it does?

Useful to monitor Diskinfo, IBCardInfo, IBprocs, Iostat, LGWR, Lsof, MegaRaidFW, Meminfo, Mpstat, Netstat, Ps, RDSinfo, Slabinfo, Top, Vmstat. It saves historical data in /opt/oracle.ExaWatcher/archive in each server.

Exadata Quick Reference 1: Oracle Exadata Utilities

We have started the sequence of posts for Oracle Exadata Quick Reference which will include Exadata Commands, Utilities, Patching commands, quick overview of exadata features, Exadata parameters, wait events etc...

Agenda for this sequence is to review the exadata quickly in shorter time which also can help for interview preparation. Also it can help for exadata administrator to get the data quickly.

Following are the Oracle Exadata Utilities which are available as of now.

dbmcli 

Command-line administration tool for configuring database servers, and managing objects in the server environment.  

cellcli

Command-line administration tool for Oracle Exadata Storage Server Software 

dcli

Runs commands on multiple compute nodes and cells in parallel threads 

exacli

Command-line administration tool for Oracle Exadata Storage Server Software. It runs on compute nodes and enables you to manage cells remotely. 

exadcli

The exadcli utility runs commands on multiple cells in parallel threads. You can issue an ExaCLI command to be run on multiple cells. 

OEDA

The Exadata Deployment Assistant tool used to gather the information needed to deploy the Exadata Database Machine. The information entered in the tool is used to create the configuration files used to deploy the machine. 

checkip.sh

Run the Network Check script on the network where the machine will be deployed to validate the specified names and IP addresses have been added correctly to the name server, and they do not conflict with the existing network configuration.   

exachk

Exachk utility used to conduct a comprehensive Exadata Health Check on Exadata Database Machine to validate hardware, firmware and configuration. 

Ultimate guide to be Oracle Exadata Cloud Implement Specialist

Cloud Edition: Oracle Exadata Interview Questions and Answers

What kind of subscription options exists for Oracle Database Exadata Cloud Service?

• Non-metered Subscription 
• Metered Subscription 

What mean by Non-metered Subscription?

A non-metered subscription is an agreement to purchase a specific number of service units over a specific term. Consequently, the charge for a non-metered subscription is not related to actual service usage. Non-metered subscriptions are also referred to as standard subscriptions.

What mean by Metered Subscription?

Metered Subscription — With a metered subscription, you are charged based on your service usage. 

Get NEW cloud Edition Oracle Exadata Interview Questions and Answers eBook

Two varieties exist:  

• Pre-Paid — With a pre-paid subscription you pay an up-front amount to establish an account that is consumed as you use a service. 
• Pay As You Go — With a pay as you go subscription you do not pay an upfront amount and are billed periodically for your actual service usage. 

What type of exadata configurations offered for oracle exadata cloud service in Oracle premises?

Be Oracle Exadata Certified - 1Z0-070

Finally the wait is over...!!!

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

1Z0-070 - Oracle Exadata X5 Administrator

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 25 readers this time earlier 1Z0-338 was give to 10 readers of our website which were selected randomly based on the willingness to appear into the exam. 

Superpower = THINK+ACT+PERFORM

Oracle DBA: Moving to the Cloud

It is important to note that just because you will be moving to the cloud, it is not to say that the DBA you have in-house will be abdicating his or her responsibilities. 

There are duties and tasks that will change once the shift to the cloud occurs, but your DBA will still have a very valuable role to play in your organization. 

One of those roles is to act as a liaison between your company and the remote DBA since he has more knowledge of the inner workings of your enterprise and can offer valuable information that will then be used in the provision of quality services to you. With a better understanding of your needs, you can expect a better service from your cloud vendor.

Here we have mentioned some of the important tasks or skills which required as Cloud DBA apart from traditional DBA skills.

• Design & Specifications of Database i.e. CPU, Memory, Disk Space, Future Growth, High Availability & Disaster Recovery (Yes even in Cloud, you have to consider HA & DR).

Introducing Oracle Exadata X7...!!!

Oracle announced the next-generation Oracle Exadata X7 with significant hardware and software enhancements in overall performance, storage capacity, network bandwidth, and automation.

Oracle Exadata is an Engineered System designed to be the ideal platform for all database workloads.  It features scale-out, database optimized compute, InfiniBand networking, and smart storage for fastest performance and low costs. Specialized algorithms vastly accelerate all types of database processing including OLTP, Analytics, and Consolidation. Exadata’s full-stack automation and optimization of all components slashes the need for skilled human labor, enabling reduced costs and improved reliability.  

Exadata’s simplicity, scalability, and reliability make it the foundation for the recently announced Oracle Autonomous Database Cloud.

Today, Exadata powers 4 out of 5 of the world’s biggest banks, telecoms, and retailers.  Exadata can be deployed on-premises, in Oracle Cloud, or using Oracle’s unique Cloud at Customer. 

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