SPECjAppServer2001 Result Sun Microsystems SunFire V1280 with Oracle 9i Application Server Metric: 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 -------------------------------------------------------------------------------- Benchmark Settings -------------------------------------------------------------------------------- Orders Injection Rate: 305 # of Order Agents: 1 # of Manufacturing Agents: 1 DB Load Injection Rate: 305 Ramp Up Time: 600 seconds Ramp Down Time: 300 seconds Steady State Time: 1800 seconds 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 -------------------------------------------------------------------------------- Software Descriptions -------------------------------------------------------------------------------- EJB Container Name: Oracle9iAS Release 2, Standard Edition v9.0.2.1.0 Vendor: Oracle Corporation Available: Aug-2002 Instances: 4 Passed CTS: May-2001 Protocol: RMI/IIOP 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: 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 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: 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 Vendor: Apache.org Available: Dec-2000 JVM Name: Java(TM) 2 Runtime Environment, Standard Edition Version 1.4.1 JVM Vendor: Sun Microsystems, Inc. JVM 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 -------------------------------------------------------------------------------- Hardware Descriptions -------------------------------------------------------------------------------- J2EE Application Server (1 system) Hardware Vendor: Sun Microsystems, Inc. Model Name: Sun Fire V1280 Processor: UltraSparc III Cu MHz: 900 # of CPUs: 12 cores, 12 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: 2x36Gb 10K RPM SCSI Network Interface: 2 100BaseT Ethernet Other Hardware: # of Systems: 1 H/W Available: Nov-2002 O/S 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. 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: 6x18Gb 10K RPM FibreChannel Network Interface: 100BaseT Ethernet Other Hardware: Sun StorEdge T3 Array for the Workgroup (9x36GB 10RPM FibreChannel Disk Array) # of Systems: 1 H/W Available: May-2002 O/S 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. Model Name: E420R Processor: UltraSparc II MHz: 450 # of CPUs: 4 cores, 4 chips, 1 core/chip Memory (MB): 4096 L1 Cache: 16KBI+16KBD L2 Cache: 4BM(I+D) Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 8 2/02 Operating Environment Disks: 1x18GB Network Interface: 100BaseT Other Hardware: # of Systems: 1 H/W Available: Feb-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 -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 SPEC 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 (C) 2002 Standard Performance Evaluation Corporation