SPEC Seal of Reviewal SPECjAppServer®2004 Result
Copyright © 2004 Standard Performance Evaluation Corporation
Oracle Application Server 10G Release 10.1.3.3 - Java Edition on Dell PowerEdge 1950 III
3,593.68 SPECjAppServer2004 JOPS@Standard
Submitter:
Oracle Corporation		 SPEC license # 73 Test date:
Oct-2007
Software Products
Oracle Application Server 10G Release 10.1.3.3 - Java Edition
BEA JRockit(R) 6.0 JDK (R27.3.0-106) (Linux x86 32bit)
Java (TM) 2 Platform Standard Edition Development Kit 6.0 Update 2 64-bit
Oracle JDBC Driver 10.2.0.2 (Thin)
Oracle Database Enterprise Edition Release 10.2.0.2 with Patch 3628715 		Software Configurations
J2EE Application Server
Emulator SW Config
Database SW Config
Driver SW Config Primary
Driver SW Config Satellite 		Hardware Systems
J2EE Server HW
Database Server HW
Primary Driver HW
Satellite Driver #1 and Emulator HW
Satellite Driver #2 HW

System Configuration Diagram

Benchmark
Modifications
Configuration
Bill of Materials
Other Info
General Notes
Full Disclosure Archive

SUT Configuration
J2EE Server Nodes: 2   DB Server Nodes: 1
J2EE Server CPUs: 16 cores, 4 chips   DB Server CPUs: 16 cores, 4 chips
J2EE Instances: 8   DB Instances: 1
Other SUT Components:
   Dell PowerConnect 24-port 1GbE Switch

Benchmark Settings
Dealer Injection Rate: 2,150   Ramp Up Time: 900 seconds
# of Dealer Agents: 12   Ramp Down Time: 300 seconds
# of Manufacturing Agents: 7   Steady State Time: 3,600 seconds
DB Load Injection Rate: 3,000   Trigger Time: 680 seconds

Detailed Results
Dealer Transaction Mix Count Tx. Mix
Purchase 1,941,330 24.98%
Manage 1,943,438 25.01%
Browse 3,886,965 50.01%
Total # Dealer Transactions 7,771,733
Total # Manufacturing Transactions 5,165,529
Response Times Average Maximum 90th% Reqd
Purchase 0.38 26.33 1.10 2.00
Manage 0.31 23.91 0.80 2.00
Browse 0.45 27.52 1.30 2.00
Manufacturing 1.77 19.76 2.75 5.00
Reproducibility Run (SPECjAppServer2004 JOPS) 3,598.83

Oracle Application Server 10G Release 10.1.3.3 - Java Edition
Vendor: Oracle Corporation Availability: Nov-2007
CTS Version: 1.4 Date Passed CTS: Jan-2006
OS Name: Red Hat Enterprise Linux 5 IA32 PAE
EJB Protocol: ORMI

BEA JRockit(R) 6.0 JDK (R27.3.0-106) (Linux x86 32bit)
Vendor: BEA Systems, Inc. Availability: Jul-2007
OS Name: Red Hat Enterprise Linux 5 IA32 PAE

Java (TM) 2 Platform Standard Edition Development Kit 6.0 Update 2 64-bit
Vendor: Sun Microsystems, Inc Availability: Jul-2007
OS Name: Red Hat Enterprise Linux 4 Update 4 EM64T

Oracle JDBC Driver 10.2.0.2 (Thin)
Vendor: Oracle Corporation Availability: Feb-2006
OS Name: Red Hat Enterprise Linux 5 IA32 PAE

Oracle Database Enterprise Edition Release 10.2.0.2 with Patch 3628715
Vendor: Oracle Corporation Availability: Feb-2006
OS Name: Red Hat Enterprise Linux 5 EM64T

