ORACLE EXADATA

This blog all about basics and brief  of  Exadata  Features ,RACK overview, Storage Server 

Architecture& Process ,Oracle ASM & RAC, Layers of Storage Disks,  Flash Cache, Smart 

Scan/Off loading, Storage Indexes ,HCC,ILOM

   Note:-Please click all screenshot attached to view the text clearly.


 The Oracle Exadata Database Machine X4-2 is the fifth generation database machine. It features the most advanced architecture, using industry-standard database servers, built-in management, intelligent storage servers, and a high speed InfiniBand network that interconnects servers and storage for faster data access and delivery.

There are a number of new innovations and enhancements in the latest release,delivering higher consolidation density, lower total cost of ownership and improved performance.

Greater performance and capacity:-

Exadata X4-2’s Compute Power:    Exadata X4 Storage:

· 50% more database cores              · 2X larger physical flash memory


· 2X larger database 
server local storage ·                      . Up to 4X larger logical flash memory


· 2X faster InfiniBand network          2X larger disks


Key database optimizations include:

• More database query offload to storage can offload searches of LOBs
• Database optimized compression now includes Hybrid Columnar enhancements for transaction processing
• Database optimized PCI Flash enables ultra high speed flash compression (X4) at multi-million IOs/second, as well as caching for table scans and faster file initialization
• Database optimized QoS prioritizes CPU and IO use by multitenant pluggable database (12c)
• Database optimized availability allows for prioritized recovery of critical database files
• Database optimized messaging prioritization of critical database messages, including log writes and Oracle Real Application Clusters

Why Exadata ?

Exadata Database Machine is designed to address common issues:

   >>Data Warehousing issues:

 Supports large, complex queries

 Managing Multi-Terabyte databases

>> OLTP issues:

 Supporting large user populations and transaction volumes

 Delivering quick and consistent response times

>> Consolidation issues:

 Efficiently supporting mixed workloads(OLTP & OLAP)

 Prioritizing workloads(IORM)

>> Configuration Issues:

 Creating a balanced configuration without bottlenecks

 Building and maintaining a robust system that works

>>Redundant and Fault Tolerant:

 Failure of any component is tolerated.

 Data is mirrored across storage servers

Basic Components of Exadata are Compute node(DB node, Cell nodes, Ibswitches,PDU's,Cisco 
switches).

For 1/8th and 1/4 th  Configuration is same across  the Rack

Database node, storage nodes,switches --Update pending


>>List  of Command line interface  utility  for compute node and Cell node show below in diag

Diag 1:Command categories

• CellCLI - the Exadata Storage Server. To manage this, Oracle provides a command line tool: CellCLI (Cell Command Line Interpreter). All the cell-related commands are entered through the CellCLI.

• DCLI - The scope of the CellCLI command is the cell where it is run, not in other cells. Sometimes you may want to execute a command across multiple cells from one command prompt, e.g. shutting down multiple nodes. There is another command line tool for that: DCLI.

• SQL – Once the cell disks are made available to the database nodes, the rest of the work is similar to what happens in a typical Oracle RAC database, in the language you use every day: SQL. SQL*Plus is an interface many DBAs use. You can also use other interfaces such as Oracle SQL Developer. If you have Grid Control, there are lots of commands you don’t even need to remember; they will be GUI based.

• ASMCMD – ASMCMD this is the command line interface for managing ASM resources like diskgroups, backups, etc.

• SRVCTL – SRVTCL is a command-line interface to manage Oracle Database 11.2 RAC Clusters. At the database level, most of the commands related to cluster, e.g. starting/stopping cluster resources, checking for status, etc. can be done through this interface.

• CRSCTL – CRSCTL Cis another tool to manage clusters. As of 11.2, the need to use this tool has dwindled to near zero. But there is at least one command in this category.

• These are the basic categories of the commands. Of these only CellCLI and DCLI are Exadata specific. The rest, especially SQL, should be very familiar to DBAs.