SPEC Seal of Reviewal SPECjAppServer2001 Result
Copyright © 2002 Standard Performance Evaluation Corporation
Oracle9iAS Release 2 on HP rp8400 Cluster
2,529.10 BOPS@MultipleNode
1,342.74 US$/BOPS@MultipleNode
Submitter:
Oracle Corporation		 SPEC license # 73 Test date:
Apr-2003		 EJB Container Avail: Jul-2003
EJB Container JVM Avail: Jan-2003
Software
EJB Container
Supplier Domain Container
Emulator Container
Database
JDBC
Other Software 		Hardware
J2EE Application Server
Database Server
Load Driver
Load Driver Master 		Benchmark
Modifications
Configuration
Other Info
General Notes 		Links
System Configuration Diagram

Full Disclosure Archive


Benchmark Settings
Orders Injection Rate: 1475 Ramp Up Time: 600 seconds
# of Order Agents: 8 Ramp Down Time: 300 seconds
# of Manufacturing Agents: 8 Steady State Time: 1800 seconds
DB Load Injection Rate: 1475 Trigger Time: 900 seconds
Total System Cost: US$3,395,920

Detailed Results
Order Transaction Mix Count Tx. Mix
New Order 1,312,964 49.98%
Change Order 526,267 20.03%
Order Status 525,451 20.00%
Customer Status 262,514 9.99%
Total # Order Transactions 2,627,196
Total # Manufacturing Transactions 1,925,189
Response Times Average Maximum 90th% Reqd
New Order 0.62 14.30 2.00 2.00
Change Order 0.37 7.94 1.10 2.00
Order Status 0.21 6.42 0.60 2.00
Customer Status 0.25 6.42 0.70 2.00
Manufacturing 1.99 23.62 3.75 5.00
Reproducibility Run (BOPS) 2,533.88

EJB Container
Name: Oracle9iAS Release 2, Standard Edition v9.0.2.3 JVM Name: Java (tm) 2 Runtime Environment, Standard Edition, version 1.4.1.01
Vendor: Oracle Corporation JVM Vendor: HP
Available: Jul-2003 Available: Jan-2003
Instances: 12
Passed CTS: May-2001
Protocol: ORMI
Tuning Information 
server.xml global-thread-pool min="40" max="40" queue="300" keepAlive="-1" debug="false
server.xml taskmanager-granularity="6000000" transaction-config timeout="500000
data-sources.xml stmt-cache-size="100" inactivity-timeout="9000" min-connections="40" max-connections="500
JVM Tuning Information 
System properties:
-Doracle.dms.gate=false
JVM command line:
-server -Xms3000m -Xmx3000m -Xmn768m
-Xoptgc -XX:PermSize=32m
-XX:SurvivorRatio=12 -XX:-UseHighResolutionTimer
-XX:PrefetchCopyIntervalInBytes=320 -XX:-StackTraceInThrowable
-XX:+ForceMmapReserved -XX:SchedulerPriorityRange=SCHED_RTPRIO

JVM virtual memory page size set to 64MB using the HP-UX chatr command

Supplier Domain Container
Name: Oracle9iAS Release 2, Standard Edition v9.0.2.3 JVM Name: Java (tm) 2 Runtime Environment, Standard Edition, version 1.4.1.01
Vendor: Oracle Corporation JVM Vendor: HP
Available: Jun-2003 Available: Jan-2003
Tuning Information 
server.xml global-thread-pool min="50" max="50" queue="200" keepAlive="-1" debug="false
server.xml taskmanager-granularity="3000000" transaction-config timeout="500000
data-sources.xml stmt-cache-size="100" inactivity-timeout="9000" min-connections="40" max-connections="500
JVM Tuning Information 
System properties:
-Doracle.dms.gate=false
JVM command line:
-server -Xms1024m -Xmx1024m -Xmn512m -Xoptgc
-XX:PermSize=32m -XX:SurvivorRatio=12
-XX:-UseHighResolutionTimer -XX:PrefetchCopyIntervalInBytes=320
-XX:+ForceMmapReserved -XX:-StackTraceInThrowable
-XX:SchedulerPriorityRange=SCHED_RTPRIO

JVM virtual memory page size set to 64MB using the HP-UX chatr command

Emulator Container
Name: Oracle9iAS Release 2, Standard Edition v9.0.2.3 JVM Name: Java (tm) 2 Runtime Environment, Standard Edition, version 1.4.1.01
Vendor: Oracle Corporation JVM Vendor: HP
Available: Jul-2003 Available: Jan-2003
Tuning Information 
server.xml taskmanager-granularity="3000000" transaction-config timeout="500000
JVM Tuning Information 
System Properties:
-Doracle.dms.gate=false
JVM command line:
-Xoptgc -XX:+ForceMmapReserved -Xms512m -Xmx512m

