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,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
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: 3475 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: 3475 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

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="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 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: 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


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. 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 webmaster@spec.org

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 © 2002 Standard Performance Evaluation Corporation

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