J2EE Application Server
J2EE Product: Oracle Application Server 10G Release 10.1.3.3 - Java Edition
JVM Product: BEA JRockit(R) 6.0 JDK (R27.3.0-106) (Linux x86 32bit)
JDBC Product: Oracle JDBC Driver 10.2.0.2 (Thin)
Hardware: J2EE Server HW
# of Instances: 4
Interfaces:
Web Interface for the Dealer Domain
Web Interface for the Supplier Domain
EJB Interface for the Dealer Domain
EJB Interface for the Manufacturing Domain
EJB Interface for the Supplier Domain
Notes / Tuning Information 
-showversion -Xms2670m -Xmx2670m -XXaggressive -XXinternalCompactRatio=1
-XXexternalCompactRatio=10 -XXheapParts=128 -XXgcthreads=4
-XXoptthreads=2 -Xverbose:memdbg,opt,gcpause,gcreport
-Doracle.dms.sensors=none -Doc4j.jms.implementation=oc4j.j2ee.jms
-Dsun.net.inetaddr.ttl=0 -Dnetworkaddress.cache.ttl=0

Emulator SW Config
JVM Product: Java (TM) 2 Platform Standard Edition Development Kit 6.0 Update 2 64-bit
Web Product: Oracle Application Server 10G Release 10.1.3.3 - Java Edition
Hardware: Primary Driver HW
# of Instances: 1
Notes / Tuning Information 
-server -XX:+UseLargePages -XX:+AggressiveOpts -XX:+DisableExplicitGC
-Xms6000M -Xmx6000M -verbosegc -Xloggc:emugc.log -XX:+PrintGCDetails
-XX:+PrintGCTimeStamps -XX:+PrintCommandLineFlags
-Dnetworkaddress.cache.ttl=0 -Dsun.net.inetaddr.ttl=0

Database SW Config
DB Product: Oracle Database Enterprise Edition Release 10.2.0.2 with Patch 3628715
Hardware: Database Server HW
# of Instances: 1
Notes / Tuning Information 
db_name                 = spec04
control_files           = ?/dbs/cntrlspec04
compatible              = 10.2.0.1.0
cursor_space_for_time   = TRUE
db_cache_size           = 25000M
db_8k_cache_size        = 8000M
db_4k_cache_size        = 4000M
db_keep_cache_size      = 3000M
db_file_multiblock_read_count = 128
db_block_size           = 2048
db_files                = 256
dml_locks               = 1000
log_buffer              = 67108864
log_checkpoint_interval = 0
processes               = 1500
open_cursors            = 2000
shared_pool_size        = 1180M
sessions                = 2000
transactions            = 2000
transactions_per_rollback_segment = 1
parallel_max_servers    = 100
undo_management         = AUTO
undo_retention          = 300
undo_tablespace         = undo_ts
db_writer_processes     = 8
log_checkpoints_to_alert= TRUE
db_block_checksum       = FALSE
trace_enabled           = FALSE
timed_statistics        = FALSE
statistics_level        = BASIC
filesystemio_options    = DirectIO
_undo_autotune          = false
_imu_pools              = 1000
_collect_undo_stats     = false
_db_writer_flush_imu    = false
_array_update_vector_read_enabled = true
pga_aggregate_target    = 0
query_rewrite_enabled   = false
replication_dependency_tracking = false
session_cached_cursors  = 1000

Driver SW Config Primary
JVM Product: Java (TM) 2 Platform Standard Edition Development Kit 6.0 Update 2 64-bit
Hardware: Primary Driver HW
# of Instances: 1
Notes / Tuning Information 
-server -Xms2000M -Xmx2000M -Xverify:none -Xloggc:gc.log
-XX:+PrintGCDetails -XX:+PrintGCTimeStamps -XX:+DisableExplicitGC
-XX:+UseParallelGC -Dnetworkaddress.cache.ttl=0 -Dsun.net.inetaddr.ttl=0

Driver SW Config Satellite
JVM Product: Java (TM) 2 Platform Standard Edition Development Kit 6.0 Update 2 64-bit
Hardware: Primary Driver HW
# of Instances: 1
Notes / Tuning Information 
-server -Xms2000M -Xmx2000M -Xverify:none -Xloggc:gc.log
-XX:+PrintGCDetails -XX:+PrintGCTimeStamps -XX:+DisableExplicitGC
-XX:+UseParallelGC -Dnetworkaddress.cache.ttl=0 -Dsun.net.inetaddr.ttl=0

