Steps to Generate Exadata One Command Configuration sheet

First download  Oracle Exadata Deployment Assistance from below link as per your respective Operating System.

Oracle Exadata Deployment Assistance (OEDA)

Install it on your machine and click on config to open deployment assistance.

Below are the detailed steps to fill the configuration details.

Click to enlarge.....

Provide organization name, application details, timezone with NTP and DNS Server details.

Select appropriate Exadata Configuration Rack, in our case it's Half Rack High Performance.

Provide network details for Administration and Client connectivity. You should have separate network for admin and client as per best practice.

Download Free Oracle Exadata Certification Exam Dumps

Exadata Exam Study Guide - 1Z0-536

The Oracle Exadata 11g Essentials Exam Study Guide is designed to provide students with the information that can help them learn more to pass the Oracle Exadata 11g Essentials Exam (1Z0-536).

Below linked Oracle document will give you End to End guideline with course content to clear the Examination(1Z0-536).

• Exadata11g-Exam-Study-Guide (1Z0-536)

Sample Question for 1Z0-536                                               Question Bank to clear 1Z0-536 certification 

You can follow our Exadata Certification Question Bank to achieve maximum success in your Exadata certification exam.

Exadata DMA Roles and Responsibility

Exadata administration can be done by single Exadata DMA (Database Machine Administration). There is no requirement of team for each domain.Only one specialist (DMA) is required to manage the Exadata.

Based on our experience we have given following list of tasks which need to be performed by DMA. We can add many tasks in this list but we have just covered most common tasks specially from Exadata perspective.

Roles and Responsibility of DMA

Hardware installation and maintenance: A database machine required periodic maintenance like firmware upgrade or replace any failure component of machine.

Network Administration: Exadata comes with CISCO ethernet switch for Management and ILOM network, infiniband swithces for cell and DB Node node connectivity so management of network is also includes in DMA's task. General knowledge of netwrok topology required to manage Infiniband switches.

Operating System Administration: Linux or Solaris OS administration. Also manage server availability during patching with high availability management. Setting up users,  applying patches, managing disk space, NFS mount, 

Exadata Storage Administration: Important component of Exadata. In depth knowledge is required to manage the cell servers as this is the main component of Exadata which also configured with Exadata Storage Software. It include monitoring of celldisk, griddisk, cell flash cache, flash disks, OS administration, infiniband connectivity  administration. Maintain storage availability during patching.

Grid Infrastructure Administration: Inlcudes clusterware, ASM disk group, mirrored cell group as Exadata managed mirroring on ASM level not cell level.

Database Administration: Includes single instance, single instance on ASM, one or more RAC node database. Exadata specific parameters.

Here DMA does not need to know full scale Linux , storage or network. Only few relevant concepts are required to manage the Exadata. 

Overall required skill for component wise in percentage as follows.

• 60% Database Administration
• 20% Cell Storage Administration
• 15% Linux Administration 
• 5% Miscellaneous (Infiniband, network, etc.)

You can follow our Exadata Certification Question Bank to achieve maximum success in your Exadata certification exam.

Exadata Certification Sample Questions & Answers (1Z0-536)

I have given some sample questions for Exadata Certification. I hope it will help you to prepare for certification. 


When do you specify the type of interleaving for a grid disk?

A. When you create the cell disk
B. When you create the grid disk
C. Through ASM
D. When you create a tablespace
Answer: B

Why would you reduce the default disk_repair_time parameter?

A. To extend the availability of your ASM disk groups.
B. To reduce the need for high redundancy
C. To reduce the amount of data collected for a fast resynch
D. To increase performance of anExadata Storage Server.
Answer: C


What benefit is provided by column filtering?

A. The Exadata Storage Server can select rows based on column values listed in a SQL predicate
B. Storage indexes are built on columns for use in filtering
C. Only necessary columns are returned to the database server
D. Column filtering is a marketing term, not a real benefit
Answer: C

Which types of data are most likely to be cached In the Exadata SmartFlash Cache?

A. Results of random reads.
B. Results of table scans.
C. Write to a mirror
D. Redo data
E. All data is cached In the Flash Cache
Answer: A

What does the role attribute of a DB plan Indicate?

A. The role specified for the category
B. The role specified for the user
C. The role specified In a Data Guard environment
D. The role specified for the application
Answer: A

Your customer has designated a number of database objects to be kept persistently in the Exadata Smart Flash Cache. What happens if the total size of these objects is greater than 80% of the size of the available Exadata Smart Flash Cache?

A. Nothing
B. Exadata Smart Flash Cache expands the allocation to hold the objects.
C. Not all objects will be stored in Exadata Smart Flash Cache.
D. Overall performance is increased as more objects fit into Exadata Smart Flash Cache.
Answer: C

Which three attributes are likely to result in data being cached in the Exadata Smart Flash Cache?

A. CELL_FLASH_CACHE attribute on the data object
B. CACHE hint In the SQL statement
C. Data from a table scan
D. Small data less than 128 KBs
E. Control file I/Os
Answer: A,C,E

How many IP addresses you need to assign for each Exadata storage cell?