SPECjAppServer2002 Result Oracle Application Server 10g Standard Edition v9.0.4.0.1 Pre-Release on HP ProLiant ML370G3 Metric: 863.40 TOPS@MultipleNode 168.62 US$/TOPS@MultipleNode Submitter: Oracle Corporation, SPEC license # 73, Test date: Aug-2003 EJB Container Avail: Nov-2003, EJB Container JVM Avail: Jul-2003 -------------------------------------------------------------------------------- Benchmark Settings -------------------------------------------------------------------------------- Orders Injection Rate: 500 # of Order Agents: 3 # of Manufacturing Agents: 2 DB Load Injection Rate: 500 Ramp Up Time: 600 seconds Ramp Down Time: 300 seconds Steady State Time: 1800 seconds Trigger Time: 200 seconds Total System Cost: US$145,578 -------------------------------------------------------------------------------- Detailed Results -------------------------------------------------------------------------------- Order Transaction Mix Count Tx. Mix New Order 449,525 49.99% Change Order 179,664 19.98% Order Status 179,748 19.99% Customer Status 90,274 10.04% Total # Order Transactions 899,211 Total # Manufacturing Transactions 654,901 Response Times Average Maximum 90th% Reqd New Order 0.38 4.61 1.00 2.00 Change Order 0.20 2.36 0.50 2.00 Order Status 0.11 1.50 0.30 2.00 Customer Status 0.11 1.95 0.30 2.00 Manufacturing 2.48 6.68 4.00 5.00 Reproducibility Run (TOPS) 864.01 -------------------------------------------------------------------------------- Software Descriptions -------------------------------------------------------------------------------- EJB Container Name: Oracle Application Server 10g Standard Edition v9.0.4.0.1 Pre-Release Vendor: Oracle Corporation Available: Nov-2003 Instances: 2 Passed CTS: Nov-2003 Protocol: ORMI JVM Name: BEA WebLogic JRockit 8.1 SP1 SDK JVM Vendor: BEA Systems, Inc. Systems, Inc. JVM Available: Jul-2003 Tuning Information server.xml global-thread-pool min="19" max="19" queue="100 keepAlive="-1" debug="false server.xml taskmanager-granularity="3000000 transaction-config timeout="500000 data-sources.xml stmt-cache-size="100" inactivity-timeout="90000 System properties: -DassociateUsingThirdTable=false -Doracle.dms.sensors=none -Doracle.ias.cache=0 -DdefaultBatchSize=15 JVM Tuning Information -jrockit -Xms1500M -Xmx1500M -Xgc:parallel -------------------------------------------------------------------------------- Supplier Domain Container Name: Oracle Application Server 10g Standard Edition v9.0.4.0.1 Pre-Release Vendor: Oracle Corporation Available: Nov-2003 JVM Name: BEA Weblogic JRockit 8.1 JVM Vendor: BEA Systems, Inc. JVM Available: Jul-2003 Tuning Information server.xml global-thread-pool min="19" max="19" queue="100 keepAlive="-1" debug="false server.xml taskmanager-granularity="3000000 transaction-config timeout="500000 data-sources.xml stmt-cache-size="100" inactivity-timeout="90000 System properties: -DassociateUsingThirdTable=false -Doracle.dms.sensors=none -Doracle.ias.cache=0 -DdefaultBatchSize=15 JVM Tuning Information -jrockit -Xms300M -Xmx300M -Xgc:parallel -------------------------------------------------------------------------------- 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_03 JVM Vendor: Sun Microsystems JVM Available: Jul-2003 Tuning Information JVM Tuning Information -Xms256m -Xmx256m -------------------------------------------------------------------------------- Database Name: Oracle9i Database Release 2 Standard Edition v9.2.0.3 Vendor: Oracle Corporation Available: Jul-2003 Tuning Information init.ora parameters for Oracle: compatible=9.0.0.0.0 cursor_space_for_time = TRUE db_cache_size = 1900M db_file_multiblock_read_count = 128 db_files = 256 dml_locks = 600 enqueue_resources = 2000 log_buffer = 8388608 log_checkpoint_interval = 2147483647 processes = 1000 open_cursors = 2000 max_rollback_segments = 1000 shared_pool_size = 200M sessions = 1000 transactions = 1000 transactions_per_rollback_segment = 1 parallel_max_servers = 100 undo_management = AUTO undo_retention = 5 undo_suppress_errors = TRUE undo_tablespace = roll_space 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="100 -------------------------------------------------------------------------------- Other Software Name: Vendor: Available: Tuning Information -------------------------------------------------------------------------------- Hardware Descriptions -------------------------------------------------------------------------------- J2EE Application Server (2 systems) Hardware Vendor: Hewlett-Packard Model Name: ProLiant ML370G3 Processor: Intel Xeon MHz: 3060 # of CPUs: 2 cores, 2 chips, 1 core/chip Memory (MB): 4096 L1 Cache: 12Kuops(I)+8KB(D) L2 Cache: 512KB Other Cache: OS Vendor: Red Hat, Inc. OS Name: Red Hat Enterprise Linux AS 2.1 Disks: 1x18Gb 15K RPM Ultra-3 Network Interface: 1000BaseT Ethernet Other Hardware: # of Systems: 2 H/W Available: Aug-2003 O/S Available: Apr-2002 Notes / Tuning Information -------------------------------------------------------------------------------- Database Server (1 system) Hardware Vendor: Hewlett-Packard Model Name: HP ProLiant DL580G2 Processor: Intel Xeon MHz: 2800 # of CPUs: 4 cores, 4 chips, 1 core/chip Memory (MB): 4096 L1 Cache: 12Kuops(I)+8KB(D) L2 Cache: 512K Other Cache: 2MB L3 OS Vendor: Red Hat, Inc. OS Name: Red Hat Enterprise Linux AS 2.1 Disks: 9x36Gb 15K RPM Ultra-3 Network Interface: 1000BaseT Ethernet Other Hardware: HP ProLiant StorageWorks 4354R # of Systems: 1 H/W Available: Jul-2003 O/S Available: Apr-2002 Notes / Tuning Information Parameters added to /etc/sysctl.conf kernel.sysrq = 0 kernel.shmmax = 2516582400 kernel.shmmin = 1 kernel.shmmni = 100 kernel.shm-use-bigpages = 1 In grub.conf: bigpages = 2400M was specified. 4 X 36GB 15k RPM Ultra 3 RAID 0+1 for logs 4 X 36GB 15k RPM Ultra 3 RAID 0 for data files. Both data and log files were on raw partitions. -------------------------------------------------------------------------------- Load Driver (1 system) Hardware Vendor: Hewlett-Packard Model Name: HP ProLiant DL580G2 Processor: Intel Xeon MHz: 2800 # of CPUs: 4 cores, 4 chips, 1 core/chip Memory (MB): 8192 L1 Cache: 12Kuops(I)+8KB(D) L2 Cache: 512K Other Cache: 2MB L3 OS Vendor: Red Hat Inc. OS Name: Red Hat Enterprise Linux AS 2.1 Disks: 1x36GB 10k Ultra-3 Network Interface: 1000BaseT Ethernet Other Hardware: # of Systems: 1 H/W Available: Aug-2003 O/S Available: Apr-2002 Notes / Tuning Information JVM Version used: Java (TM) 2 Runtime Environment, Standard Edition Version 1.4.1_03 JVM arguments used: -Xms900m -Xmx900m -Dsun.net.inetaddr.ttl=0 -XX:+UseSpinning -XX:PreBlockSpin=100 -Dnetworkaddress.cache.ttl=0 Max threads limit was increased to 8K from 1K by rebuilding libpthreads.so. The stack size was reduced to 256K. The following was added to /etc/sysctl.conf net.ipv.tcp_max_syn_backlog = 8192 kernel.sem = 1000 32000 32 512 fs.file-max = 65535 kernel.shmmax = 2147483648 The following was added to /etc/security/limits.conf soft nofile 8192 hard nofile 8192 Added in /etc/pam.d/login session required /lib/security/pam_limits.so -------------------------------------------------------------------------------- Emulator (1 system) Hardware Vendor: Hewlett-Packard Model Name: HP ProLiant ML530 Processor: Intel Xeon MHz: 2800 # of CPUs: 2 cores, 2 chips, 1 core/chip Memory (MB): 8192 L1 Cache: 12Kuops(I)+8KB(D) L2 Cache: 512K Other Cache: OS Vendor: Red Hat Inc. OS Name: Red Hat Enterprise Linux AS 2.1 Disks: 1x72GB 10k Ultra-3 Network Interface: 1000BaseT Ethernet Other Hardware: # of Systems: 1 H/W Available: Aug-2003 O/S Available: Apr-2002 Notes / Tuning Information JVM Version used: Java (TM) 2 Runtime Environment, Standard Edition Version 1.4.1_03 JVM arguments used: -Xms256m -Xmx256m -------------------------------------------------------------------------------- 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 parameters initrans 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 -------------------------------------------------------------------------------- Durability Requirement Info: Disk mirroring was used to ensure durability for DB logs -------------------------------------------------------------------------------- Storage Requirement Info: A 45 minute run at an injection rate of 500 increased storage by 12.3GB. Extrapolating for an 8 Hr run would require 131GB. The system is configured with 288GB which is sufficient for 8Hr run. -------------------------------------------------------------------------------- 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. Requests were sent to different appservers utilizing DNS round-robin with one of the mid-tier nodes acting as the DNS server The driver used the following jndi.properties java.naming.factory.initial=com.evermind.server.rmi.RMIInitialContextFactory java.naming.provider.url=ormi://main.spec.bogus:23777/SPECjAppServer java.naming.security.principal=admin java.naming.security.credentials=welcome dedicated.rmicontext=true -------------------------------------------------------------------------------- General Notes -------------------------------------------------------------------------------- No errors were reported during the final or reproducability run -------------------------------------------------------------------------------- For questions about this result, please contact the submitter: Oracle Corporation For other inquiries, please contact SPEC Benchmark run on Sun Aug 17 16:08:08 CDT 2003 by SPECjAppServer2002 v1.14 Result submitted on Wed Aug 20 03:03:02 EDT 2003 Report generated by SPECjAppServer2002 Reporter v1.01 Copyright (C) 2002 Standard Performance Evaluation Corporation