SPEC Seal of Reviewal SPECjAppServer2001 Result
Copyright © 2002 Standard Performance Evaluation Corporation
Sun Microsystems SunFire V880 / Oracle9iAS Release 2, Standard Edition v9.0.2.1.0
1,476.81 BOPS@MultipleNode
1,540.03 US$/BOPS@MultipleNode
Submitter:
Oracle Corporation		 SPEC license # 73 Test date:
Oct-2002		 EJB Container Avail: Aug-2002
EJB Container JVM Avail: Oct-2002
Software
EJB Container
Supplier Domain Container
Emulator Container
Database
JDBC
Other Software 		Hardware
J2EE Application Server
Database Server
Load Driver 		Benchmark
Modifications
Configuration
Other Info
General Notes 		Links
System Configuration Diagram

Full Disclosure Archive


Benchmark Settings
Orders Injection Rate: 860 Ramp Up Time: 600 seconds
# of Order Agents: 3 Ramp Down Time: 300 seconds
# of Manufacturing Agents: 3 Steady State Time: 1800 seconds
DB Load Injection Rate: 860 Trigger Time: 360 seconds
Total System Cost: US$2,274,329

Detailed Results
Order Transaction Mix Count Tx. Mix
New Order 766,894 50.01%
Change Order 306,544 19.99%
Order Status 306,493 19.99%
Customer Status 153,581 10.01%
Total # Order Transactions 1,533,512
Total # Manufacturing Transactions 1,124,746
Response Times Average Maximum 90th% Reqd
New Order 0.74 8.20 1.90 2.00
Change Order 0.45 3.53 1.00 2.00
Order Status 0.24 2.38 0.60 2.00
Customer Status 0.26 2.38 0.60 2.00
Manufacturing 2.92 9.10 4.00 5.00
Reproducibility Run (BOPS) 1,478.83

EJB Container
Name: Oracle9iAS Release 2, Standard Edition v9.0.2.1.0 JVM Name: Java(TM) 2 Runtime Environment, Standard Edition Version 1.4.1
Vendor: Oracle Corporation JVM Vendor: Sun Microsystems, Inc.
Available: Aug-2002 Available: Oct-2002
Instances: 10
Passed CTS: May-2001
Protocol: ORMI
Tuning Information 
server.xml global-thread-pool min=25
server.xml global-thread-pool max=25
server.xml global-thread-pool queue=80
server.xml taskmanager-granularity="3000000
data-sources.xml stmt-cache-size=100:
JVM Tuning Information 
System properties:
-Doracle.dms.gate=false
JVM Command line:
-server -XX:+AggressiveHeap -Xms2048m -Xmx2048m

Supplier Domain Container
Name: Oracle9iAS Release 2, Standard Edition v9.0.2.1.0 JVM Name: Java(TM) 2 Runtime Environment, Standard Edition Version 1.4.1
Vendor: Oracle Corporation JVM Vendor: Sun Microsystems, Inc.
Available: Aug-2002 Available: Oct-2002
Tuning Information 
Server thread pool size min = 20
Server thread pool size max = 20
Server thread pool queue = 75
Server port: 8801
JVM Tuning Information 
System properties:
-Doracle.dms.gate=false
JVM Command line:
-server -XX:+AggressiveHeap -Xmx2500m -Xms2500m

Emulator Container
Name: Oracle9iAS Release 2, Standard Edition v9.0.2.1.0 JVM Name: Java(TM) 2 Runtime Environment, Standard Edition Version 1.4.1
Vendor: Oracle Corporation JVM Vendor: Sun Microsystems, Inc.
Available: Aug-2002 Available: Aug-2002
Tuning Information 
System properties:
-Doracle.dms.gate=false
JVM Command line:
-server -XX:+AggressiveHeap -Xmx2500m -Xms2500m
JVM Tuning Information 
System properties:
-Doracle.dms.gate=false
JVM Command line
-server -Xms512m -Xmx512m -XX:+AggressiveHeap

Database
Name: Oracle9i Database Release 2, Enterprise Edition with Partitioning Option v9.2.0.1.0
Vendor: Oracle Corporation
Available: May-2002
Tuning Information 
Commands in initspec.ora for Oracle:
compatible=9.0.0.0.0
cursor_space_for_time = TRUE
db_block_buffers =   1048576
db_file_multiblock_read_count = 128
db_files = 256
dml_locks = 2000
enqueue_resources = 2000
log_buffer = 16777216
log_checkpoint_interval = 2147483647
processes = 1000
open_cursors = 2000
shared_pool_size = 300000000
sessions = 1500
transactions = 1500
transactions_per_rollback_segment = 1
parallel_max_servers = 100
undo_management = AUTO
undo_retention = 5
undo_suppress_errors = TRUE
_spin_count=30000
db_block_checksum = false

JDBC
Name: Oracle JDBC Driver v9.0.2.1.0 (Type 2)
Vendor: Oracle Corporation
Available: Sep-2002
Tuning Information 
Statement cache size: 100
JDBC Class Used: oracle.jdbc.driver.OracleDriver

Other Software
Name:
Vendor:
Available:
Tuning Information