J2EE Server HW (SUT hardware)
Hardware Vendor: Dell OS Vendor: Red Hat
Model Name: PowerEdge 1950 III OS Name: Red Hat Enterprise Linux 5 IA32 PAE
Processor: Intel(R) Xeon(R) CPU E5440 Filesystem: ext3
MHz: 2833 Disks: 2x73 GB SAS 15K RPM
# of CPUs: 8 cores, 2 chips, 4 cores/chip Network Interface: 1x Quad port Gigabit NIC, 2x Integrated 1Gb NIC
Memory (MB): 16384 Other Hardware: PERC5/i Integrated
L1 Cache: 32KB(I)+32KB(D) # of Systems: 2
L2 Cache: 2x6MB per chip H/W Available: Nov-2007
Other Cache: OS Available: Feb-2007
Notes / Tuning Information 
/etc/sysctl.conf:
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 4294967295
kernel.shmall = 268435456
vm.hugetlb_shm_group = 500
vm.nr_hugepages = 7200
net.ipv4.ip_local_port_range = 1024 65000
net.ipv4.conf.all.arp_ignore = 1
net.ipv4.conf.eth0.arp_ignore = 1
net.ipv4.conf.eth0.arp_ignore = 1
net.ipv4.conf.eth1.arp_ignore = 1
net.ipv4.conf.eth2.arp_ignore = 1
net.ipv4.conf.eth3.arp_ignore = 1
net.ipv4.conf.eth4.arp_ignore = 1
net.ipv4.conf.all.arp_announce = 2
net.ipv4.conf.eth0.arp_announce = 2
net.ipv4.conf.eth1.arp_announce = 2
net.ipv4.conf.eth2.arp_announce = 2
net.ipv4.conf.eth3.arp_announce = 2
net.ipv4.conf.eth4.arp_announce = 2
kernel.sem = 250 32000 100 128
fs.file-max = 262144
net.core.rmem_default = 10000000
net.core.wmem_default = 10000000
net.core.rmem_max = 10000000
net.core.wmem_max = 10000000
net.core.optmem_max = 10000000
net.ipv4.tcp_max_tw_buckets = 2000000
net.ipv4.tcp_mem = 30000000 30000000 30000000
net.ipv4.tcp_rmem = 30000000 30000000 30000000
net.ipv4.tcp_wmem = 30000000 30000000 30000000
net.ipv4.tcp_timestamps = 0
net.ipv4.tcp_max_syn_backlog = 12000
net.ipv4.tcp_fin_timeout = 10
net.core.somaxconn = 15000
net.core.netdev_max_backlog = 400000

/etc/rc.d/rc.local:
/sbin/ifconfig eth0 txqueuelen 60000
/sbin/ifconfig eth1 txqueuelen 60000
/sbin/ifconfig eth2 txqueuelen 60000
/sbin/ifconfig eth3 txqueuelen 60000
/sbin/ifconfig eth4 txqueuelen 60000
/sbin/ethtool -K eth0 tso on
/sbin/ethtool -K eth1 tso on
/sbin/ethtool -K eth2 tso on
/sbin/ethtool -K eth3 tso on
/sbin/ethtool -K eth4 tso on
/sbin/ethtool -K eth0 gso on
/sbin/ethtool -K eth1 gso on
/sbin/ethtool -K eth2 gso on
/sbin/ethtool -K eth3 gso on
/sbin/ethtool -K eth4 gso on
/etc/init.d/irqbalance stop
echo "ff" > /proc/irq/0/smp_affinity
echo "02" > /proc/irq/`cat /proc/interrupts|grep eth0|sed -e "s/:.*//"`/smp_affinity
echo "20" > /proc/irq/`cat /proc/interrupts|grep eth1|sed -e "s/:.*//"`/smp_affinity
echo "08" > /proc/irq/`cat /proc/interrupts|grep eth2|sed -e "s/:.*//"`/smp_affinity
echo "80" > /proc/irq/`cat /proc/interrupts|grep eth4|sed -e "s/:.*//"`/smp_affinity
umount /mnt/hugepages
mount -t hugetlbfs nodev /mnt/hugepages
chmod 777 /mnt/hugepages

