Oracle Exadata Architecture:
The Oracle Exadata Database Machine is the only database machine that provides extreme performance for both data warehousing and online transaction processing (OLTP) applications, making it the ideal platform for consolidating onto grids or private clouds.
Oracle believes that Exadata delivers the first and only complete grid architecture for all data management needs. Oracle has always promoted Grid as the architecture of the future and Grid has consistently provided the highest performance, lowest cost, redundancy, and the ability to scale incrementally over time as need dictates
The flexibility of RAC is the impetus behind Exadata. The premise being that Oracle wanted to combine the best benefits of RAC in one completely integrated and scalable platform. Oracle believes that by combining the software and hardware components in a pre-configured format, Exadata could eliminate the configuration issues that plague many organizations and eliminate the need for multiple database server and storage server solutions while eliminating the I/O bottleneck and increasing storage and speed to unprecedented levels.
It is a complete package of servers, storage, networking, and software that is massively scalable, secure, and redundant. With Oracle Exadata Database Machine, you can reduce IT costs through consolidation, manage more data on multiple compression tiers, improve performance of all applications, and make better business decisions in real time.
Oracle Exadata Architecture
ASM mirrors and stripes disks between the appliances. ASM failure groups are used to protect the data from disk and appliance failures.
All storage servers have processors that can execute simplified SQL and will return the requested rows and columns.
Infiniband is used to connect the appliances to the database server. Spare ports are available for connecting additional blades to the storage cluster.
An Enterprise Manager plugin is available for managing and monitoring the solution
Oracle Exadata Technical architecture:
The libcell library is linked in to talk to cellsrv process.
cellinit.ora decides which network takes storage traffic.
cellip.ora – list of cells, new cells can be added dynamically without shutdown
diskmon handles cell failures
cellcli is the command line interface and configuration utility
RS (Restart Server) monitors and restarts other critical processes
dcli – tool to run commands on all cells
Set cell_offload_processing parameter to TRUE
cell_offload_plan_display parameter to predict the effect of moving to Exadata.