SPEC Seal of Reviewal SPECjAppServer2002 Result
Copyright © 2002 Standard Performance Evaluation Corporation
Oracle Application Server 10g Java Edition v9.0.4.0.1p1 on Fujitsu-Siemens PRIMEPOWER 450
5,221.63 TOPS@MultipleNode
750.69
EUR/TOPS@MultipleNode
Submitter:
Oracle Corporation
SPEC license # 73 Test date:
Jul- 2004
EJB Container Avail: Nov-2004
EJB Container JVM Avail: Aug-2004
Software
EJB Container
Supplier Domain Container
Emulator Container
Database
JDBC
Other Software
Hardware
J2EE Application Server
Database Server
Load Driver (Master)
Load Driver (Satellite)
Emulator
Benchmark
Modifications
Configuration
Other Info
General Notes
Links
System Configuration Diagram

Full Disclosure Archive


Benchmark Settings
Orders Injection Rate: 3020 Ramp Up Time: 600 seconds
# of Order Agents: 4 Ramp Down Time: 300 seconds
# of Manufacturing Agents: 4 Steady State Time: 1800 seconds
DB Load Injection Rate: 3020 Trigger Time: 900 seconds
Total System Cost: EUR3,919,784

Detailed Results
Order Transaction Mix Count Tx. Mix
New Order 2,716,837 49.98%
Change Order 1,087,634 20.01%
Order Status 1,088,648 20.03%
Customer Status 543,085 9.99%
Total # Order Transactions 5,436,204
Total # Manufacturing Transactions 3,962,736
Response Times Average Maximum 90th% Reqd
New Order 0.49 12.33 1.20 2.00
Change Order 0.27 6.31 0.60 2.00
Order Status 0.13 1.73 0.30 2.00
Customer Status 0.14 1.73 0.40 2.00
Manufacturing 1.61 5.79 2.25 5.00
Reproducibility Run (TOPS) 5,225.24

EJB Container
Name: Oracle Application Server 10g Java Edition v9.0.4.0.1p1 JVM Name: Java(TM) 2 Runtime Environment, Java EditionVersion 1.4.2_04 (32 bit)
Vendor: Oracle Corporation JVM Vendor: Sun Microsystems, Inc.
Available: Nov-2004 Available: Aug-2004
Instances: 9
Passed CTS: Nov-2003
Protocol: ORMI
Tuning Information
server.xml:
global-thread-pool min="45" max="45" 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 JVM Name: Java(TM) 2 Runtime Environment, Java EditionVersion 1.4.2_04 (32 bit)
Vendor: Oracle Corporation JVM Vendor: Sun Microsystems, Inc.
Available: Nov-2004 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 JVM Name: Java(TM) 2 Runtime Environment, Java EditionVersion 1.4.2_04 (32 bit)
Vendor: Oracle Corporation JVM Vendor: Sun Microsystems, Inc.
Available: Nov-2004 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: Oracle9i Database Release 2 Enterprise Edition v9.2.0.4 (64 bit)
Vendor: Oracle Corporation
Available: Jan-2004
Tuning Information
init.ora parameters for Oracle:
db_name=specdb
control_files = /oracle9i/dbs/cntrlspecdb
compatible    = 9.2.0.2.0
transaction_auditing=FALSE
db_block_checksum=FALSE
cursor_space_for_time = TRUE
db_block_size=2048
db_file_multiblock_read_count = 256
db_files = 256
dml_locks = 20000
session_cached_cursors = 710
enqueue_resources = 60000
log_checkpoint_interval = 0
fast_start_mttr_target = 0
log_checkpoint_timeout = 0
log_archive_start = FALSE
processes = 700
open_cursors = 2000
shared_pool_size = 1000M
sessions = 710
transactions = 1210
transactions_per_rollback_segment = 1
parallel_max_servers = 100
sort_area_size = 52428800
log_checkpoints_to_alert          = TRUE
timed_statistics = false
statistics_level = basic
db_writer_processes = 4
log_parallelism = 2
log_buffer = 15728640
_lgwr_async_io=false
cpu_count = 48
db_cache_size=16000M
undo_management = manual
rollback_segments = rbs_0,rbs_1,rbs_2...rbs_299

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