Database Server HW (SUT hardware)
Hardware Vendor: Dell OS Vendor: Red Hat
Model Name: PowerEdge R900 OS Name: Red Hat Enterprise Linux 5 EM64T
Processor: Intel(R) Xeon(R) CPU X7350 Filesystem: ext3
MHz: 2933 Disks: 2x 146GB SAS 15K RPM
# of CPUs: 16 cores, 4 chips, 4 cores/chip Network Interface: 3x Dual port e1000 NIC
Memory (MB): 65536 Other Hardware: 1x PERC5/i Integrated, 2x PERC5/E Adapters, 32x 36GB SAS 15K RPM
L1 Cache: 32KB(I)+32KB(D) # of Systems: 1
L2 Cache: 2x4MB per chip H/W Available: Nov-2007
Other Cache: OS Available: Feb-2007
Notes / Tuning Information 
/etc/sysctl.conf:
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
fs.aio-max-nr=1048576
fs.file-max = 6553600
kernel.msgmni = 2878
kernel.sem = 250 32000 100 128
net.core.rmem_default = 1048576
net.core.wmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_max = 1048576
net.ipv4.conf.all.arp_announce = 2
net.ipv4.conf.all.arp_ignore = 1
net.ipv4.ip_local_port_range = 1024 65000
vm.hugetlb_shm_group = 502
vm.nr_hugepages = 22500

/etc/rc.local:
/sbin/ifconfig eth0 txqueuelen 60000
/sbin/ifconfig eth1 txqueuelen 60000
/sbin/ifconfig eth2 txqueuelen 60000
/sbin/ifconfig eth3 txqueuelen 60000
/etc/init.d/xinetd start
/etc/init.d/iptables stop
/etc/init.d/irqbalance stop
chmod 777 /home/oracle/10gR2/DB/dbs/*
chmod 777 /dev/mapper/*
echo "ffff" > /proc/irq/0/smp_affinity
echo "1000" > /proc/irq/`cat /proc/interrupts|grep eth0|sed -e "s/:.*//"|sed -e "s/ //"`/smp_affinity
echo "2000" > /proc/irq/`cat /proc/interrupts|grep eth1|sed -e "s/:.*//"|sed -e "s/ //"`/smp_affinity
echo "4000" > /proc/irq/`cat /proc/interrupts|grep eth2|sed -e "s/:.*//"|sed -e "s/ //"`/smp_affinity
echo "8000" > /proc/irq/`cat /proc/interrupts|grep eth3|sed -e "s/:.*//"|sed -e "s/ //"`/smp_affinity
# Bind RAID controller interrupts
echo "0020" > /proc/irq/185/smp_affinity
echo "0010" > /proc/irq/186/smp_affinity
echo "0002" > /proc/irq/194/smp_affinity

Lgwr nice priority was set to -20
For DNS named nice priority was set to -10
Oracle shadow processes were bound to all cores in a round robin fashion

Primary Driver HW (non-SUT hardware)
Hardware Vendor: Dell OS Vendor: Red Hat
Model Name: PowerEdge 6800 OS Name: Red Hat Enterprise Linux 4 Update 4 EM64T
Processor: Dual Core Intel(r) Xeon(r) 7041 Filesystem: ext3
MHz: 3000 Disks: 2x 36GB SCSI 15K RPM
# of CPUs: 8 cores, 4 chips, 2 cores/chip Network Interface: 1x 1000PT Quad Port Gigabit NIC, 2x Integrated 1Gb NIC
Memory (MB): 32768 Other Hardware:
L1 Cache: 12KB(I)+16KB(D) # of Systems: 1
L2 Cache: 2MB H/W Available: Mar-2007
Other Cache: OS Available: Jul-2006
Notes / Tuning Information 
/etc/sysctl.conf:
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
kernel.shmmax = 4294967295
kernel.sem = 250 32000 100 128
fs.file-max = 262144
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 10000000
net.core.wmem_default = 10000000
net.core.rmem_max = 10000000
net.core.wmem_max = 10000000
net.core.optmem_max = 10000000
net.ipv4.tcp_max_tw_buckets = 2000000
net.ipv4.tcp_mem = 30000000 30000000 30000000
net.ipv4.tcp_rmem = 30000000 30000000 30000000
net.ipv4.tcp_wmem = 30000000 30000000 30000000
net.ipv4.tcp_timestamps = 0
net.ipv4.tcp_max_syn_backlog = 12000
net.ipv4.tcp_fin_timeout = 10
net.core.somaxconn = 15000
net.core.netdev_max_backlog = 400000
net.ipv4.conf.all.arp_announce = 2
net.ipv4.conf.all.arp_ignore = 1

