By Brian Whitney on Jun 10, 2010
Oracle's Sun SPARC Enterprise M5000 server is an excellent platform for implementing Oracle Essbase as demonstrated by the Aggregate Storage Option (ASO) benchmark.
Oracle's Sun SPARC Enterprise M5000 server with Oracle Solaris 10 and using Oracle's Sun Storage F5100 Flash Array system has achieved world record performance running the Oracle Essbase Aggregate Storage Option benchmark using Oracle Hyperion Essbase 220.127.116.11 and the Oracle 11g database.
The workload used over 1 billion records in a 15 dimensional database with millions of members. Oracle Hyperion is a component of Oracle Fusion Middleware.
Sun Storage F5100 Flash Array system provides more than 20% improvement out of the box compared to a mid-size fiber channel disk array for default aggregation and user based aggregation.
The Sun SPARC Enterprise M5000 server with Sun Storage F5100 Flash Array system and Oracle Hyperion Essbase 18.104.22.168 running on Oracle Solaris 10 provides less than 1 second query response times for 20K users in a 15 dimensional database.
Sun Storage F5100 Flash Array system and Oracle Hyperion Essbase provides the best combination for large Essbase database leveraging ZFS and taking advantage of high bandwidth for faster load and aggregation.
Oracle Fusion Middleware provides a family of complete, integrated, hot pluggable and best-of-breed products known for enabling enterprise customers to create and run agile and intelligent business applications. Oracle Hyperion's performance demonstrates why so many customers rely on Oracle Fusion Middleware as their foundation for innovation.
|System||Data Base Size||Data Load||Def Agg||User Aggregation|
|Sun M5000, 2.53 GHz SPARC64 VII||1000M||269 min||526 min||115 min|
|Sun M5000, 2.4 GHz SPARC64 VII||400M||120 min||448 min||18 min|
less time means faster result.
Results and Configuration Summary
Sun SPARC Enterprise M5000
4 x SPARC64 VII, 2.53 GHz
64 GB memory
Sun Storage F5100 Flash Array
40 x 24 GB Flash modules
Oracle Solaris 10
Oracle Solaris ZFS
Installer V 22.214.171.124
Oracle Hyperion Essbase Client v 126.96.36.199
Oracle Hyperion Essbase v 188.8.131.52
Oracle Hyperion Essbase Administration services 64-bit
Oracle Weblogic 9.2MP3 -- 64 bit
Oracle Fusion Middleware
Oracle RDBMS 184.108.40.206 64-bit
The benchmark highlights how Oracle Essbase can support pervasive deployments in large enterprises. It simulates an organization that needs to support a large Essbase Aggregate Storage database with over one billion data items, large dimension with 14 million members and 20 thousand active concurrent users, each operating in mixed mode: ad-hoc reporting and report viewing. The application for this benchmark was designed to model a scaled out version of a financial business intelligence application.
The benchmarks simulates typical administrative and user operations in an OLAP application environment. Administrative operations include: dimension build, data load, and data aggregation. User testing modeled a total user base of 200,000 with 10 percent actively retrieving data from Essbase.
Key Points and Best Practices
- Sun Storage F5100 Flash Array system has been used to accelerate the application performance.
- Jumbo frames were enabled to faster data loading.
Oracle Essbase, www.oracle.com/solutions/mid/oracle-hyperion-enterprise.html, results 5/20/2010.