SPECjAppServer2002 Result Oracle Application Server 10g Java Edition v9.0.4.0.1p1 on Fujitsu-Siemens PRIMEPOWER 450 Metric: 5,991.73 TOPS@MultipleNode 654.20 EUR/TOPS@MultipleNode Submitter: Oracle Corporation, SPEC license # 73, Test date: Aug- 2004 EJB Container Avail: Nov-2004, EJB Container JVM Avail: Aug-2004 -------------------------------------------------------------------------------- Benchmark Settings -------------------------------------------------------------------------------- Orders Injection Rate: 3475 # of Order Agents: 4 # of Manufacturing Agents: 4 DB Load Injection Rate: 3475 Ramp Up Time: 600 seconds Ramp Down Time: 300 seconds Steady State Time: 1800 seconds Trigger Time: 1020 seconds Total System Cost: EUR3,919,784 -------------------------------------------------------------------------------- Detailed Results -------------------------------------------------------------------------------- Order Transaction Mix Count Tx. Mix New Order 3,112,529 50.00% Change Order 1,244,744 20.00% Order Status 1,244,698 20.00% Customer Status 622,485 10.00% Total # Order Transactions 6,224,456 Total # Manufacturing Transactions 4,560,664 Response Times Average Maximum 90th% Reqd New Order 0.67 5.64 1.70 2.00 Change Order 0.36 3.20 0.80 2.00 Order Status 0.17 1.30 0.40 2.00 Customer Status 0.18 1.28 0.40 2.00 Manufacturing 1.80 4.44 2.50 5.00 Reproducibility Run (TOPS) 6,009.43 -------------------------------------------------------------------------------- Software Descriptions -------------------------------------------------------------------------------- EJB Container Name: Oracle Application Server 10g Java Edition v9.0.4.0.1p1 Vendor: Oracle Corporation Available: Nov-2004 Instances: 9 Passed CTS: Nov-2003 Protocol: ORMI JVM Name: Java(TM) 2 Runtime Environment, Java EditionVersion 1.4.2_04 (32 bit) JVM Vendor: Sun Microsystems, Inc. JVM Available: Aug-2004 Tuning Information server.xml: global-thread-pool min="50" max="50" queue="20000 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 -DoneToOneJoin=true -Doracle.dms.sensors=none -Doracle.ias.cache=0 -DdefaultBatchSize=15 JVM Tuning Information -server -Xms2500m -Xmx2500m -XX:+UseMPSS -XX:+AggressiveHeap -XX:+DisableExplicitGC -verbose:gc -------------------------------------------------------------------------------- Supplier Domain Container Name: Oracle Application Server 10g Java Edition v9.0.4.0.1p1 Vendor: Oracle Corporation Available: Nov-2004 JVM Name: Java(TM) 2 Runtime Environment, Java EditionVersion 1.4.2_04 (32 bit) JVM Vendor: Sun Microsystems, Inc. JVM Available: Aug-2004 Tuning Information server.xml: global-thread-pool min="50" max="50" queue="20000 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 -DoneToOneJoin=true -Doracle.dms.sensors=none -Doracle.ias.cache=0 -DdefaultBatchSize=15 JVM Tuning Information -server -Xms300M -Xmx300M -XX:+AggressiveHeap -verbose:gc -XX:+UseMPSS -------------------------------------------------------------------------------- Emulator Container Name: Oracle Application Server 10g Java Edition v9.0.4.0.1p1 Vendor: Oracle Corporation Available: Nov-2004 JVM Name: Java(TM) 2 Runtime Environment, Java EditionVersion 1.4.2_04 (32 bit) JVM Vendor: Sun Microsystems, Inc. JVM Available: Aug-2004 Tuning Information server.xml: global-thread-pool min="40" max="40" queue="200" keepAlive="-1" debug="false data-sources.xml: inactivity-timeout="30 System Properties: -Doracle.dms.sensors=none -Doracle.ias.cache=0 JVM Tuning Information -server -Xms900M -Xmx900M -------------------------------------------------------------------------------- Database Name: Oracle Database 10g Enterprise Edition v10.1.0.2.0 (64 bit) Vendor: Oracle Corporation Available: Aug-2004 Tuning Information init.ora parameters for Oracle: compatible = 10.1.0.0.0 control_files = /oracle10g/dbs/cntrlspec10g cursor_space_for_time = TRUE db_block_checking=FALSE db_block_checksum=FALSE db_block_size=2048 db_file_multiblock_read_count = 256 db_files = 256 db_name=spec10g dml_locks = 20000 session_cached_cursors = 710 enqueue_resources = 60000 log_checkpoint_interval = 0 fast_start_mttr_target = 0 log_checkpoint_timeout = 0 processes = 700 open_cursors = 2000 shared_pool_size = 6000M sessions = 710 transactions = 1210 transactions_per_rollback_segment = 1 parallel_max_servers = 100 sort_area_size = 52428800 log_checkpoints_to_alert = TRUE _array_update_vector_read_enabled = TRUE _db_cache_pre_warm = false _enable_numa_optimization = false _imu_pools = 500 _smm_advice_enabled = FALSE _undo_autotune = FALSE _db_block_numa = 1 _two_pass = FALSE timed_statistics = false statistics_level = basic trace_enabled = FALSE db_writer_processes = 4 _lgwr_async_io=false cpu_count =48 db_cache_size = 24G db_8k_cache_size = 4G _db_block_hash_latches = 400000 query_rewrite_enabled = false aq_tm_processes = 0 _collect_undo_stats = false _db_writer_flush_imu = false pga_aggregate_target = 0 disk_asynch_io = TRUE undo_management = AUTO undo_retention = 3 undo_tablespace = undo_ts replication_dependency_tracking = FALSE db_cache_advice = OFF -------------------------------------------------------------------------------- JDBC Name: Oracle JDBC Driver version - 10.1.0.2.0 (Thin) Vendor: Oracle Corporation Available: Nov-2004 Tuning Information stmt-cache-size="100 -------------------------------------------------------------------------------- Other Software Name: Vendor: Available: Tuning Information -------------------------------------------------------------------------------- Hardware Descriptions -------------------------------------------------------------------------------- J2EE Application Server (9 systems) Hardware Vendor: Fujitsu Siemens Computers Model Name: PRIMEPOWER 450 Processor: SPARC64V MHz: 1320 # of CPUs: 4 cores, 4 chips, 1 core/chip Memory (MB): 8192 L1 Cache: 128KB(I)+128KB(D) L2 Cache: 2MB Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 9 12/03 Operating Environment Disks: 1x73Gb SCSI Network Interface: (2) 1000BaseT Ethernet Other Hardware: # of Systems: 9 H/W Available: Apr-2004 O/S Available: Feb-2004 Notes / Tuning Information Parameters in /etc/system: set tcp:tcp_conn_hash_size=32768 set rlim_fd_cur=8192 Parameters set from shell: export LD_PRELOAD=mpss.so.1 export MPSSHEAP=4M ulimit -n 8192 #increase fds -------------------------------------------------------------------------------- Database Server (1 system) Hardware Vendor: Fujitsu Siemens Computers Model Name: PRIMEPOWER 2500 Processor: SPARC64V MHz: 1300 # of CPUs: 56 cores, 56 chips, 1 core/chip Memory (MB): 114688 L1 Cache: 128KB(I)+128KB(D) L2 Cache: 2MB Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 9 4/04 Operating Environment Disks: 4x73Gb SCSI Network Interface: (9) 1000BaseT Ethernet Other Hardware: (3) PCI FC RAID Controller, (2) FibreCAT S80 (12x73GB 10K RPM disks) # of Systems: 1 H/W Available: Jan-2003 O/S Available: Jul-2004 Notes / Tuning Information Parameters in /etc/system: set shmsys:shminfo_shmmax=0xffffffffffffffff set semsys:seminfo_semmap=100 set semsys:seminfo_semmni=16000 set semsys:seminfo_semmns=16000 set semsys:seminfo_semmnu=16000 set semsys:seminfo_semmsl=512 set semsys:seminfo_semume=100 set msgsys:msginfo_msgmap=3002 set msgsys:msginfo_msgmax=1048576 set msgsys:msginfo_msgmnb=4194304 set msgsys:msginfo_msgmni=4400 set msgsys:msginfo_msgssz=128 set msgsys:msginfo_msgtql=32768 set msgsys:msginfo_msgseg=32767 set maxpgio=131072 set maxphys=4194304 set bufhwm=8000 set segspt_minfree=16000 set sd:sd_max_throttle=32 set tune_t_fsflushr=3000 set autoup=60000 set memscrub_period_sec=172900 set ge:ge_intr_mode=1 set ge:ge_nos_tmds = 8192 set ge:ge_tx_fastdvma_min = 95 set ge:ge_tx_bcopy_max = 96 set ge:ge_nos_txdvma = 8192 set ge:ge_pci_intr_blank_time=6 forceload: drv/FJSVpanel drv/se drv/fjmse Processor Set and Process binding description(psrset and psradm commands): Three processor sets were created: #1: 48 cpus, interrupts disabled: All Oracle processes except Logwriter. #2: 1 cpu, interrupts disabled: Log writer #3: 6 cpus, interrupts enabled. Scheduling and priority tuning (priocntl command): All Oracle backgrounds : Fixed priority 59, Time quantum 100ms. Listener and Oracle Foregrounds: Fixed priority 59, Time quantum 20ms. Log writer : Real Time -------------------------------------------------------------------------------- Load Driver (Master) (1 system) Hardware Vendor: Fujitsu Siemens Computers Model Name: PRIMEPOWER 650 Processor: SPARC64V MHz: 1350 # of CPUs: 8 cores, 8 chips, 1 core/chip Memory (MB): 32768 L1 Cache: 128KB(I)+128KB(D) L2 Cache: 2MB Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 9 12/03 Operating Environment Disks: 2x73GB SCSI Network Interface: 1000BaseT Ethernet Other Hardware: # of Systems: 1 H/W Available: Oct-2003 O/S Available: Feb-2004 Notes / Tuning Information Parameters in /etc/system: set tcp:tcp_conn_hash_size=32768 set rlim_fd_cur=8192 Shell Environment: ulimit -n 8192 #increase fds Java(TM) 2 Runtime Environment, Java Edition Version 1.4.2_04 (64 bit) Options: -server -d64 -Xms6000m -Xmx6000m -Xmn1200m -XX:+AggressiveHeap -XX:+PrintGCTimeStamps -Xss128k -verbose:gc -Dsun.rmi.dgc.client.gcInterval=4200000 -Dsun.rmi.dgc.server.gcInterval=4200000 -Dsun.net.inetaddr.ttl=0 -Dnetworkaddress.cache.ttl=0 -------------------------------------------------------------------------------- Load Driver (Satellite) (1 system) Hardware Vendor: Fujitsu Siemens Computers Model Name: PRIMEPOWER 650 Processor: SPARC64V MHz: 1350 # of CPUs: 8 cores, 8 chips, 1 core/chip Memory (MB): 32768 L1 Cache: 128KB(I)+128KB(D) L2 Cache: 2MB Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 9 12/03 Operating Environment Disks: 2x73GB SCSI Network Interface: 1000BaseT Ethernet Other Hardware: # of Systems: 1 H/W Available: Oct-2003 O/S Available: Feb-2004 Notes / Tuning Information Parameters in /etc/system: set tcp:tcp_conn_hash_size=32768 set rlim_fd_cur=8192 Shell Environment: ulimit -n 8192 #increase fds Java(TM) 2 Runtime Environment, Java Edition Version 1.4.2_04 (32 bit) Options: -server -Xms3000m -Xmx3000m -Xmn1200m -XX:+AggressiveHeap -XX:+PrintGCTimeStamps -Xss128k -verbose:gc -Dsun.rmi.dgc.client.gcInterval=4200000 -Dsun.rmi.dgc.server.gcInterval=4200000 -Dsun.net.inetaddr.ttl=0 -Dnetworkaddress.cache.ttl=0 -------------------------------------------------------------------------------- Emulator (1 system) Hardware Vendor: Fujitsu Siemens Computers Model Name: PRIMERGY RX600 Processor: Intel XEON MP MHz: 3000 # of CPUs: 4 cores, 4 chips, 1 core/chip Memory (MB): 16384 L1 Cache: 12Kuops(I)+8KB(D) L2 Cache: 512KB Other Cache: 4MB OS Vendor: Red Hat, Inc. OS Name: Red Hat Enterprise Linux AS Release 3 Disks: 2x73GB SCSI Network Interface: 1000BaseT Ethernet Other Hardware: # of Systems: 1 H/W Available: Oct-2003 O/S Available: Nov-2003 Notes / Tuning Information Parameters in /etc/sysctl.conf: fs.file-max = 65536 -------------------------------------------------------------------------------- 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, pctfree, pctused parameters were modified. Automatic segment space management was used for tablespaces. M_WORKORDER, O_ORDERS, O_ORDERLINE,M_INVENTORY, C_CUSTOMER tables were horizontally partitioned. Field width of pol_balance was changed to (11, 2) from (9, 2). System managed undo was used. Table locks were disabled during the run using tbllkd.sh. -------------------------------------------------------------------------------- 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 finders) are issued with a FOR UPDATE clause in the select statement -------------------------------------------------------------------------------- Durability Requirement Info: RAID 10 was used for Redo logs for durability. The database writes all changes to the redo log when each transaction is committed. Two battery backed FibreCat S80 storage arrays (12 X 73Gb) were used to store the data and logfiles. One for data and One for logfiles. Please see Notes section below. -------------------------------------------------------------------------------- Storage Requirement Info: A 45 minute run at an injection rate of 3475 required 61.34GB of storage. This extrapolates to 654.30GB of storage for an 8-hour run. The database system is configured with 1752GB 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://mtdns.bmc.all:23791/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. The SUT contained 73 GB disks for both redo logs and data; however, subsequent calculation indicated that 146 GB disks would have been required to hold the redo generated during an 8 hour run. To comply with this benchmark requirement, for pricing purposes 146 GB disks were substituted for 73 GB disks for redo logs only as per Clause 4.3 of the run rules; this substitution is performance neutral. -------------------------------------------------------------------------------- For questions about this result, please contact the submitter: Oracle Corporation For other inquiries, please contact SPEC Benchmark run on Tue Aug 17 23:30:50 CEST 2004 by SPECjAppServer2002 v1.14 Result submitted on null Report generated by SPECjAppServer2002 Reporter v1.01 Copyright (C) 2002 Standard Performance Evaluation Corporation