JVM virtual memory page size set to 64MB using the HP-UX chatr command

Database
Name: Oracle9i Database Release 2, Enterprise Edition v9.2.0.1.0
Vendor: Oracle Corporation
Available: May-2002
Tuning Information 
init.ora parameters for Oracle:
compatible=9.0.0.0.0
cursor_space_for_time = TRUE
db_cache_size = 2147483648
db_file_multiblock_read_count = 256
db_files = 256
dml_locks = 2000
enqueue_resources = 2000
log_buffer = 33554432
log_checkpoint_interval = 999999999
processes = 2000
open_cursors = 2000
max_rollback_segments = 1000
shared_pool_size = 536870912
transactions = 2000
transactions_per_rollback_segment = 1
parallel_max_servers = 100
undo_management               = AUTO
undo_retention                = 10
undo_suppress_errors          = TRUE
undo_tablespace               = roll_space
statistics_level = BASIC
trace_enabled = FALSE

JDBC
Name: Oracle JDBC Driver v9.0.2.1.0 (Type 2)
Vendor: Oracle Corporation
Available: Sep-2002
Tuning Information 
stmt-cache-size="100

Other Software
Name:
Vendor:
Available:
Tuning Information

J2EE Application Server (3 systems)
Hardware Vendor: HP OS Vendor: HP
Model Name: rp8400 OS Name: HP-UX 11i
Processor: PA-8700 Filesystem: JFS
MHz: 875 Disks: 4x73Gb 15K RPM Ultra SCSI
# of CPUs: 16 cores, 16 chips, 1 core/chip Network Interface: 4x1000BaseT Ethernet
Memory (MB): 65536 Other Hardware:
L1 Cache: 750KB(I)+1.5MB(D) # of Systems: 3
L2 Cache: H/W Available: Sep-2001
Other Cache: OS Available: Dec-2000
Notes / Tuning Information 
Parameters added to /stand/system
STRMSGSZ        65535
dbc_max_pct     10
dnlc_hash_locks 512
max_async_ports 1024
max_thread_proc 8192
maxdsiz         0X40000000
maxdsiz_64bit   0X40000000
maxfiles        8192
maxfiles_lim    8192
maxssiz         0X800000
maxssiz_64bit   0X800000
maxswapchunks   4096
maxtsiz         0X4000000
maxtsiz_64bit   0X40000000
maxuprc         8180
maxusers        4096
nkthread        8192
nproc           8192
nstrpty         60
semmni          2048
semmns          2048
semmnu          1024
shmmax          0X10000000
Parameters changed in /etc/rc.config.d/nddconf
TRANSPORT_NAME[0]=tcp
NDD_NAME[0]=tcp_conn_request_max
NDD_VALUE[0]=32768

Database Server (1 system)
Hardware Vendor: HP OS Vendor: HP
Model Name: Superdome OS Name: HP-UX 11i
Processor: PA-8700 Filesystem: JFS
MHz: 875 Disks: 3 VA7410 Disk Arrays (15*36GB drives)
# of CPUs: 24 cores, 24 chips, 1 core/chip Network Interface: 6 1000Base-T Ethernet LANs
Memory (MB): 49152 Other Hardware: (3) V7410 Disk Arrays 15x36Gb hard disk drivers each
L1 Cache: 750KB(I)+1.5MB(D) # of Systems: 1
L2 Cache: H/W Available: Sep-2000
Other Cache: OS Available: Dec-2000
Notes / Tuning Information 
=Parameters added to /stand/system
STRMSGSZ        65535
dbc_max_pct     5
dnlc_hash_locks 512
eqmemsize       128
max_async_ports 1024
max_thread_proc 3000
maxdsiz         2063835136
maxdsiz_64bit   0X40000000
maxfiles        2048
maxfiles_lim    2048
maxssiz         0X800000
maxssiz_64bit   0X800000
maxswapchunks   8192
maxtsiz         0X4000000
maxtsiz_64bit   0X40000000
maxuprc         2048
maxusers        512
msgmnb          65535
msgmni          4096
msgseg          32767
msgssz          128
msgtql          4096
ncallout        16384
ncsize          40000
nfile           20480
nkthread        16384
nproc           (4096*4)
nstrpty         60
semmni          8192
semmns          8192
semmnu          4096
shmmax          0XEE6B2800
shmmni          1024
swchunk         4096
Parameters changed in /etc/rc.config.d/nddconf
TRANSPORT_NAME[0]=tcp
NDD_NAME[0]=tcp_conn_request_max
NDD_VALUE[0]=32768

