What characteristics of Oracle Exadata make it possible to provide such superior performance?

You are designing a mission-critical application that requires high performance. Your analysis
concludes that Oracle Exadata would enable you to meet the performance goals. What
characteristics of Oracle Exadata make it possible to provide such superior performance?

You are designing a mission-critical application that requires high performance. Your analysis
concludes that Oracle Exadata would enable you to meet the performance goals. What
characteristics of Oracle Exadata make it possible to provide such superior performance?

A.
Oracle Exadata uses massively parallel architecture to speed up Oracle data warehouses by
offloading data-intensive query processing from the databases.

B.
By pushing SQL processing to the Oracle Exadata Storage Server, all the disks can operate in
parallel, reducing database server CPU consumption while consuming much less bandwidth to
move data between storage and database servers.

C.
The Oracle Exadata Storage Server returns a query result set rather than entire tables,
eliminates network bottlenecks, and frees up database server resources.

D.
Oracle Exadata uses direct data placement to ensure very low CPU overhead by directly
moving data from the wire to database buffers with no extra data copies being made.

Explanation:
To overcome the limitations of conventional storage, Oracle Exadata Storage
Servers use a massively parallel architecture to dramatically increase data bandwidth between the
database server and storage. Innovative technologies such as Exadata Smart Scan, Exadata
Smart Flash Cache, and Hybrid Columnar Compression enable Exadata to deliver extreme
performance for everything from data warehousing to online transaction processing to mixed
workloads.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


someone

someone

I think it is A,B and C

ORA Application Infrastructure: p.8-11 “It uses a massively parallel architecture to speed up Oracle data warehouses by off loading data-intensive query processing from Oracle Database Servers and doing the processing closer to the data.”, “By pushing SQL processing to the Oracle Exadata Storage Server all the disks can operate in parallel, reducing database server CPU consumption while consuming much less bandwidth to move data between storage and database servers. The Oracle Exadata Storage Server returns a query result set rather than entire tables, eliminates network bottlenecks, and frees up database server resources.”