/etc/rc.local:
/sbin/ifconfig eth0 txqueuelen 60000
/sbin/ifconfig eth1 txqueuelen 60000
/sbin/ifconfig eth2 txqueuelen 60000
/sbin/ifconfig eth3 txqueuelen 60000
/sbin/ifconfig eth4 txqueuelen 60000
/sbin/ifconfig eth5 txqueuelen 60000
/etc/init.d/xinetd start
/etc/init.d/iptables stop
/etc/init.d/irqbalance stop
/etc/init.d/ntpd start

Satellite Driver #1 and Emulator HW (non-SUT hardware)
Hardware Vendor: Dell OS Vendor: Red Hat
Model Name: Dell PowerEdge 6800 OS Name: Red Hat Enterprise Linux 4 Update 4 EM64T
Processor: Intel(r) Xeon(r) 7140M Filesystem: ext3
MHz: 3400 Disks: 1x 36GB SCSI 15K RPM
# of CPUs: 8 cores, 4 chips, 2 cores/chip Network Interface: 1x Quad Port Gigabit NIC, 2x Integrated 1Gb
Memory (MB): 32768 Other Hardware:
L1 Cache: 12KB(I)+16KB(D) # of Systems: 1
L2 Cache: 1MB per chip H/W Available: Aug-2007
Other Cache: 16MB per chip L3 OS Available: Jul-2006
Notes / Tuning Information 
/etc/sysctl.conf:
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
kernel.shmmax = 150367895552
kernel.sem = 250 32000 100 128
fs.file-max = 262144
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 10000000
net.core.wmem_default = 10000000
net.core.rmem_max = 10000000
net.core.wmem_max = 10000000
net.core.optmem_max = 10000000
net.ipv4.tcp_max_tw_buckets = 2000000
net.ipv4.tcp_mem = 30000000 30000000 30000000
net.ipv4.tcp_rmem = 30000000 30000000 30000000
net.ipv4.tcp_wmem = 30000000 30000000 30000000
net.ipv4.tcp_timestamps = 0
net.ipv4.tcp_max_syn_backlog = 12000
net.ipv4.tcp_fin_timeout = 10
net.core.somaxconn = 15000
net.core.netdev_max_backlog = 400000
net.ipv4.conf.all.arp_announce = 2
net.ipv4.conf.all.arp_ignore = 1
kernel.shmall = 36710912
vm.hugetlb_shm_group = 500
vm.nr_hugepages = 7200

/etc/rc.local:
/sbin/ifconfig eth0 txqueuelen 60000
/sbin/ifconfig eth1 txqueuelen 60000
/sbin/ifconfig eth2 txqueuelen 60000
/sbin/ifconfig eth3 txqueuelen 60000
/sbin/ifconfig eth4 txqueuelen 60000
/sbin/ifconfig eth5 txqueuelen 60000
/etc/init.d/xinetd start
/etc/init.d/iptables stop
/etc/init.d/irqbalance stop

Satellite Driver #2 HW (non-SUT hardware)
Hardware Vendor: Dell OS Vendor: Red Hat
Model Name: PowerEdge 6850 OS Name: Red Hat Enterprise Linux 4 Update 4 EM64T
Processor: Intel(r) Xeon(r) 7140M Filesystem: ext3
MHz: 3400 Disks: 1x 36GB SCSI 15K RPM
# of CPUs: 8 cores, 4 chips, 2 cores/chip (HT) Network Interface: 1x Quad Port Gigabit NIC, 2x Integrated 1Gb
Memory (MB): 32768 Other Hardware:
L1 Cache: 12KB(I)+16KB(D) # of Systems: 1
L2 Cache: 1MB per chip H/W Available: Aug-2006
Other Cache: 16MB per chip L3 OS Available: Jul-2006
Notes / Tuning Information 
/etc/sysctl.conf:
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
kernel.shmmax = 4294967295
kernel.sem = 250 32000 100 128
fs.file-max = 262144
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 10000000
net.core.wmem_default = 10000000
net.core.rmem_max = 10000000
net.core.wmem_max = 10000000
net.core.optmem_max = 10000000
net.ipv4.tcp_max_tw_buckets = 2000000
net.ipv4.tcp_mem = 30000000 30000000 30000000
net.ipv4.tcp_rmem = 30000000 30000000 30000000
net.ipv4.tcp_wmem = 30000000 30000000 30000000
net.ipv4.tcp_timestamps = 0
net.ipv4.tcp_max_syn_backlog = 12000
net.ipv4.tcp_fin_timeout = 10
net.core.somaxconn = 15000
net.core.netdev_max_backlog = 400000
net.ipv4.conf.all.arp_announce = 2
net.ipv4.conf.all.arp_ignore = 1

