SPECjAppServer2002 Result Oracle Application Server 10g Java Edition v9.0.4.0.1 on Sun Fire V20z Metric: 690.13 TOPS@DualNode 101.10 US$/TOPS@DualNode Submitter: Sun Microsystems Inc., SPEC license # 6, Test date: Mar-2004 EJB Container Avail: Nov-2003, EJB Container JVM Avail: Mar-2004 -------------------------------------------------------------------------------- Benchmark Settings -------------------------------------------------------------------------------- Orders Injection Rate: 401 # of Order Agents: 2 # of Manufacturing Agents: 2 DB Load Injection Rate: 401 Ramp Up Time: 600 seconds Ramp Down Time: 300 seconds Steady State Time: 1800 seconds Trigger Time: 401 seconds Total System Cost: US$69,766 -------------------------------------------------------------------------------- Detailed Results -------------------------------------------------------------------------------- Order Transaction Mix Count Tx. Mix New Order 356,940 49.82% Change Order 143,477 20.03% Order Status 144,228 20.13% Customer Status 71,793 10.02% Total # Order Transactions 716,438 Total # Manufacturing Transactions 525,794 Response Times Average Maximum 90th% Reqd New Order 0.79 6.28 2.00 2.00 Change Order 0.42 2.52 1.00 2.00 Order Status 0.23 1.75 0.60 2.00 Customer Status 0.23 1.76 0.60 2.00 Manufacturing 1.92 5.90 3.00 5.00 Reproducibility Run (TOPS) 692.00 -------------------------------------------------------------------------------- Software Descriptions -------------------------------------------------------------------------------- EJB Container Name: Oracle Application Server 10g Java Edition v9.0.4.0.1 Vendor: Oracle Corporation Available: Nov-2003 Instances: 1 Passed CTS: Nov-2003 Protocol: ORMI JVM Name: Java(TM) 2 Runtime Environment, Standard Edition, Version 1.4.2_04 32-bit JVM Vendor: Sun Microsystems, Inc. JVM Available: Mar-2004 Tuning Information server.xml: global-thread-pool min="40" max="40" queue="100" keepAlive="-1" debug="false server.xml: taskmanager-granularity="1000000" transaction-config timeout="500000 data-sources.xml: stmt-cache-size="200" inactivity-timeout="30000 System properties: -DassociateUsingThirdTable=false -Doracle.dms.sensors=none -Doracle.ias.cache=0 -DdefaultBatchSize=15 -DoneToOneJoin=true -DKeepWrapperCode=true JVM Tuning Information -server -XX:+UseSpinning -XX:PreBlockSpin=100 -Xms1800m -Xmx1800m -Xmn768m-XX:+UseParallelGC -XX:+UseTLAB -XX:-UseAdaptiveSizePolicy -XX:SurvivorRatio=2 -XX:+DisableExplicitGC -verbose:gc -------------------------------------------------------------------------------- Supplier Domain Container Name: Oracle Application Server 10g Java Edition v9.0.4.0.1 Vendor: Oracle Corporation Available: Nov-2003 JVM Name: Java(TM) 2 Runtime Environment, Standard Edition, Version 1.4.2_04 32-bit JVM Vendor: Sun Microsystems, Inc JVM Available: Mar-2004 Tuning Information server.xml: global-thread-pool min="25" max="25" queue="100" keepAlive="-1" debug="false server.xml: taskmanager-granularity="1000000" transaction-config timeout="500000 data-sources.xml: stmt-cache-size="200" inactivity-timeout="30000 System properties: -DassociateUsingThirdTable=false -Doracle.dms.sensors=none -Doracle.ias.cache=0 -DdefaultBatchSize=15 -DoneToOneJoin=true -DKeepWrapperCode=true JVM Tuning Information -server -XX:+UseSpinning -XX:PreBlockSpin=100 -Xms1800m -Xmx1800m -Xmn768m -XX:+UseParallelGC -XX:+UseTLAB -XX:-UseAdaptiveSizePolicy -XX:SurvivorRatio=2 -XX:+DisableExplicitGC -verbose:gc -------------------------------------------------------------------------------- Emulator Container Name: Jakarta Tomcat 4.0.3 Vendor: Apache Available: Nov-2003 JVM Name: Java(TM) 2 Runtime Environment, Standard Edition, Version 1.4.2 32-bit JVM Vendor: Sun Microsystems, Inc JVM Available: Jul-2003 Tuning Information JVM Tuning Information -server -Xmx1024m -Xms1024m -------------------------------------------------------------------------------- Database Name: Oracle9i Database Release 2, Standard Edition v9.2.0.4 Vendor: Oracle Corporation Available: Aug-2003 Tuning Information db_name=specdb control_files = /specdb/9i/cntrlspecdb compatible=9.0.0.0.0 cursor_space_for_time = TRUE db_cache_size = 1280M db_file_multiblock_read_count = 128 db_files = 256 dml_locks = 600 enqueue_resources = 2000 log_buffer = 4194304 log_checkpoint_interval = 2147483647 processes = 1000 open_cursors = 2000 shared_pool_size = 200M sessions = 800 transactions = 800 transactions_per_rollback_segment = 1 parallel_max_servers = 100 undo_management = AUTO undo_retention = 5 undo_suppress_errors = TRUE statistics_level = BASIC trace_enabled = FALSE -------------------------------------------------------------------------------- JDBC Name: Oracle JDBC Driver 10.1.0.1.1 (Thin) Vendor: Oracle Corporation Available: Nov-2003 Tuning Information stmt-cache-size="200 -------------------------------------------------------------------------------- Other Software Name: Vendor: Available: Tuning Information -------------------------------------------------------------------------------- Hardware Descriptions -------------------------------------------------------------------------------- J2EE Application Server (1 system) Hardware Vendor: Sun Microsystems, Inc. Model Name: Sun Fire V20z Processor: AMD Opteron 248 MHz: 2200 # of CPUs: 2 cores, 2 chips, 1 core/chip Memory (MB): 4096 L1 Cache: 64KB(I)+64KB(D) per chip L2 Cache: 1MB per chip Other Cache: OS Vendor: Red Hat, Inc. OS Name: Red Hat Enterprise Linux AS Release 3 (Taroon) 32-bit Disks: 1x36Gb 10K RPM Ultra-3 Network Interface: (2) 10/100/1000 BaseT Ethernet Other Hardware: # of Systems: 1 H/W Available: Mar-2004 O/S Available: Mar-2004 Notes / Tuning Information No notes provided -------------------------------------------------------------------------------- Database Server (1 system) Hardware Vendor: Sun Microsystems, Inc. Model Name: Sun Fire V20z Processor: AMD Opteron 248 MHz: 2200 # of CPUs: 2 cores, 2 chips, 1 core/chip Memory (MB): 4096 L1 Cache: 64KB(I)+64KB(D) per chip L2 Cache: 1MB per chip Other Cache: OS Vendor: Red Hat, Inc. OS Name: Red Hat Enterprise Linux AS Release 3 (Taroon) 32-bit Disks: 1x36Gb 10K RPM Ultra-3 Network Interface: (2) onboard 10/100/1000 BaseT Ethernet Other Hardware: (1) Sun StorEdge 3310 SCSI Array (5 x 73GB 10K RPM Ultra160 SCSI) # of Systems: 1 H/W Available: Mar-2004 O/S Available: Mar-2004 Notes / Tuning Information Parameters added to /etc/sysctl.conf: kernel.shmmax = 2147483648 kernel.semopm = 100 -------------------------------------------------------------------------------- Load Driver (1 system) Hardware Vendor: Sun Microsystems, Inc. Model Name: Sun Fire V440 Processor: UltraSPARC IIIi MHz: 1280 MHz # of CPUs: 4 cores, 4 chips, 1 core/chip Memory (MB): 16384 L1 Cache: 32KB(I)+64KB(D) per chip L2 Cache: 1MB per chip Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 9 4/04 Disks: 4x36GB Network Interface: 10/100/1000 BaseT Ethernet Other Hardware: # of Systems: 1 H/W Available: Aug-2003 O/S Available: Apr-2004 Notes / Tuning Information -------------------------------------------------------------------------------- Benchmark Modifications -------------------------------------------------------------------------------- Schema Modifications: Tablespace sizes were increased to support the Injection rate Scripts to create the DB are included in the FDA Two indexes were created on 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 and index initrans parameters were modified. -------------------------------------------------------------------------------- Load Program Modifications: The load program was not modified -------------------------------------------------------------------------------- Reference Bean Modifications: No changes 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 descriptors All other beans were deployed using locking-mode="pessimistic Pessimistic locking mode means that all selects (including during finders) are issued with a FOR UPDATE clause in the select statement -------------------------------------------------------------------------------- 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 completed. -------------------------------------------------------------------------------- Storage Requirement Info: A 45 minute run at an injection rate of 401 increased storage by 9.87 GB. This extrapolates to 105.28 GB of storage for an 8-hour run. The database system is configured with 365 GB of storage. -------------------------------------------------------------------------------- Argument Passing Semantics: Oracle Application Server 10g uses pass-by-value as required by the EJB specification -------------------------------------------------------------------------------- Other Benchmark Information -------------------------------------------------------------------------------- This submission used the xerces.jar from the SPECjAppServer2002 kit. No hardware or software was used to alter basic network routing. -------------------------------------------------------------------------------- General Notes -------------------------------------------------------------------------------- No errors were reported during the final or reproducability run. -------------------------------------------------------------------------------- For questions about this result, please contact the submitter: Sun Microsystems Inc. For other inquiries, please contact SPEC Benchmark run on Sun Mar 28 09:16:12 EST 2004 by SPECjAppServer2002 v1.14 Result submitted on Wed Mar 31 03:03:01 EST 2004 Report generated by SPECjAppServer2002 Reporter v1.01 Copyright (C) 2002 Standard Performance Evaluation Corporation