-------------------------------------------------------------------------------- SPECjAppServer(R)2004 Result Copyright (C) 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 -------------------------------------------------------------------------------- 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 sec # of Dealer Agents: 12 Ramp Down Time: 300 sec # of Manufacturing Agents: 7 Steady State Time: 3,600 sec DB Load Injection Rate: 3,000 Trigger Time: 680 sec -------------------------------------------------------------------------------- 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 -------------------------------------------------------------------------------- SOFTWARE PRODUCTS -------------------------------------------------------------------------------- Oracle Application Server 10G Release 10.1.3.3 - Java Edition Vendor: Oracle Corporation Availability Date: Nov-2007 Date Passed CTS: Jan-2006 CTS Version: 1.4 EJB Protocol: ORMI OS Name: Red Hat Enterprise Linux 5 IA32 PAE -------------------------------------------------------------------------------- BEA JRockit(R) 6.0 JDK (R27.3.0-106) (Linux x86 32bit) Vendor: BEA Systems, Inc. Availability Date: 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 Date: Jul-2007 OS Name: Red Hat Enterprise Linux 4 Update 4 EM64T -------------------------------------------------------------------------------- Oracle JDBC Driver 10.2.0.2 (Thin) Vendor: Oracle Corporation Availability Date: 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 Date: Feb-2006 OS Name: Red Hat Enterprise Linux 5 EM64T -------------------------------------------------------------------------------- SOFTWARE CONFIGURATIONS -------------------------------------------------------------------------------- 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 -------------------------------------------------------------------------------- HARDWARE SYSTEMS -------------------------------------------------------------------------------- J2EE Server HW (SUT hardware) Hardware Vendor: Dell Model Name: PowerEdge 1950 III Processor: Intel(R) Xeon(R) CPU E5440 MHz: 2833 # of CPUs: 8 cores, 2 chips, 4 cores/chip Memory (MB): 16384 L1 Cache: 32KB(I)+32KB(D) L2 Cache: 2x6MB per chip Other Cache: OS Vendor: Red Hat OS Name: Red Hat Enterprise Linux 5 IA32 PAE Disks: 2x73 GB SAS 15K RPM Network Interface: 1x Quad port Gigabit NIC, 2x Integrated 1Gb NIC Other Hardware: PERC5/i Integrated # of Systems: 2 H/W Available: Nov-2007 O/S 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 Model Name: PowerEdge R900 Processor: Intel(R) Xeon(R) CPU X7350 MHz: 2933 # of CPUs: 16 cores, 4 chips, 4 cores/chip Memory (MB): 65536 L1 Cache: 32KB(I)+32KB(D) L2 Cache: 2x4MB per chip Other Cache: OS Vendor: Red Hat OS Name: Red Hat Enterprise Linux 5 EM64T Disks: 2x 146GB SAS 15K RPM Network Interface: 3x Dual port e1000 NIC Other Hardware: 1x PERC5/i Integrated, 2x PERC5/E Adapters, 32x 36GB SAS 15K RPM # of Systems: 1 H/W Available: Nov-2007 O/S 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 Model Name: PowerEdge 6800 Processor: Dual Core Intel(r) Xeon(r) 7041 MHz: 3000 # of CPUs: 8 cores, 4 chips, 2 cores/chip Memory (MB): 32768 L1 Cache: 12KB(I)+16KB(D) L2 Cache: 2MB Other Cache: OS Vendor: Red Hat OS Name: Red Hat Enterprise Linux 4 Update 4 EM64T Disks: 2x 36GB SCSI 15K RPM Network Interface: 1x 1000PT Quad Port Gigabit NIC, 2x Integrated 1Gb NIC Other Hardware: # of Systems: 1 H/W Available: Mar-2007 O/S 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 Model Name: Dell PowerEdge 6800 Processor: Intel(r) Xeon(r) 7140M MHz: 3400 # of CPUs: 8 cores, 4 chips, 2 cores/chip Memory (MB): 32768 L1 Cache: 12KB(I)+16KB(D) L2 Cache: 1MB per chip Other Cache: 16MB per chip L3 OS Vendor: Red Hat OS Name: Red Hat Enterprise Linux 4 Update 4 EM64T Disks: 1x 36GB SCSI 15K RPM Network Interface: 1x Quad Port Gigabit NIC, 2x Integrated 1Gb Other Hardware: # of Systems: 1 H/W Available: Aug-2007 O/S 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 Model Name: PowerEdge 6850 Processor: Intel(r) Xeon(r) 7140M MHz: 3400 # of CPUs: 8 cores, 4 chips, 2 cores/chip (HT) Memory (MB): 32768 L1 Cache: 12KB(I)+16KB(D) L2 Cache: 1MB per chip Other Cache: 16MB per chip L3 OS Vendor: Red Hat OS Name: Red Hat Enterprise Linux 4 Update 4 EM64T Disks: 1x 36GB SCSI 15K RPM Network Interface: 1x Quad Port Gigabit NIC, 2x Integrated 1Gb Other Hardware: # of Systems: 1 H/W Available: Aug-2006 O/S 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 SPEC - Benchmark run on Mon Oct 22 19:09:37 CDT 2007 by SPECjAppServer2004 v1.08 - Result submitted on Wed Oct 24 03:33:24 EDT 2007 - Report generated by SPECjAppServer2004 Reporter v1.03 Copyright (C) 2004 Standard Performance Evaluation Corporation