J2EE Application Server (9 systems)
Hardware Vendor: Fujitsu Siemens Computers OS Vendor: Sun Microsystems, Inc.
Model Name: PRIMEPOWER 450 OS Name: Solaris 9 12/03 Operating Environment
Processor: SPARC64V Filesystem: UFS
MHz: 1320 Disks: 1x73Gb SCSI
# of CPUs: 4 cores, 4 chips, 1 core/chip Network Interface: (2) 1000BaseT Ethernet
Memory (MB): 8192 Other Hardware:
L1 Cache: 128KB(I)+128KB(D) # of Systems: 9
L2 Cache: 2MB H/W Available: Apr-2004
Other Cache: OS 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 OS Vendor: Sun Microsystems, Inc.
Model Name: PRIMEPOWER 2500 OS Name: Solaris 9 4/04 Operating Environment
Processor: SPARC64V Filesystem: UFS
MHz: 1300 Disks: 4x73Gb SCSI
# of CPUs: 56 cores, 56 chips, 1 core/chip Network Interface: (9) 1000BaseT Ethernet
Memory (MB): 114688 Other Hardware: (3) PCI FC RAID Controller, (2) FibreCAT S80 (12x73GB 10K RPM disks)
L1 Cache: 128KB(I)+128KB(D) # of Systems: 1
L2 Cache: 2MB H/W Available: Jan-2003
Other Cache: OS 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 OS Vendor: Sun Microsystems, Inc.
Model Name: PRIMEPOWER 650 OS Name: Solaris 9 12/03 Operating Environment
Processor: SPARC64V Filesystem: UFS
MHz: 1350 Disks: 2x73GB SCSI
# of CPUs: 8 cores, 8 chips, 1 core/chip Network Interface: 1000BaseT Ethernet
Memory (MB): 32768 Other Hardware:
L1 Cache: 128KB(I)+128KB(D) # of Systems: 1
L2 Cache: 2MB H/W Available: Oct-2003
Other Cache: OS 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 OS Vendor: Sun Microsystems, Inc.
Model Name: PRIMEPOWER 650 OS Name: Solaris 9 12/03 Operating Environment
Processor: SPARC64V Filesystem: UFS
MHz: 1350 Disks: 2x73GB SCSI
# of CPUs: 8 cores, 8 chips, 1 core/chip Network Interface: 1000BaseT Ethernet
Memory (MB): 32768 Other Hardware:
L1 Cache: 128KB(I)+128KB(D) # of Systems: 1
L2 Cache: 2MB H/W Available: Oct-2003
Other Cache: OS 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 OS Vendor: Red Hat, Inc.
Model Name: PRIMERGY RX600 OS Name: Red Hat Enterprise Linux AS Release 3
Processor: Intel XEON MP Filesystem: Linux Ext3
MHz: 3000 Disks: 2x73GB SCSI
# of CPUs: 4 cores, 4 chips, 1 core/chip Network Interface: 1000BaseT Ethernet
Memory (MB): 16384 Other Hardware:
L1 Cache: 12Kuops(I)+8KB(D) # of Systems: 1
L2 Cache: 512KB H/W Available: Oct-2003
Other Cache: 4MB OS 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.
  M_WORKORDER, O_ORDERS, O_ORDERLINE tables were horizontally partitioned.
  Field width of pol_balance was changed to (11, 2) from (9, 2).
  Manual rollback segments were 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 3020 required 76.5GB of storage.
  This extrapolates to 816GB 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 webmaster@spec.org

Benchmark run on Sat Jul 31 23:50:11 CEST 2004 by SPECjAppServer2002 v1.14
Result submitted on null
Report generated by SPECjAppServer2002 Reporter v1.01

Copyright © 2002 Standard Performance Evaluation Corporation

First published at SPEC.org on 03-Sep-2004