/etc/rc.local:
/sbin/ifconfig eth0 txqueuelen 60000
/sbin/ifconfig eth1 txqueuelen 60000
/sbin/ifconfig eth2 txqueuelen 60000
/sbin/ifconfig eth3 txqueuelen 60000
/sbin/ifconfig eth4 txqueuelen 60000
/etc/init.d/xinetd start
/etc/init.d/iptables stop
/etc/init.d/irqbalance stop

Benchmark Modifications
Schema Modifications: 
  Tablespace sizes were increased to support the Injection rate. Table
  and index initrans were modified. The M_WORKORDER and O_ORDERLINE
  tables were horizontally partitioned. Scripts to create the DB are
  included in the FDA.
  Table locks were disabled during the run using disable_locks.sh script.
Load Program Modifications: 
  The load program was not modified.

Benchmark Configuration Information
Isolation Requirement Info: 
  The following Beans were deployed in READ_COMMITTED mode as per the benchmark
  requirement:
  Mfg      - AssemblyEnt, BomEnt, ComponentEnt, LargeOrderEnt, PartEnt
  Orders   - ItemEnt
  Supplier - SupplierCompEnt, SupplierEnt
  All other beans were deployed using pessimistic locking mode such that all
  selects including finders are issued with a FOR UPDATE clause in select
  statement:
  Corp     - CustomerEnt, CustomerInventoryEnt
  Mfg      - InventoryEnt, WorkOrderEnt
  Orders   - OrderEnt, OrderLineEnt
  Supplier - POEnt, POLineEnt, SComponentEnt
  Util     - SequenceEnt
  
  The ItemEnt bean was cached for 20 minute intervals by setting read-only to
  true and time-to-live to 1200000 in orders-toplink-ejb-jar.xml.
Durability Requirement Info: 
  To ensure database durability, RAID 10(mirroring) was used for the data files
  and database Redo logs maintained on the two Dell PowerVault MD1000 Arrays.
  
  The application server was using mirrored disks via Dell PERC5/i integrated
  to provide durability for server logs and JMS persistence filestore.
  
  The RAID controller on the database and the application server machines were
  configured with Write-Back cache policy supported with battery backup unit on
  the controller.
Storage Requirement Info: 
  A 80 min run at Injection Rate of 2150 increased storage by 6 GB.
  Extrapolating for 24 hrs we need 108 GB. The system is configured with
  over 572 GB of durable storage.
Argument Passing Semantics: 
  Oracle Application Server 10g uses pass-by-value as required by the
  EJB specification.

Bill of Materials 

Supplier  Description                                     Product #          Qty
--------  -------------------------------------------     ----------------   ---
Dell      PowerEdge 1950 Quad Core Intel(r) Xeon(r) E5440 223-4543	       2
	  2X6MB Cache 2.83GHz, 1333MHz FSB
Dell      2 Quad Core Intel(r) Xeon(r) E5440,             311-8046             2
          2x6MB Cache, 2.83GHz, 1333MHZ FSB      
Dell      16GB 667MHz (8x2GB), Dual Ranked DIMMs          311-6199             2
Dell      73GB, SAS, 3.5-inch, 15K RPM Hard Drive         341-3029             4
Intel     Intel Pro 1000PT Quad Port Gigabit NIC          A1119124             2
Dell	  Intel Pro 1000PT Dual Port Gigabit NIC	  430-0960	       2	  
Dell      3Yr GOLD ENTERPRISE SUPPORT: 7x24 HW/SW,        984-1519,984-1528    2
							  310-3785,960-7532
          Escalation Mgmt 4hr 7x24 Onsite		  960-7892,970-3620	
                          
