Oracle Exadata Database Machine racle Exadata Database device (Exadata) is a combined compute and storage system optimized for running Oracle Database computer software. Exadata debuted in 2008 as the first in Oracle’s family of “Engineered Systems”, defined as “hardware and software engineered to come together”. New generations of Exadata are released roughly when a year.
Exadata combines compute that is scale-out, scale-out storage space servers, InfiniBand networking and specific software, packaged in one or more hardware racks, with various sizing choices. Exadata compute servers utilize Intel Xeon processors and the Oracle Linux operating system to run Oracle Database pc software. Exadata storage servers perform block storage functions and also run Exadata Storage Server Software to offload data intensive database processing into storage, closest to the information.
It is Oracle’s claim that optimizing the compute/storage/networking that is entire in Exadata for the Oracle Database allows it to end up being the best possible database host platform and that pre-integrating all the pc software and hardware simplifies configuration, management, and troubleshooting for customers. Experts of Exadata point out that this limits it to operating Oracle Databases, and it cannot be used as a general-purpose host. Industry analysts at IDC classify Exadata as an “Integrated Platform” with Oracle Engineered Systems having over 50% market share as of March, 2015. Analysts at Gartner place Oracle Engineered Systems into the leaders quadrant of their “Integrated Systems Magic Quadrant” report for 2014, providing Oracle the top vendor ranking for “Integrated Stack techniques”.
As of 2015, Exadata is also available in the Oracle Public Cloud as a subscription service – the Oracle Database Exadata Cloud Service, also known simply as the Exadata Service october. Databases deployed in this Service include all of the features and options of Oracle Database Enterprise Edition. Similarly, all Exadata features and capabilities are included in this Service. Oracle databases in the Exadata Service are 100% compatible with databases deployed on-premises, which allows customers to transition to the Cloud without any application changes. The infrastructure for this ongoin service – including the equipment, system, platform software and Exadata computer software, is handled by Oracle, while customers have complete ownership of their databases. Clients can do all necessary provisioning through the Oracle Cloud portal, with cloud-based automation tools designed for backups, patching, expansion, etc.
Exadata is designed to optimally run any Oracle Database workload or mix of workloads. Long term requests, characterized by data warehouse questions, reports, batch jobs and analytics, are reputed to run several times faster compared to a main-stream, non-Exadata database server. Client references often cite performance gains of 10x or greater. Analytics workloads can use the Oracle also Database In-Memory option on Exadata for additional acceleration. Exadata’s ” Hybrid compression that is columnar function is intended to lessen the storage usage of information warehouses and archive information because well as increase performance by reducing the level of I/O.
Transactional (OLTP) workloads on Exadata benefit from the incorporation of flash memory into Exadata’s storage hierarchy, and the”tiering that is automatic of information into memory, flash or disk storage space. Special flash algorithms optimize flash for reaction time database that is sensitive such as log writes. For high-end OLTP, all-flash storage (see Extreme Flash Storage Server below) eliminates the latency of disk media completely.
All Exadata workloads benefit from an extremely bandwidth that is high low latency interior InfiniBand material running a specific database network protocol called iDB.
Database consolidation on Exadata is common. To minimize resource contention between competing databases and workloads, “resource management” top features of Exadata enable prioritized allocation of CPU, I/O and network bandwidth.
Oracle Exadata Database device is available in two variants: one predicated on two-socket database servers and one other based on eight-socket database servers. The two models vary only in the equipment employed for the compute servers. The networking, storage servers and software are the same in both models.
The most Oracle that is recent Exadata device is the X6 generation introduced in April, 2016.
The X6-2 compute servers feature a form that is small, 1 RU (Rack Unit) in height. They employ 2-socket Intel Xeon processors; each socket with 22 compute cores for 44 cores that are total compute server. Memory starts at 256 GB and may be expanded to 768 GB.
The Exadata X6-2 Database Machine base configuration has 2 compute servers and 3 storage servers, known as a “Quarter Rack”. The same hardware is also obtainable in an “Eighth Rack” configuration with half associated with processing turned off and half of the storage capacity either turned off or eliminated until needed. As the database workload and/or data size increases, additional compute and storage servers may be added to improve the volume of work done in parallel. This is commonly named “scale-out”.
The X6-8 compute server utilizes eight-socket servers that consume 5 RU in height and have greater memory capacity compared to the X6-2. Whereas each X6-2 compute server contains 44 compute cores, the X6-8 host contains 144 compute cores. This allows large database workloads to easily “scale-up” within a compute server while still supporting Exadata’s “scale-out” expandability across multiple servers. The larger memory capacity of the X6-8 additionally favors in-memory database and very big OLTP, consolidation, and DW workloads. The Exadata X6-8 base configuration has 2 compute servers and 3 storage servers, but consumes a “Half Rack” of space like the x6-2. Additional storage and compute servers may be added until the rack is full.
Oracle Exadata training hyderabad