SPECjAppServer2001 Result Sun Microsystems SunFire V880 / Oracle9iAS Release 2, Standard Edition v9.0.2.1.0 Metric: 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 -------------------------------------------------------------------------------- Benchmark Settings -------------------------------------------------------------------------------- Orders Injection Rate: 860 # of Order Agents: 3 # of Manufacturing Agents: 3 DB Load Injection Rate: 860 Ramp Up Time: 600 seconds Ramp Down Time: 300 seconds Steady State Time: 1800 seconds 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 -------------------------------------------------------------------------------- Software Descriptions -------------------------------------------------------------------------------- EJB Container Name: Oracle9iAS Release 2, Standard Edition v9.0.2.1.0 Vendor: Oracle Corporation Available: Aug-2002 Instances: 10 Passed CTS: May-2001 Protocol: ORMI JVM Name: Java(TM) 2 Runtime Environment, Standard Edition Version 1.4.1 JVM Vendor: Sun Microsystems, Inc. JVM Available: Oct-2002 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 Vendor: Oracle Corporation Available: Aug-2002 JVM Name: Java(TM) 2 Runtime Environment, Standard Edition Version 1.4.1 JVM Vendor: Sun Microsystems, Inc. JVM 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 Vendor: Oracle Corporation Available: Aug-2002 JVM Name: Java(TM) 2 Runtime Environment, Standard Edition Version 1.4.1 JVM Vendor: Sun Microsystems, Inc. JVM 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 -------------------------------------------------------------------------------- Hardware Descriptions -------------------------------------------------------------------------------- J2EE Application Server (5 systems) Hardware Vendor: Sun Microsystems, Inc. Model Name: Sun Fire V880 Processor: UltraSparc III Cu MHz: 900 # of CPUs: 8 cores, 8 chips, 1 core/chip Memory (MB): 16384 L1 Cache: 32KBI+64KBD L2 Cache: 8MB(I+D) off chip Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 8 2/02 Operating Environment Disks: 7x36Gb SCSI Network Interface: 1 100BaseT Ethernet Other Hardware: # of Systems: 5 H/W Available: Aug-2002 O/S Available: Feb-2002 Notes / Tuning Information No notes provided -------------------------------------------------------------------------------- Database Server (1 system) Hardware Vendor: Sun Microsystems, Inc. Model Name: Sun Fire 6800 Processor: UltraSparc III Cu MHz: 900 # of CPUs: 24 cores, 24 chips, 1 core/chip Memory (MB): 24576 L1 Cache: 32KBI+64KBD L2 Cache: 8MB(I+D) off chip Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 8 2/02 Operating Environment Disks: 2x18Gb 10K RPM SCSI Network Interface: 100BaseT Ethernet Other Hardware: Sun StorEdge T3 Array for the Workgroup (9x72GB 10RPM FibreChannel Disk Array) # of Systems: 1 H/W Available: May-2001 O/S Available: Feb-2002 Notes / Tuning Information No notes provided -------------------------------------------------------------------------------- Load Driver (1 system) Hardware Vendor: Sun Microsystems, Inc. Model Name: Sun Fire 6800 Processor: UltraSparc III Cu MHz: 900MHz # of CPUs: 24 cores, 24 chips, 1 core/chip Memory (MB): 98304 L1 Cache: 32KBI+64KBD L2 Cache: 8MB(I+D) off chip Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 8 2/02 Operating Environment Disks: 10x18GB SCSI Network Interface: 100BaseT Ethernet Other Hardware: # of Systems: 1 H/W Available: May-2001 O/S 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 SPEC 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 (C) 2002 Standard Performance Evaluation Corporation