J2EE Application Server (5 systems)
Hardware Vendor: Sun Microsystems, Inc. OS Vendor: Sun Microsystems, Inc.
Model Name: Sun Fire V880 OS Name: Solaris 8 2/02 Operating Environment
Processor: UltraSparc III Cu Filesystem: UFS
MHz: 900 Disks: 7x36Gb SCSI
# of CPUs: 8 cores, 8 chips, 1 core/chip Network Interface: 1 100BaseT Ethernet
Memory (MB): 16384 Other Hardware:
L1 Cache: 32KBI+64KBD # of Systems: 5
L2 Cache: 8MB(I+D) off chip H/W Available: Aug-2002
Other Cache: OS Available: Feb-2002
Notes / Tuning Information 

   		
  

 













Database Server (1 system)




 

  

Hardware Vendor:
Sun Microsystems, Inc.
OS Vendor:
Sun Microsystems, Inc.
  

  

Model Name:
Sun Fire 6800
OS Name:
Solaris 8 2/02 Operating Environment
  

  

Processor:
UltraSparc III Cu
Filesystem:
UFS
  

  

MHz:
900
Disks:
2x18Gb 10K RPM SCSI
  

  

# of CPUs:
24 cores, 24 chips, 1 core/chip
Network Interface:
100BaseT Ethernet
  

  

Memory (MB):
24576
Other Hardware:
Sun StorEdge T3 Array for the Workgroup (9x72GB 10RPM FibreChannel Disk Array)
  

  

L1 Cache:
32KBI+64KBD
# of Systems:
1
  

  

L2 Cache:
8MB(I+D) off chip
H/W Available:
May-2001
  

  

Other Cache:

OS Available:
Feb-2002
  

 





 

  

Notes / Tuning Information
  

  

   


   		
  

 













Load Driver (1 system)




 

  

Hardware Vendor:
Sun Microsystems, Inc.
OS Vendor:
Sun Microsystems, Inc.
  

  

Model Name:
Sun Fire 6800
OS Name:
Solaris 8 2/02 Operating Environment
  

  

Processor:
UltraSparc III Cu
Filesystem:
UFS
  

  

MHz:
900MHz
Disks:
10x18GB SCSI
  

  

# of CPUs:
24 cores, 24 chips, 1 core/chip
Network Interface:
100BaseT Ethernet
  

  

Memory (MB):
98304
Other Hardware:

  

  

L1 Cache:
32KBI+64KBD
# of Systems:
1
  

  

L2 Cache:
8MB(I+D) off chip
H/W Available:
May-2001
  

  

Other Cache:

OS Available:
Feb-2002
  

 





 

  

Notes / Tuning Information
  

  

   

JVM Version used:
    Java(TM) 2 Runtime Environment, Standard Edition Version 1.4.1
JVM arguments used:
 -server -Xss128k -ms2048m -mx2048m -Dsun.net.inetaddr.ttl=0


   		
  

 













Benchmark Modifications




Schema Modifications:

  The following indices were added to the M_largeorder table
      CREATE UNIQUE INDEX M_lo_idx ON M_largeorder (lo_id)
       CREATE UNIQUE INDEX M_ol_o_idx ON M_largeorder (lo_o_id, lo_ol_id )
  Table sizes were increased to support larger injection rate
  Scripts to create the database are included in the FDA






Load Program Modifications:

  No modifications were made to the load program.






Reference Bean Modifications:

  No modifications were made to the reference beans.














Benchmark Configuration Information




Persistence Mode Used:

  CMP mode was used for all beans






Isolation Requirement Info:

  Beans with a READ_COMMITTED requirement were deployed using
  locking-mode=optimistic in their deployment descriptor.
  
  All other beans were deployed using
  locking-mode=pessimistic in their deployment descriptor.
  
  A pessimistic locking mode means that all selects (including during finders) are issued with a FOR UPDATE clause.






Durability Requirement Info:

  The Redo log disks are mirrored (RAID 0+1).
  The database commits all changes to the redo log when each transaction is complete.






Storage Requirement Info:

  A 45 minute run at  an injection rate of 860
  required 21.20 GB of storage.
  This extrapolates to 226.2 GB of storage for an 8-hour run.
  The system is configured with 686GB of storage for the database.






Argument Passing Semantics:

  Oracle Application Server uses pass-by-value
  as required by the EJB specification














Other Benchmark Information





  This submission used the xerces.jar from the SPECjAppServer2001 Kit.
  The xerces.jar file was copied to the lib directory of the application server.
  
  No hardware or software was used to alter basic network routing.
  
  Requests were sent to the different instances of the application server by
  utilizing DNS round robin with one middle tier node acting
  as the DNS server. The driver used the following jndi.properties file:
      java.naming.factory.initial=com.evermind.server.rmi.RMIInitialContextFactory
      java.naming.provider.url=ormi://apps.sjas.perf:24002/sjas
      java.naming.security.principal=admin
      java.naming.security.credentials=spec
      dedicated.rmicontext=true














General Notes
















For questions about this result, please contact the submitter: Oracle Corporation

For other inquiries, please contact
webmaster@spec.org


Benchmark run on Wed Oct 16 12:52:06 PDT 2002 by SPECjAppServer2001 v1.12

Result submitted on Thu Oct 17 03:03:00 EDT 2002

Report generated by SPECjAppServer2001 Reporter v1.09


Copyright © 2002 Standard Performance Evaluation Corporation



First published at SPEC.org on 01-Nov-2002