Dell      PowerEdge R900 Quad Core Intel(r) Xeon(r) X7350 223-4229	       1
	  2X4MB Cache 2.93GHz, 1066MHz FSB
Dell      4 Quad Core Intel(r) Xeon(r) E7350,             310-9825             1
          2x4MB Cache, 2.93GHz, 1066MHZ FSB      
Dell      64GB 667MHz (16x4GB), Dual Ranked DIMMs         311-7857             1
Dell      73GB, SAS, 3.5-inch, 15K RPM Hard Drive         341-4727             4
Dell	  Intel Pro 1000PT Dual Port Gigabit NIC	  430-0960	       3	  
Dell      3Yr GOLD ENTERPRISE SUPPORT: 7x24 HW/SW,        989-0387,989-0348    1
							  985-2420,984-6492
          Escalation Mgmt 4hr 7x24 Onsite		  984-6312,310-3785	


Dell      5224 Managed Switch, 24 Port Gigabit Ethernet   222-2248             1
          Switch with 4 SFP combo ports

Dell      3Yr GOLD Support, 4Hr Onsite                    983-3758,983-3837    1
          S/W Support, TAM Service                        960-1305,960-4492
                                                          960-9620

Dell      MD1000 15-Bay Disk Enclosure                    222-2299             3
Dell      36GB,3GBps,SAS,3.5-inch,15K                     341-2816            32
Dell      PERC5/e SAS RAID Controller                     341-3023             2

Red Hat	  Enterprise Linux Premium Subscription 1yr	  		       6
Oracle    Oracle Database 10g Release 2 Enterprise Edition, Per Processor      8*
          (v10.2)                                                              
Oracle    Oracle Database Server Support Package for 3 years                   1 
          (Incident Server Support) 24x7x4                                     
Oracle    Oracle Application Server 10g - Java Edition, Per Processor          8*
          (v10.1)
Oracle    Oracle Application Server Support Package for 3 years                1
          (Incident Server Support) 24x7x4

(* 8 = 0.50 * 16).  Explanation:  For the purposes of counting the number of 
processors which require licensing, an Intel multicore chip with "n" cores 
shall be determined by multiplying "n" cores by a factor of 0.50).

Other Benchmark Information 
  The xerces implementation version 2.6.2 from xml.apache.org was used as it comes
  packaged with Oracle Application Server 10g.
  
  Requests were directed to the Appserver instances using DNS round robin, with
  the database node 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://main.spec.com:23791/SPECjAppServer
  java.naming.security.principal=oc4jadmin
  java.naming.security.credentials=welcome
  oracle.j2ee.rmi.loadBalance=lookup

General Notes 
On the database, incremental checkpointing ensured that no buffer will remain
dirty (in the cache) for more than the allowed time.

Oracle Application Server 10g Release 10.1.3.3 implements Recoverable Last
Resource Commit optimization where one and only one SinglePhaseResource
participates in a global transaction with one or more XAResources. This is
accomplished by emulating an XAResource to represent the 1PC resource. The
transaction manager takes the following steps when it receives a request to
commit a global transaction that includes one emulated XAResource:
1. It invokes a prepare call on each of the 2PC resources.
2. If all of the 2PC resources are successfully prepared, then commit
   (one-phase) is called and the commit record is written to the commit-log, on
   the emulated XA resource (database) as part of the local transaction.
3. If the 1PC on the emulated XA resource completes successfully, then the
   transaction manager calls commit on each of the 2PC resources.
   or:
   If the 1PC on the emulated XA resource fails, then the transaction manager
   queries the commit-log for transaction outcome. If the record exists, 2PC
   resources are committed, otherwise 2PC Resources are aborted.
Transaction outcome after a single point of failure is guaranteed by the presence
of the commit-record in the commit log, indicating a successful transaction
completion; while a missing commit-record signifies abort. The commit record is
deleted lazily after the global transaction has committed.

The table name listed in the default scripts for creating RLRC table, included in
Oracle Application Server 10g Release 10.1.3.3, was modified to reflect the tablename
listed in the data-sources.xml file in the Config directory of each instance.

The only errors in the driver error logs are the application errors generated by
this benchmark.

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

Copyright © 2004 Standard Performance Evaluation Corporation

First published at SPEC.org on 12-Nov-2007