Oracle's SPARC T4-4 server configured with 
four SPARC T4 3.0 GHz processors
 delivered the first and best performance of 25,000
 concurrent users on Oracle Business Intelligence Enterprise Edition
(BI EE)
 11g benchmark using 
Oracle Database 11g Release 2 running on 
Oracle Solaris 10. 
 
   
     
      
A SPARC T4-4 server running Oracle Business Intelligence Enterprise
Edition 11g achieved 25,000 concurrent 
users with an average response
time of 0.36 seconds with Oracle BI server cache set to ON.
 
     
     
      
The benchmark data clearly shows that the underlying hardware, SPARC T4
server, and the Oracle BI EE 11g (11.1.1.6.0 64-bit)
platform scales within a single
system supporting 25,000 concurrent users while executing 415
transactions/sec.
 
     
     
      
The benchmark demonstrated the scalability of Oracle Business
Intelligence Enterprise Edition 11g 11.1.1.6.0, 
which was deployed in a
vertical scale-out fashion on a single SPARC T4-4 server.
 
     
     
      
Oracle Internet Directory configured on SPARC T4 server provided
authentication for the 25,000 Oracle BI EE users 
with sub-second response time.
 
     
     
      
A SPARC T4-4 with internal Solid State Drive (SSD) using the ZFS file system
showed significant I/O performance improvement over traditional disk
for the Web Catalog activity. In addition, ZFS helped get past the UFS
limitation of 32767 sub-directories in a Web Catalog directory.
 
     
     
      
The multi-threaded 64-bit Oracle Business Intelligence Enterprise
Edition 11g and SPARC T4-4 server proved to be a successful
combination by providing sub-second response times for the end user
transactions, consuming  only half of  the available CPU resources at
25,000 concurrent users, leaving plenty of head room for increased
load.
 
     
     
      
The Oracle Business Intelligence on SPARC T4-4 server benchmark results
demonstrate that comprehensive BI functionality built on a unified
infrastructure with a unified business model yields
best-in-class scalability, reliability and performance.
 
     
     
      
Oracle BI EE 11g is a newer 
version of Business Intelligence Suite with
richer and superior functionality. 
Results produced with Oracle BI EE 11g benchmark are not
comparable to results with Oracle BI EE 10g benchmark. 
Oracle BI EE 11g is a more difficult benchmark
to run, exercising more features of Oracle BI.
 
     
   
  Performance Landscape 
  
Results for the Oracle BI EE 11g version of the benchmark.  
Results
are not comparable to the Oracle BI EE 10g 
version of the benchmark.
 
   
     
       
        
Oracle BI EE 11g Benchmark
 
       
       
        System 
        Number of  Users 
        Response Time (sec) 
       
       
        1 x SPARC T4-4 (4 x SPARC T4 3.0 GHz) 
        25,000 
        0.36 
       
     
   
  
Results for the Oracle BI EE 10g version 
of the benchmark.  Results
are not comparable to the Oracle BI EE 11g 
version of the benchmark.
 
   
     
       
        
Oracle BI EE 10g Benchmark
 
       
       
        System 
        Number of  Users 
       
       
        2 x SPARC T5440 (4 x SPARC T2+ 1.6 GHz) 
        50,000 
       
       
        1 x SPARC T5440 (4 x SPARC T2+ 1.6 GHz) 
        28,000 
       
     
   
  Configuration Summary 
  
Hardware Configuration: 
  
SPARC T4-4 server
    
    
    
    
    4 x SPARC T4-4 processors, 3.0 GHz
128 GB memory
4 x 300 GB internal SSD
 
   
  Storage Configuration: 
  ">
Sun ZFS Storage 7120
    
    
    
    
    
16 x 146 GB disks
 
   
  
Software Configuration: 
  
Oracle Solaris 10 8/11
Oracle Solaris Studio 12.1
Oracle Business Intelligence Enterprise Edition 11g (11.1.1.6.0)
Oracle WebLogic Server 10.3.5
Oracle Internet Directory 11.1.1.6.0
Oracle Database 11g Release 2
 
  Benchmark Description 
  
Oracle Business Intelligence Enterprise Edition (Oracle BI EE) delivers a robust set
of reporting, ad-hoc query and analysis, OLAP, dashboard, and scorecard
functionality with a rich end-user experience that includes
visualization, collaboration, and more.
 
  
The Oracle BI EE benchmark test used 
five different business user roles
- Marketing Executive, Sales Representative, Sales Manager, Sales
Vice-President, and Service Manager. These roles included a maximum of
5 different pre-built dashboards. Each dashboard page had an average of
5 reports in the form of a mix of charts, tables and pivot tables,
returning anywhere from 50 rows to approximately 500 rows of aggregated
data. The test scenario also included drill-down into multiple levels
from a table or chart within a dashboard. 
  
  
The benchmark test scenario uses a typical business user sequence of
dashboard navigation, report viewing, and drill down. For example, a
Service Manager logs into the system and navigates to his own set of
dashboards using Service Manager. The BI user selects the Service
Effectiveness dashboard, which shows him four distinct reports,
Service Request Trend, First Time Fix Rate, Activity Problem Areas, and
Cost Per Completed Service Call spanning 2002 to 2005. The user then proceeds
to view the Customer Satisfaction dashboard, which also contains a set
of 4 related reports, drills down on some of the reports to see the
detail data. The BI user continues to view more dashboards 
– Customer
Satisfaction and Service Request Overview, for example. After
navigating through those dashboards, the user logs out of the
application. 
The benchmark test is executed against a full production
version of the Oracle Business Intelligence 11g
Applications with a
fully populated underlying database schema. 
The business processes in the test scenario closely represent
a real world customer scenario.
 
  See Also 
   
     SPARC T4-4 Server  
oracle.com 
OTN   
    
Oracle Business Intelligence   
oracle.com 
OTN   
    
Oracle Database 11g Release 2 Enterprise Edition   
oracle.com 
OTN   
    
WebLogic Suite  
oracle.com 
OTN   
    
Oracle Solaris   
oracle.com 
OTN   
   
  Disclosure Statement 
  
 Copyright 2012, Oracle and/or its affiliates. All rights reserved.
 Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names
 may be trademarks of their respective owners. Results as of 30 September 2012.