Load Driver (1 system)
Hardware Vendor: HP OS Vendor: HP
Model Name: rp8400 OS Name: HP-UX 11i
Processor: PA-8700 Filesystem: JFS
MHz: 875 Disks: 4*73GB Ultra SCSI
# of CPUs: 16 cores, 16 chips, 1 core/chip Network Interface: (1) 1000Base-T Ethernet LAN
Memory (MB): 65536 Other Hardware:
L1 Cache: 750KB(I)+1.5MB(D) # of Systems: 1
L2 Cache: H/W Available: Sep-2001
Other Cache: OS Available: Dec-2000
Notes / Tuning Information 
JVM Version used:
=Java (tm) 2 Runtime Environment, Standard Edition, version 1.4.1.01
JVM arguments used:
-Xmx1792m -Xms1792m -Xmn896m -XX:PermSize=64m
-XX:PrefetchCopyIntervalInBytes=320
-XX:+ForceMmapReserved -XX:+DisableExplicitGC
-XX:-UseHighResolutionTimer -XX:SchedulerPriorityRange=SCHED_RTPRIO
-XX:-StackTraceInThrowable
Parameters added to /opt/java1.4/jre/lib/security/java.security
networkaddress.cache.ttl = 0

JVM virtual memory page size set to 64MB using the HP-UX chatr command

Load Driver Master (1 system)
Hardware Vendor: HP OS Vendor: HP
Model Name: rx5670 OS Name: HP-UX 11i
Processor: Intel Itanium 2 Filesystem: JFS
MHz: 1024 Disks: 3*36GB 15K RPM Ultra 60
# of CPUs: 4 cores, 4 chips, 1 core/chip Network Interface: 1 1000Base-T Ethernet LAN
Memory (MB): 16384 Other Hardware:
L1 Cache: 16KB(I)+16KB(D) # of Systems: 1
L2 Cache: 256KB H/W Available: Jul-2002
Other Cache: 3MB L3 OS Available: Jul-2002
Notes / Tuning Information 
JVM Version used:
=Java (tm) 2 Runtime Environment, Standard Edition, version 1.4.1.01
JVM arguments used:
-d64 -Xmx3000m -Xms3000m -Xmn400m -XX:PermSize=32m
-XX:PrefetchCopyIntervalInBytes=320
-XX:+ForceMmapReserved  -XX:+DisableExplicitGC
-XX:-UseHighResolutionTimer
-XX:SchedulerPriorityRange=SCHED_RTPRIO
-XX:-StackTraceInThrowable -XX:-NoHandoff
-XX:-UseBoundThreads
Parameters added to /opt/java1.4/jre/lib/security/java.security
networkaddress.cache.ttl = 2

JVM virtual memory page size set to 64MB using the HP-UX chatr command

Benchmark Modifications
Schema Modifications: 
  Scripts to create the DB are included in the FDA
  Tablespace sizes were increased to support the Injection rate
  The log sizes were increased to 48000M.
  The M_Workorder table and its index were partitioned to 53 partitions by hash.
  Some TABLESPACE sizes were modified for required Injection rate.
  Table parameters initrans were modified.
  System managed tablespaces with local extent management were used.
  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: 
  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 descriptor
  
  All other beans were deployed using
  locking-mode="pessimistic" in their deployment descriptor
  
  A pessimistic locking mode means that all selects (including during finders) are issued with a FOR UPDATE clause
Durability Requirement Info: 
  RAID1 disk mirroring was used to ensure durability
  for the database logs
Storage Requirement Info: 
  A 45 minute run at an injection rate of 1475 increased storage by 38.33GB
  Given a linear scaling extrapolating for an 8-Hour run we get 408.77GB
  The system is configured with 1620GB which is sufficient for an 8Hr run
Argument Passing Semantics: 
  Oracle 9iAS application server uses pass-by-value
  as required by the EJB specification

Other Benchmark Information 
  This submission used the xerces.jar from the SPECjAppServer2001 Kit.
  The xerces.jar file was copied to the lib directory of the appserver
  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
  DNS round-robin was implemented by using the HP-UX supplied BIND domain-name server
  The driver used the following jndi.properties
  java.naming.factory.initial=com.evermind.server.rmi.RMIInitialContextFactory
  java.naming.provider.url=ormi://main.sjas.perf:24000/SPECjAppServer
  java.naming.security.principal=admin
  java.naming.security.credentials=welcome
  dedicated.rmicontext=true

General Notes 
No errors were reported during the final or reproducibility run

For questions about this result, please contact the submitter: Oracle Corporation
For other inquiries, please contact webmaster@spec.org

Benchmark run on Mon Apr 21 09:26:10 PDT 2003 by SPECjAppServer2001 v1.12
Result submitted on Wed Apr 30 03:03:01 EDT 2003
Report generated by SPECjAppServer2001 Reporter v1.09

Copyright © 2002 Standard Performance Evaluation Corporation

First published at SPEC.org on 14-May-2003