System News
BNP Paribas Has Glowing Response to Oracle Exadata V2 Implementation
Company Cites Performance Gains, Reductions in Admin and Management Tasks
August 6, 2010,
Volume 150, Issue 1

I can get tables that were already compressed down to 1 terabyte in Oracle 10g down to 185 gigabytes using the hybrid columnar compression in Exadata V2

-- Jim Duffy, BNP Paribas
 

Viral marketing is often the best endorsement a vendor can hope for. It is certainly what Oracle has found in the response of BNP Paribas to their adoption of Oracle Exadata V2, as reported in InformationWeek by Doug Henschen.

The enthusiasm at BNP Paribas stems from having been able to replace a four-node RAC cluster running Oracle 10g with a half-rack deployment of Exadata V2. The new system, like the retired legacy system, provides the underpinning of some 35 trading-floor applications, including near-real-time performance stat monitoring, risk- and market-abuse compliance reporting, network and internal application optimization, and long-term (five-year) archival compliance querying and reporting, Henschen writes, adding that a second Exadata V2 half rack is dedicated to disaster recovery.

The five TB worth of Smart Flash Cache in BNP Paribas' Exadata V2 implementation supports the high end of the company's high/medium/low-speed data-access scheme, enabling the storage of the preceding week's trading data in flash cache. Further, Henschen continues, there is also room in the cache for anything directly accessed by an internal-facing Website used for monitoring and querying (particularly derived data).

BNP Paribas data warehouse architect Jim Duffy told the writer that cache is used as well for staging tables that are accessed directly to deliver internal application performance statistics. According to Duffy the monitoring/querying Web site is serving up answers five times faster than it did with the RAC/10g deployment.

The hybrid columnar compression feature of Exadata V2 enables BNP Paribas to store only 10 TB rather than 23, as was the case in the previous setup, Henschen writes. "I can get tables that were already compressed down to 1 terabyte in Oracle 10g down to 185 gigabytes using the hybrid columnar compression in Exadata. That brings massive benefits in terms of manageability," Duffy said.

Duffy is equally satisfied with the reduction in admin and management tasks that Exadata V2 delivers. What used to take hours can now be accomplished in minutes, he told Henschen. Duffy added the observation that existing queries run, on average, about 16 to 17 times faster on Exadata V2 than in the old RAC deployment. He expects to achieve even further performance improvements through code changes to exploit Exadata V2's ability to push SQL querying down into the storage tier, Henschen writes.

More Information

What's New in Oracle Exadata V2?

Oracle Exadata: A Data Management Tipping Point

Flash Storage in Exadata V2 Cuts Query Processing Time Significantly

Unconventional Resources on Oracle Exadata Version 2 "

Read More ... [...read more...]

Keywords:

 

Other articles in the Features section of Volume 150, Issue 1:
  • BNP Paribas Has Glowing Response to Oracle Exadata V2 Implementation (this article)

See all archived articles in the Features section.

Popular Articles in
Vol 200, Issue 3
Popular IT Articles





Popular Articles in
Vol 200, Issue 3
Popular IT Articles


News and Solutions for Users of Solaris, Java and Oracle's Sun hardware products
30,000+ Members – 30,000+ Articles Published since 1998