SPEC Seal of Reviewal SPECjAppServer2002 Result
Copyright © 2002 Standard Performance Evaluation Corporation
Oracle Application Server 10g Standard Edition v9.0.4.0.1 Pre-Release on Sun V65X
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
Software
EJB Container
Supplier Domain Container
Emulator Container
Database
JDBC
Other Software 		Hardware
J2EE Application Server
Database Server
Load Driver (Satellite)
Load Driver (Master) 		Benchmark
Modifications
Configuration
Other Info
General Notes 		Links
System Configuration Diagram

Full Disclosure Archive


Benchmark Settings
Orders Injection Rate: 1400 Ramp Up Time: 600 seconds
# of Order Agents: 3 Ramp Down Time: 300 seconds
# of Manufacturing Agents: 4 Steady State Time: 1800 seconds
DB Load Injection Rate: 1400 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

EJB Container
Name: Oracle Application Server 10g Standard Edition (9.0.4.0.1) Pre-Release JVM Name: Java(TM) 2 Runtime Environment, Standard EditionVersion 1.4.2_01
Vendor: Oracle Corporation JVM Vendor: Sun Microsystems, Inc.
Available: Nov-2003 Available: Jul-2003
Instances: 7
Passed CTS: Nov-2003
Protocol: ORMI
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 JVM Name: Java(TM) 2 Runtime Environment, Standard EditionVersion 1.4.2_01
Vendor: Oracle Corporation JVM Vendor: Sun Microsystems, Inc.
Available: Nov-2003 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 JVM Name: Java(TM) 2 Runtime Environment, Standard EditionVersion 1.4.2_01
Vendor: Oracle Corporation JVM Vendor: Sun Microsystems, Inc.
Available: Nov-2003 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

J2EE Application Server (7 systems)
Hardware Vendor: Sun Microsystems, Inc. OS Vendor: Red Hat, Inc.
Model Name: Sun Fire V65x OS Name: Red Hat Linux Advanced Server release 2.1AS/i686 (Pensacola)
Processor: Intel Xeon Filesystem: Linux ext2
MHz: 3060 Disks: 1x32Gb 10K RPM Ultra320 SCSI
# of CPUs: 2 cores, 2 chips, 1 core/chip Network Interface: (2) 10/100/1000BaseT Ethernet
Memory (MB): 2048 Other Hardware:
L1 Cache: 12Kuops(I)+8KB(D) # of Systems: 7
L2 Cache: 512KB H/W Available: May-2003
Other Cache: OS Available: Sep-2003
Notes / Tuning Information 
Parameters in /etc/sysctl.conf:

fs.file-max=65536

Database Server (1 system)
Hardware Vendor: Sun Microsystems, Inc. OS Vendor: Sun Microsystems, Inc.
Model Name: Sun Fire 6800 OS Name: Solaris 9 4/03
Processor: UltraSPARC III Cu Filesystem: UFS
MHz: 1200 Disks: 2x72Gb 10K RPM SCSI
# of CPUs: 24 cores, 24 chips, 1 core/chip Network Interface: 1 Dual Fast Ethernet + 2 Quad fast ethernet 1000BaseT Ethernet
Memory (MB): 98304 Other Hardware:
L1 Cache: 32KB(I)+64KB(D) # of Systems: 1
L2 Cache: 8MB(I+D) off chip H/W Available: Jul-2003
Other Cache: OS 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. OS Vendor: Sun Microsystems, Inc.
Model Name: Sun Fire V1280 OS Name: Solaris 9 8/03 Operating Environment
Processor: UltraSPARC III Cu Filesystem: UFS
MHz: 900 Disks: 2x36Gb SCSI
# of CPUs: 12 cores, 12 chips, 1 core/chip Network Interface: 3 1000BaseT Ethernet
Memory (MB): 24576 Other Hardware:
L1 Cache: 32KB(I)+64KB(D) # of Systems: 1
L2 Cache: 8MB(I+D) off chip H/W Available: Mar-2003
Other Cache: OS 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. OS Vendor: Sun Microsystems, Inc.
Model Name: Sun Fire V240 OS Name: Solaris 9 4/03 Operating Environment
Processor: UltraSPARC IIIi Cu Filesystem: UFS
MHz: 1064 Disks: 2x36Gb SCSI
# of CPUs: 2 cores, 2 chips, 1 core/chip Network Interface: 4 10/100/1000-Mbps Ethernet ports
Memory (MB): 6144 Other Hardware:
L1 Cache: 32KB(I)+64KB(D) # of Systems: 1
L2 Cache: 1MB(I+D) off chip H/W Available: Mar-2003
Other Cache: OS 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 webmaster@spec.org

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

First published at SPEC.org on 03-Nov-2003