SPEC Seal of Reviewal SPECjAppServer2001 Result
Copyright © 2002 Standard Performance Evaluation Corporation
Sun Microsystems SunFire V1280 with Oracle 9i Application Server
521.86 BOPS@DualNode
1,133.64 US$/BOPS@DualNode
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: 305 Ramp Up Time: 600 seconds
# of Order Agents: 1 Ramp Down Time: 300 seconds
# of Manufacturing Agents: 1 Steady State Time: 1800 seconds
DB Load Injection Rate: 305 Trigger Time: 300 seconds
Total System Cost: US$591,605

Detailed Results
Order Transaction Mix Count Tx. Mix
New Order 270,752 49.95%
Change Order 108,211 19.96%
Order Status 108,904 20.09%
Customer Status 54,141 9.99%
Total # Order Transactions 542,008
Total # Manufacturing Transactions 397,347
Response Times Average Maximum 90th% Reqd
New Order 0.77 11.64 2.00 2.00
Change Order 0.47 6.15 1.10 2.00
Order Status 0.25 3.49 0.60 2.00
Customer Status 0.28 3.96 0.70 2.00
Manufacturing 2.36 10.60 3.75 5.00
Reproducibility Run (BOPS) 521.95

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: 4
Passed CTS: May-2001
Protocol: RMI/IIOP
Tuning Information 
Server thread pool size: 40
Server connection pool size: 60
Server statement cache size: 300
JVM Tuning Information 
System properties:
   -Doracle.dms.gate=false
JVM Command line:
   -server -XX:+AggressiveHeap -Xmx3500m -Xms3500m

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: 40
Server port: 8080

Note: This is a separate (and 5th) instance of the application server.
JVM Tuning Information 
System properties:
   -Doracle.dms.gate=false
JVM Command line:
   -server -XX:+AggressiveHeap -Xmx3500m -Xms3500m

Emulator Container
Name: Jakarta Tomcat 3.2.1 JVM Name: Java(TM) 2 Runtime Environment, Standard Edition Version 1.4.1
Vendor: Apache.org JVM Vendor: Sun Microsystems, Inc.
Available: Dec-2000 Available: Oct-2002
Tuning Information
JVM Tuning Information 
Command line arguments: -server -Xmx1024m -Xms1024m

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 initspecdb.ora for Oracle:
    compatible=9.0.1.0.0
    cursor_space_for_time = TRUE
    db_block_buffers = 320000
    db_file_multiblock_read_count = 128
    db_files = 256
    dml_locks = 600
    enqueue_resources = 1235
    log_buffer = 2097152
    log_checkpoint_interval = 2147483647
    processes = 1000
    open_cursors = 2000
    shared_pool_size = 100000000
    sessions = 1105
    transactions = 800
    transactions_per_rollback_segment = 1
    parallel_max_servers = 100
    undo_management = AUTO
    undo_retention = 5
    undo_suppress_errors = TRUE
    db_block_size = 2048
    session_cached_cursors = 2000
    sort_area_size = 524288

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

Other Software
Name:
Vendor:
Available:
Tuning Information

J2EE Application Server (1 system)
Hardware Vendor: Sun Microsystems, Inc. OS Vendor: Sun Microsystems, Inc.
Model Name: Sun Fire V1280 OS Name: Solaris 8 2/02 Operating Environment
Processor: UltraSparc III Cu Filesystem: UFS
MHz: 900 Disks: 2x36Gb 10K RPM SCSI
# of CPUs: 12 cores, 12 chips, 1 core/chip Network Interface: 2 100BaseT Ethernet
Memory (MB): 24576 Other Hardware:
L1 Cache: 32KBI+64KBD # of Systems: 1
L2 Cache: 8MB(I+D) off chip H/W Available: Nov-2002
Other Cache: OS Available: Feb-2002
Notes / Tuning Information 
The following TCP tunings were made:
    tcp_time_wait_interval 60000
    tcp_conn_req_max_q 16384
    tcp_conn_req_max_q0 16384
    tcp_ip_abort_interval 60000
    tcp_keepalive_interval 7200000
    tcp_rexmit_interval_initial 4000
    tcp_rexmit_interval_max 10000
    tcp_rexmit_interval_min 3000
    tcp_smallest_anon_port 32768
    tcp_slow_start_initial 2
    tcp_xmit_hiwat 32768
    tcp_recv_hiwat 32768
The OS scheduler was modified using the set_db_dispatch script
included in the archive.

Database Server (1 system)
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: 6x18Gb 10K RPM FibreChannel
# of CPUs: 8 cores, 8 chips, 1 core/chip Network Interface: 100BaseT Ethernet
Memory (MB): 16384 Other Hardware: Sun StorEdge T3 Array for the Workgroup (9x36GB 10RPM FibreChannel Disk Array)
L1 Cache: 32KBI+64KBD # of Systems: 1
L2 Cache: 8MB(I+D) off chip H/W Available: May-2002
Other Cache: OS Available: Feb-2002
Notes / Tuning Information 
The following TCP tunings were made:
    tcp_time_wait_interval 60000
    tcp_conn_req_max_q 16384
    tcp_conn_req_max_q0 16384
    tcp_ip_abort_interval 60000
    tcp_keepalive_interval 7200000
    tcp_rexmit_interval_initial 4000
    tcp_rexmit_interval_max 10000
    tcp_rexmit_interval_min 3000
    tcp_smallest_anon_port 32768
    tcp_slow_start_initial 2
    tcp_xmit_hiwat 32768
    tcp_recv_hiwat 32768
The OS scheduler was modified using the set_db_dispatch script

Load Driver (1 system)
Hardware Vendor: Sun Microsystems, Inc. OS Vendor: Sun Microsystems, Inc.
Model Name: E420R OS Name: Solaris 8 2/02 Operating Environment
Processor: UltraSparc II Filesystem: UFS
MHz: 450 Disks: 1x18GB
# of CPUs: 4 cores, 4 chips, 1 core/chip Network Interface: 100BaseT
Memory (MB): 4096 Other Hardware:
L1 Cache: 16KBI+16KBD # of Systems: 1
L2 Cache: 4BM(I+D) H/W Available: Feb-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 -Xmx2048m

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:
Reference Bean Modifications:

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: 
  All drives on the system are configured for mirroring (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 with an injection rate of 305
  required 931 MB of storage for tables and
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 the application server 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://ecapps:23791/sjas
      java.naming.security.principal=admin
      java.naming.security.credentials=spec
      dedicated.rmicontext=true
  The java.security file on the driver machine was modified to allow DNS round-robin to work by specifying
      networkaddress.cache.ttl=0

General Notes

For questions about this result, please contact the submitter: Oracle Corporation
For other inquiries, please contact webmaster@spec.org

Benchmark run on Tue Oct 15 15:44:44 EDT 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 10-Feb-2003