SPECjAppServer2002 Result Oracle Application Server 10g Standard Edition v9.0.4.0.1 Pre-Release on Sun V65X Metric: 2,408.73 TOPS@MultipleNode 700.08 US$/TOPS@MultipleNode Submitter: Oracle Corporation, SPEC license # 73, Test date: Oct-2003 EJB Container Avail: Nov-2003, EJB Container JVM Avail: Jul-2003 -------------------------------------------------------------------------------- Benchmark Settings -------------------------------------------------------------------------------- Orders Injection Rate: 1400 # of Order Agents: 3 # of Manufacturing Agents: 4 DB Load Injection Rate: 1400 Ramp Up Time: 600 seconds Ramp Down Time: 300 seconds Steady State Time: 1800 seconds Trigger Time: 600 seconds Total System Cost: US$1,686,284 -------------------------------------------------------------------------------- Detailed Results -------------------------------------------------------------------------------- Order Transaction Mix Count Tx. Mix New Order 1,250,445 50.00% Change Order 499,183 19.96% Order Status 500,722 20.02% Customer Status 250,618 10.02% Total # Order Transactions 2,500,968 Total # Manufacturing Transactions 1,834,749 Response Times Average Maximum 90th% Reqd New Order 0.47 19.17 1.20 2.00 Change Order 0.25 6.42 0.70 2.00 Order Status 0.13 6.24 0.40 2.00 Customer Status 0.14 7.39 0.40 2.00 Manufacturing 1.65 9.65 2.75 5.00 Reproducibility Run (TOPS) 2,411.32 -------------------------------------------------------------------------------- Software Descriptions -------------------------------------------------------------------------------- EJB Container Name: Oracle Application Server 10g Standard Edition (9.0.4.0.1) Pre-Release Vendor: Oracle Corporation Available: Nov-2003 Instances: 7 Passed CTS: Nov-2003 Protocol: ORMI JVM Name: Java(TM) 2 Runtime Environment, Standard EditionVersion 1.4.2_01 JVM Vendor: Sun Microsystems, Inc. JVM Available: Jul-2003 Tuning Information -server.xml global-thread-pool min="30" max="30" queue="100 keepAlive="-1" debug="false" taskmanager-granularity="9000000 transaction-config timeout="500000 data-sources.xml inactivity-timeout="90000" stmt-cache-size="100 System properties: -DassociateUsingThirdTable=false -DKeepWrapperCode=true -Doracle.dms.sensors=none -Doracle.ias.cache=0 -DdefaultBatchSize=15 JVM Tuning Information -server -XX:+UseSpinning -XX:PreBlockSpin=200 -DassociateUsingThirdTable=false -Doracle.dms.sensors=none -Doracle.ias.cache=0 -DdefaultBatchSize=15 -Dsun.net.inetaddr.ttl=0 -Xms1400m -Xmx1400m -Xmn750m -XX:+UseParallelGC -XX:+UseTLAB -XX:-UseAdaptiveSizePolicy -XX:SurvivorRatio=2 -XX:+DisableExplicitGC -XX:+PrintGCDetails -verbose:gc -XX:+PrintGCTimeStamps -------------------------------------------------------------------------------- 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: Java(TM) 2 Runtime Environment, Standard EditionVersion 1.4.2_01 JVM Vendor: Sun Microsystems, Inc. JVM Available: Jul-2003 Tuning Information -server.xml global-thread-pool min="30" max="30" queue="100 keepAlive="-1" debug="false" taskmanager-granularity="9000000 transaction-config timeout="500000 data-sources.xml inactivity-timeout="90000" stmt-cache-size="100 System properties: -DassociateUsingThirdTable=false -DKeepWrapperCode=true -Doracle.dms.sensors=none -Doracle.ias.cache=0 -DdefaultBatchSize=15 JVM Tuning Information -server -Xms300M -Xmx300M -XX:+AggressiveHeap -XX:+UseSpinning -XX:PreBlockSpin=100 -verbose:gc -------------------------------------------------------------------------------- Emulator Container Name: Oracle Application Server 10g Standard Edition v9.0.4.0.1 Pre-Release Vendor: Oracle Corporation Available: Nov-2003 JVM Name: Java(TM) 2 Runtime Environment, Standard EditionVersion 1.4.2_01 JVM Vendor: Sun Microsystems, Inc. JVM Available: Jul-2003 Tuning Information server.xml global-thread-pool min="20" max="20" queue="50" keepAlive="-1" debug="false data-sources.xml inactivity-timeout="30 JVM Tuning Information -Xms256M -Xmx256M -------------------------------------------------------------------------------- Database Name: Oracle9i Database Release 2 Enterprise Edition v9.2.0.2 Vendor: Oracle Corporation Available: Jul-2003 Tuning Information init.ora parameters for Oracle: compatible = 9.0.0.0.0 db_name=specdb control_files = /export/u1/v9202_32bit/dbs/cntrlspecdb.dbf timed_statistics=false transaction_auditing=FALSE db_block_checksum=FALSE cursor_space_for_time = TRUE db_block_size=2048 db_cache_size = 2800M db_file_multiblock_read_count = 128 db_files = 256 dml_locks = 20000 session_cached_cursors = 710 enqueue_resources = 60000 log_buffer = 335544320 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 = 100 transactions = 710 transactions_per_rollback_segment = 1 parallel_max_servers = 100 sort_area_size = 52428800 log_checkpoints_to_alert = TRUE undo_management = AUTO undo_retention = 10 undo_suppress_errors = TRUE undo_tablespace = roll_space -------------------------------------------------------------------------------- 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 (7 systems) Hardware Vendor: Sun Microsystems, Inc. Model Name: Sun Fire V65x Processor: Intel Xeon MHz: 3060 # of CPUs: 2 cores, 2 chips, 1 core/chip Memory (MB): 2048 L1 Cache: 12Kuops(I)+8KB(D) L2 Cache: 512KB Other Cache: OS Vendor: Red Hat, Inc. OS Name: Red Hat Linux Advanced Server release 2.1AS/i686 (Pensacola) Disks: 1x32Gb 10K RPM Ultra320 SCSI Network Interface: (2) 10/100/1000BaseT Ethernet Other Hardware: # of Systems: 7 H/W Available: May-2003 O/S Available: Sep-2003 Notes / Tuning Information Parameters in /etc/sysctl.conf: fs.file-max=65536 -------------------------------------------------------------------------------- Database Server (1 system) Hardware Vendor: Sun Microsystems, Inc. Model Name: Sun Fire 6800 Processor: UltraSPARC III Cu MHz: 1200 # of CPUs: 24 cores, 24 chips, 1 core/chip Memory (MB): 98304 L1 Cache: 32KB(I)+64KB(D) L2 Cache: 8MB(I+D) off chip Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 9 4/03 Disks: 2x72Gb 10K RPM SCSI Network Interface: 1 Dual Fast Ethernet + 2 Quad fast ethernet 1000BaseT Ethernet Other Hardware: # of Systems: 1 H/W Available: Jul-2003 O/S Available: Apr-2003 Notes / Tuning Information Parameters in /etc/system: set shmsys:shminfo_shmmax=0xffffffffffffffff set shmsys:shminfo_shmseg=200 set msgsys:msginfo_msgmax=1048576 set msgsys:msginfo_msgmnb=4194304 set msgsys:msginfo_msgmni=4400 set msgsys:msginfo_msgtql=32768 set msgsys:msginfo_msgseg=32767 set msgsys:msginfo_msgssz=128 set msgsys:msginfo_msgmap=3002 set semsys:seminfo_semmap=100 set semsys:seminfo_semmni=8000 set semsys:seminfo_semmns=8000 set semsys:seminfo_semmnu=8000 set semsys:seminfo_semmsl=512 set semsys:seminfo_semume=100 set maxpgio=131072 set maxphys=4194304 set autoup=900 set bufhwm=8000 set segspt_minfree=16000 -------------------------------------------------------------------------------- Load Driver (Satellite) (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: 32KB(I)+64KB(D) L2 Cache: 8MB(I+D) off chip Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 9 8/03 Operating Environment Disks: 2x36Gb SCSI Network Interface: 3 1000BaseT Ethernet Other Hardware: # of Systems: 1 H/W Available: Mar-2003 O/S Available: Aug-2003 Notes / Tuning Information Parameters in /etc/system: set pt_cnt=1024 set rlim_fd_max=8192 set rlim_fd_cur=8192 set tcp:tcp_conn_hash_size=32768 set ce:ce_bcopy_thresh=256 set ce:ce_dvma_thresh=256 set ce:ce_taskq_disable=1 set ce:ce_ring_size=256 set ce:ce_comp_ring_size=1024 set ce:ce_tx_ring_size=4096 -------------------------------------------------------------------------------- Load Driver (Master) (1 system) Hardware Vendor: Sun Microsystems, Inc. Model Name: Sun Fire V240 Processor: UltraSPARC IIIi Cu MHz: 1064 # of CPUs: 2 cores, 2 chips, 1 core/chip Memory (MB): 6144 L1 Cache: 32KB(I)+64KB(D) L2 Cache: 1MB(I+D) off chip Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 9 4/03 Operating Environment Disks: 2x36Gb SCSI Network Interface: 4 10/100/1000-Mbps Ethernet ports Other Hardware: # of Systems: 1 H/W Available: Mar-2003 O/S Available: Apr-2003 Notes / Tuning Information Parameters in /etc/system: set pt_cnt=1024 set rlim_fd_max=8192 set rlim_fd_cur=8192 set tcp:tcp_conn_hash_size=32768 set ce:ce_bcopy_thresh=256 set ce:ce_dvma_thresh=256 set ce:ce_taskq_disable=1 set ce:ce_ring_size=256 set ce:ce_comp_ring_size=1024 set ce:ce_tx_ring_size=4096 -------------------------------------------------------------------------------- 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. M_WORKORDER table was horizontally partitioned. -------------------------------------------------------------------------------- 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 1400 required 36.14GB of storage. This extrapolates to 385.50GB of storage for an 8-hour run. The database system is configured with 876 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. 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://wapps-dns:23777/SPECjAppServer java.naming.security.principal=admin java.naming.security.credentials=welcome dedicated.rmicontext=true -------------------------------------------------------------------------------- General Notes -------------------------------------------------------------------------------- No errors were reported during the final nor reproducability run. -------------------------------------------------------------------------------- For questions about this result, please contact the submitter: Oracle Corporation For other inquiries, please contact SPEC Benchmark run on Tue Oct 14 12:30:53 PDT 2003 by SPECjAppServer2002 v1.14 Result submitted on Wed Oct 15 03:03:01 EDT 2003 Report generated by SPECjAppServer2002 Reporter v1.01 Copyright (C) 2002 Standard Performance Evaluation Corporation