SPECjAppServer2002 Result Sun Microsystems SunFire V1280 / BEA WebLogic Server 8.1, Advantage Edition NON-COMPLIANT (NC) RESULT Submitter: BEA Systems, Inc., SPEC license # 72, Test date: Feb-2003 EJB Container Avail: Apr-2003, EJB Container JVM Avail: Feb-2003 -------------------------------------------------------------------------------- SPEC has determined that this result was not in compliance with the SPECjAppServer2002 run and reporting rules. Specifically, the application server maintenance pricing was incorrect for the required three year term. The corrected result is available at http://www.spec.org/jAppServer2002/results/res2003q2/jAppServer2002-20030424-00 09.html -------------------------------------------------------------------------------- Benchmark Settings -------------------------------------------------------------------------------- Orders Injection Rate: 1034 # of Order Agents: 3 # of Manufacturing Agents: 3 DB Load Injection Rate: 1034 Ramp Up Time: 600 seconds Ramp Down Time: 300 seconds Steady State Time: 1800 seconds Trigger Time: 723 seconds Total System Cost: US$2,451,520 -------------------------------------------------------------------------------- Detailed Results -------------------------------------------------------------------------------- Order Transaction Mix Count Tx. Mix New Order 911,751 49.95% Change Order 365,203 20.01% Order Status 366,099 20.06% Customer Status 182,261 9.99% Total # Order Transactions 1,825,314 Total # Manufacturing Transactions 1,331,626 Response Times Average Maximum 90th% Reqd New Order 0.27 11.90 0.60 2.00 Change Order 0.17 6.38 0.40 2.00 Order Status 0.07 6.20 0.20 2.00 Customer Status 0.08 5.93 0.20 2.00 Manufacturing 3.68 10.22 5.00 5.00 Reproducibility Run (TOPS) 1,754.37 -------------------------------------------------------------------------------- Software Descriptions -------------------------------------------------------------------------------- EJB Container Name: BEA WebLogic 8.1, Advantage Edition Beta Vendor: BEA Systems, Inc. Available: Apr-2003 Instances: 6 Passed CTS: Apr-2003 Protocol: RMI/t3 JVM Name: Java(TM) 2 Runtime Environment, Standard EditionVersion 1.4.1_02 JVM Vendor: Sun Microsystems, Inc. JVM Available: Feb-2003 Tuning Information -Dweblogic.oci.selectBlobChunkSize=1600 -Dweblogic.SocketReaders=1 JVM Tuning Information JVM command line -server -XX:+UseMPSS -XX:+AggressiveHeap -Xms3500m -Xmx3500m -Xmn600m -XX:MaxTenuringThreshold=3 -XX:SurvivorRatio=20 -------------------------------------------------------------------------------- Supplier Domain Container Name: BEA WebLogic 8.1, Advantage Edition Beta Vendor: BEA Systems, Inc. Available: Apr-2003 JVM Name: Java(TM) 2 Runtime Environment, Standard Edition Version 1.4.1_02 JVM Vendor: Sun Microsystems, Inc. JVM Available: Feb-2003 Tuning Information -Dweblogic.oci.selectBlobChunkSize=1600 -Dweblogic.SocketReaders=1 JVM Tuning Information JVM command line -server -XX:+UseMPSS -XX:+AggressiveHeap -Xms3500m -Xmx3500m -Xmn600m -XX:MaxTenuringThreshold=3 -XX:SurvivorRatio=20 -------------------------------------------------------------------------------- Emulator Container Name: BEA WebLogic 8.1, Advantage Edition Beta Vendor: BEA Systems, Inc. Available: Apr-2003 JVM Name: Java(TM) 2 Runtime Environment, Standard Edition Version 1.4.1_02 JVM Vendor: Sun Microsystems, Inc. JVM Available: Feb-2003 Tuning Information JVM Tuning Information -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 initspec.ora for Oracle: compatible = 9.0.0.0.0 timed_statistics=true transaction_auditing=FALSE cursor_space_for_time = TRUE db_block_size=2048 db_block_buffers = 1048000 db_file_multiblock_read_count = 128 db_files = 256 dml_locks = 20000 session_cached_cursors = 710 enqueue_resources = 60000 log_buffer = 524288 log_checkpoint_interval = 0 fast_start_mttr_target = 0 log_checkpoint_timeout = 0 processes = 700 open_cursors = 2000 max_rollback_segments = 200 shared_pool_size = 600000000 sessions = 710 transactions = 710 transactions_per_rollback_segment = 1 parallel_max_servers = 100 sort_area_size = 52428800 undo_management = AUTO undo_retention = 5 undo_suppress_errors = TRUE undo_tablespace = roll_space -------------------------------------------------------------------------------- JDBC Name: BEA Weblogic 8.1 jDriver for Oracle Vendor: BEA Systems, Inc. Available: Apr-2003 Tuning Information Statement cache size: 300 -------------------------------------------------------------------------------- Other Software Name: Vendor: Available: Tuning Information -------------------------------------------------------------------------------- Hardware Descriptions -------------------------------------------------------------------------------- J2EE Application Server (3 systems) 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 9 9/02 Operating Environment Disks: 2x36Gb SCSI Network Interface: 2 1000BaseT Ethernet Other Hardware: # of Systems: 3 H/W Available: Mar-2003 O/S Available: Jan-2003 Notes / Tuning Information Please see the file appserver.txt in the Tuning sub-directory of the FDA. -------------------------------------------------------------------------------- Database Server (1 system) Hardware Vendor: Sun Microsystems, Inc. Model Name: Sun Fire 6800 Processor: UltraSPARC III Cu MHz: 900 # of CPUs: 20 cores, 20 chips, 1 core/chip Memory (MB): 20480 L1 Cache: 32KBI+64KBD L2 Cache: 8MB(I+D) off chip Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 9 12/02 Operating Environment Disks: 2x72Gb 10K RPM SCSI Network Interface: 3 1000BaseT Ethernet Other Hardware: Sun StorEdge T3 Array for the Workgroup (9x72GB 10K RPM FibreChannel Disk Array) # of Systems: 1 H/W Available: Feb-2002 O/S Available: Jan-2003 Notes / Tuning Information Please see the file dbserver.txt in the Tuning sub-directory of the FDA. -------------------------------------------------------------------------------- Load Driver (1 system) Hardware Vendor: Sun Microsystems, Inc. Model Name: Sun Enterprise 6500 Processor: UltraSPARC II MHz: 400 # of CPUs: 24 cores, 24 chips, 1 core/chip Memory (MB): 24576 L1 Cache: 16KI+16KD L2 Cache: 8MB(I+D) off chip Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 8 2/02 Operating Environment Disks: 3x18Gb 10K RPM SCSI Network Interface: 3 1000BaseT Ethernet Other Hardware: # of Systems: 1 H/W Available: May-2001 O/S Available: Feb-2002 Notes / Tuning Information Please see the file driver.txt in the Tuning sub-directory of the FDA. -------------------------------------------------------------------------------- Benchmark Modifications -------------------------------------------------------------------------------- Schema Modifications: An oc_version column and trigger was added to tables which had an isolation level of optimistic concurrency. Table sizes were increased to support larger injection rates. Some storage clauses were modified to improve performance Two indexes were created in 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 ) -------------------------------------------------------------------------------- Load Program Modifications: To make the load programs work with or without an optimistic concurrency column, The database load programs were changed to load specific columns. the modified load programs and the modified source code are included in the FDA. -------------------------------------------------------------------------------- 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: SPEC_REQUIREMENT Deployment CORP: RuleEnt Read_Committed RC DiscountEnt Read_Committed RC CustomerEnt Read_Committed RC MFG: AssemblyEnt Read_Committed OPTCONC BomEnt Read_Committed RC ComponentEnt Read_Committed RC PartEnt Read_Committed OPTCONC WorkOrderEnt Repeatable_Read OPTCONC LargeOrderEnt Read_Committed RC InventoryEnt Repeatable_Read Sel-4-Upd ORDERS: OrderLineEnt Repeatable_Read Sel-4-Upd OrderCustomerEnt Read_Committed RC ItemEnt Read_Committed RC OrderEnt Repeatable_Read Sel-4-Upd SUPPLIER: SupplierEnt Read_Committed OPTCONC SupplierCompEnt Read_Committed OPTCONC SComponentEnt Repeatable_Read Sel-4-Upd POEnt Repeatable_Read OPTCONC POLineEnt Repeatable_Read OPTCONC Transaction consistency for those beans specifying field groups was proven by manual analysis of the source code. -------------------------------------------------------------------------------- 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 1034 required 27.98 GB of storage. This extrapolates to 295.55 GB of storage for an 8-hour run. The database system is configured with 648 GB of storage. -------------------------------------------------------------------------------- Argument Passing Semantics: BEA WebLogic 8.1 uses pass-by-value -------------------------------------------------------------------------------- Other Benchmark Information -------------------------------------------------------------------------------- The xerces.jar package in the jars sub-directory of the SPECjAppServer2002 V1.14 kit was used for the submission. 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 -------------------------------------------------------------------------------- General Notes -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- For questions about this result, please contact the submitter: BEA Systems, Inc. For other inquiries, please contact SPEC Benchmark run on Sun Feb 16 06:57:46 PST 2003 by SPECjAppServer2002 v1.14 Result submitted on Thu Feb 20 03:03:01 EST 2003 Report generated by SPECjAppServer2002 Reporter v1.01 Copyright (C) 2002 Standard Performance Evaluation Corporation