-------------------------------------------------------------------------------- SPECjAppServer(R)2004 Result Copyright (C) 2004 Standard Performance Evaluation Corporation -------------------------------------------------------------------------------- Oracle Application Server 10g Release 10.1.3.3.2 - Java Edition on HP-UX Integrity BL860c Server Blade Cluster -------------------------------------------------------------------------------- 9,459.19 SPECjAppServer2004 JOPS@Standard -------------------------------------------------------------------------------- Submitter: Oracle Corporation SPEC license # 73 Test date: Nov-2007 -------------------------------------------------------------------------------- SUT CONFIGURATION -------------------------------------------------------------------------------- J2EE Server Nodes: 11 DB Server Nodes: 2 J2EE Server CPUs: 44 cores, 22 chips, 2 cores/chip DB Server CPUs: 80 cores, 40 chips, 2 cores/chip J2EE Instances: 22 DB Instances: 2 Other SUT Components: HP Integrity rx3600 as DNS server for load balancing HP ProCurve 2848 Switch -------------------------------------------------------------------------------- BENCHMARK SETTINGS -------------------------------------------------------------------------------- Dealer Injection Rate: 5,700 Ramp Up Time: 900 sec # of Dealer Agents: 138 Ramp Down Time: 300 sec # of Manufacturing Agents: 48 Steady State Time: 3,600 sec DB Load Injection Rate: 6,000 Trigger Time: 1,800 sec -------------------------------------------------------------------------------- Detailed Results -------------------------------------------------------------------------------- Dealer Transaction Mix Count Tx. Mix Purchase 5,137,090 25.01% Manage 5,135,216 25.00% Browse 10,265,835 49.98% Total # Dealer Transactions 20,538,141 Total # Manufacturing Transactions 13,514,955 Response Times Average Maximum 90th% Reqd Purchase 0.42 25.00 0.60 2.00 Manage 0.40 29.88 0.70 2.00 Browse 0.48 21.24 0.70 2.00 Manufacturing 1.94 15.81 3.00 5.00 Reproducibility Run (SPECjAppServer2004 JOPS) 9,465.02 -------------------------------------------------------------------------------- SOFTWARE PRODUCTS -------------------------------------------------------------------------------- Oracle Application Server 10g Release 10.1.3.3.2 - Java Edition Vendor: Oracle Corporation Availability Date: Feb-2008 Date Passed CTS: Jan-2006 CTS Version: 1.4 EJB Protocol: ORMI OS Name: HP-UX 11i v3 Sept 2007 -------------------------------------------------------------------------------- Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0.08) 32 bit Vendor: HP Availability Date: May-2007 OS Name: HP-UX 11i v3 Sept 2007 -------------------------------------------------------------------------------- Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0.08) 64 bit Vendor: HP Availability Date: May-2007 OS Name: HP-UX 11i v2 -------------------------------------------------------------------------------- Oracle JDBC Driver 10.2.0.3 (Thin) Vendor: Oracle Corporation Availability Date: Feb-2007 OS Name: HP-UX 11i v3 Sept 2007 -------------------------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.3 with Oracle Real Application Clusters Option and patch 5500535 Vendor: Oracle Corporation Availability Date: Feb-2007 OS Name: HP-UX 11i v3 -------------------------------------------------------------------------------- SOFTWARE CONFIGURATIONS -------------------------------------------------------------------------------- J2EE Application Servers J2EE Product: Oracle Application Server 10g Release 10.1.3.3.2 - Java Edition JVM Product: Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0.08) 32 bit JDBC Product: Oracle JDBC Driver 10.2.0.3 (Thin) Hardware: J2EE AppServer HW (SUT hardware) # of Instances: 22 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 -XX:+AggressiveHeap -Xmx3450m -Xms3450m -Xmn1750m -XX:CICompilerCount=1 -Xverbosegc:file=stdout -XX:+ForceMmapReserved -XX:PermSize=48m -XX:SurvivorRatio=14 -XX:+UseSpinning -XX:-UseHighResolutionTimer -XX:SchedulerPriorityRange=SCHED_RTPRIO -Doracle.dms.sensors=none -Dsun.net.inetaddr.ttl=0 -Dnetworkaddress.cache.ttl=0 -Djava.nio.channels.spi.SelectorProvider=sun.nio.ch.DevPollSelectorProvider -Doc4j.jms.implementation=oc4j.j2ee.jms -------------------------------------------------------------------------------- Emulator SW Config JVM Product: Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0.08) 64 bit Web Product: Oracle Application Server 10g Release 10.1.3.3.2 - Java Edition Hardware: Emulator HW # of Instances: 1 Notes / Tuning Information -d64 -Xmx15g -Xms15g -Xss272k -XX:-TraceClassUnloading -Xoptgc -Xverbosegc:file=stdout -XX:+ForceMmapReserved -XX:PermSize=96m -XX:-UseHighResolutionTimer -XX:-UseHighResolutionTimer -Doracle.dms.sensors=none -Dsun.net.inetaddr.ttl=0 -Dnetworkaddress.cache.ttl=0 -Djava.nio.channels.spi.SelectorProvider=sun.nio.ch.DevPollSelectorProvider -------------------------------------------------------------------------------- Database SW Config - RAC Node 1 DB Product: Oracle Database 10g Enterprise Edition Release 10.2.0.3 with Oracle Real Application Clusters Option and patch 5500535 Hardware: Database Server HW (SUT hardware) # of Instances: 1 Notes / Tuning Information Oracle tuning in init.ora: aq_tm_processes=0 _array_update_vector_read_enabled=true cluster_database_instances=2 cluster_database = true cluster_interconnects = '1.1.90.1' _collect_undo_stats=false compatible=10.2.0.0.0 control_files = '+DATA/cntrlspec' _cursor_cache_frame_bind_memory=true cursor_space_for_time = TRUE db_4k_cache_size = 3G db_8k_cache_size = 10G db_block_checking = FALSE db_block_checksum = FALSE db_block_size = 2048 db_cache_advice = OFF _db_cache_pre_warm=FALSE db_cache_size = 40G db_file_multiblock_read_count = 128 db_files = 256 db_keep_cache_size = 4G db_name = spec _db_writer_flush_imu=FALSE disk_asynch_io=true dml_locks = 1000 fast_start_mttr_target=0 _gc_affinity_time=0 _gc_global_lru = off _gc_undo_affinity=FALSE hpux_sched_noage=180 _immediate_commit_propagation = FALSE _imu_pools=3000 _in_memory_undo=true instance_groups='SPEC1' instance_name=spec1 instance_number=1 java_pool_size=0 job_queue_processes=0 _ksmg_granule_size=33554432 lock_sga=true log_buffer=67108864 log_checkpoint_interval=0 log_checkpoints_to_alert=TRUE log_checkpoint_timeout=1500 open_cursors = 3000 parallel_instance_group='SPEC1' pga_aggregate_target=0 processes = 5500 query_rewrite_enabled=FALSE replication_dependency_tracking=FALSE session_cached_cursors=2000 sessions = 5500 shared_pool_size =12g _smm_advice_enabled=FALSE sort_area_size=52428800 statistics_level = BASIC thread=1 timed_statistics = false trace_enabled=FALSE transactions = 5500 transactions_per_rollback_segment = 1 _two_pass=FALSE _undo_autotune=FALSE undo_management = AUTO undo_retention = 500 undo_tablespace = undo_ts1 log writer put into realtime class with /usr/bin/rtprio 127 -PID and put in its own processor set with /usr/sbin/psrset -b Listener was started with Round robin policy to distribute the Oracle shadow processes to different cells. -------------------------------------------------------------------------------- Database SW Config - RAC Node 2 DB Product: Oracle Database 10g Enterprise Edition Release 10.2.0.3 with Oracle Real Application Clusters Option and patch 5500535 Hardware: Database Server HW (SUT hardware) # of Instances: 1 Notes / Tuning Information Oracle tuning in init.ora: aq_tm_processes=0 _array_update_vector_read_enabled=true cluster_database_instances=2 cluster_database = true cluster_interconnects = '1.1.90.2' _collect_undo_stats=false compatible=10.2.0.0.0 control_files = '+DATA/cntrlspec' _cursor_cache_frame_bind_memory=true cursor_space_for_time = TRUE db_4k_cache_size = 12G db_8k_cache_size = 15G db_block_checking = FALSE db_block_checksum = FALSE db_block_size = 2048 db_cache_advice = OFF _db_cache_pre_warm=FALSE db_cache_size = 35G db_file_multiblock_read_count = 128 db_files = 256 db_keep_cache_size = 6G db_name = spec _db_writer_flush_imu=FALSE disk_asynch_io=true dml_locks = 1000 fast_start_mttr_target=0 _gc_affinity_time=0 _gc_global_lru = off _gc_undo_affinity=FALSE hpux_sched_noage=180 _immediate_commit_propagation = FALSE _imu_pools=3000 _in_memory_undo=true instance_groups='SPEC2' instance_name=spec2 instance_number=2 java_pool_size=0 job_queue_processes=0 _ksmg_granule_size=33554432 lock_sga=true log_buffer=67108864 log_checkpoint_interval=0 log_checkpoints_to_alert=TRUE log_checkpoint_timeout=1500 open_cursors = 3000 parallel_instance_group='SPEC2' pga_aggregate_target=0 processes = 5500 query_rewrite_enabled=FALSE replication_dependency_tracking=FALSE session_cached_cursors=2000 sessions = 5500 shared_pool_size =12g _smm_advice_enabled=FALSE sort_area_size=52428800 statistics_level = BASIC thread=2 timed_statistics = false trace_enabled=FALSE transactions = 5500 transactions_per_rollback_segment = 1 _two_pass=FALSE _undo_autotune=FALSE undo_management = AUTO undo_retention = 500 undo_tablespace = undo_ts2 log writer put into realtime class with /usr/bin/rtprio 127 -PID and put in its own processor set with /usr/sbin/psrset -b Listener was started with Round robin policy to distribute the Oracle shadow processes to different cells. -------------------------------------------------------------------------------- Driver SW Config Primary and Satellites JVM Product: Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0.08) 32 bit Hardware: Primary Load Driver and Satellite Drivers # of Instances: 6 Notes / Tuning Information -server -Xms700M -Xmx700M -Xmn300M -Xss256K -XX:+DisableExplicitGC -XX:+ForceMmapReserved -XX:PermSize=64m -XX:SurvivorRatio=20 -XX:-UseHighResolutionTimer -XX:SchedulerPriorityRange=SCHED_RTPRIO -Dsun.net.inetaddr.ttl=0 -Dnetworkaddress.cache.ttl=0 -Djava.nio.channels.spi.SelectorProvider=sun.nio.ch.DevPollSelectorProvider -------------------------------------------------------------------------------- HARDWARE SYSTEMS -------------------------------------------------------------------------------- J2EE AppServer HW (SUT hardware) (SUT hardware) Hardware Vendor: HP Model Name: HP BL860c Processor: Dual-core Intel Itanium 9100 MHz: 1667 # of CPUs: 4 cores, 2 chips, 2 cores/chip Memory (MB): 24545 L1 Cache: 16KB(I)+16KB(D) L2 Cache: 1024KB(I)+256KB(D) Other Cache: 9216KB (L3 Cache) OS Vendor: HP OS Name: HP-UX 11i v3 Sept 2007 Disks: see notes Network Interface: (2) HP PCI-X 1000Mbps Dual-port Built-in Other Hardware: (1) HP 4Gb Dual Port PCIe Fibre Channel Mezzanine # of Systems: 11 H/W Available: Oct-2007 O/S Available: Sep-2007 Notes / Tuning Information Kernel Tunable Entries: TRMSGSZ 65535 create_fastlinks 1 default_disk_ir 1 fs_async 1 hires_timeout_enable 0 lcpu_attr 1 max_async_ports 768 max_thread_proc 2048 maxdsiz 4294963200 maxfiles 2048 maxfiles_lim 32768 maxssiz 10100000 maxtsiz 1073741824 maxuprc 2040 msgmnb 65536 msgtql 5120 ninode 150000 nkthread 20000 nproc 5000 npty 200 nstrpty 200 nswapdev 25 semmni 4096 semmns 8192 semmnu 4092 semume 512 shmmax 15000000000 shmmni 520 shmseg 512 swchunk 8192 tcphashsz 32768 vps_ceiling 64 Disk Configuration: 1 x HP 72GB 15K SAS HDD 2 x HP StorageWorks Modular SAN Array 1000 for server and JMS logging 6 each of the AppServer systems connected to one of the two Storage Array Network Tuning: ndd -set /dev/tcp tcp_conn_request_max 15000 ndd -set /dev/tcp tcp_smallest_anon_port 1024 ndd -set /dev/tcp tcp_time_wait_interval 2000 ndd -set /dev/tcp tcp_naglim_def 1 -------------------------------------------------------------------------------- Database Server HW (SUT hardware) (SUT hardware) Hardware Vendor: HP Model Name: Superdome Processor: Dual-core Intel Itanium 9000 MHz: 1600 # of CPUs: 40 cores, 20 chips, 2 cores/chip Memory (MB): 163512 L1 Cache: 16KB(I)+16KB(D) L2 Cache: 1024KB(I)+256KB(D) Other Cache: 12MB (L3 Cache) OS Vendor: HP OS Name: HP-UX 11i v3 Disks: 4x36Gb 15K RPM U320 Network Interface: (4) HP PCI/PCI-X 1000Base-T Dual-port Adapter Other Hardware: See notes # of Systems: 2 H/W Available: Sep-2006 O/S Available: Feb-2007 Notes / Tuning Information Kernel tunable entries: create_fastlinks 1 default_disk_ir 1 fs_async 1 ksi_alloc_max 32768 max_async_ports 16384 max_thread_proc 32768 maxdsiz 1073741824 maxdsiz_64bit 2147483648 maxfiles 130000 maxfiles_lim 130000 maxssiz 134217728 maxssiz_64bit 1073741824 maxtsiz 1073741824 maxuprc 6000 msgmnb 65536 msgmni 4096 msgtql 4096 ncsize 34816 nflocks 16384 ninode 34816 nkthread 130000 nproc 60000 npty 200 nstrpty 200 nswapdev 25 semmni 4096 semmns 8192 semmnu 4092 semume 512 semvmx 32767 shmmax 4398046511104 shmmni 512 shmseg 512 swchunk 8192 tcphashsz 32768 vps_ceiling 64 Network Tuning: ndd -set /dev/udp udp_smallest_anon_port 1024 ndd -set /dev/tcp ip_strong_es_model 1 (2) HP StorageWorks EVA810 2C6D Array shared between Each with 112 x 146GB 15K FC HDD and HP StorageWorks SAN Swicth (4) HP 4Gb Dual Port PCI/PCI-X Fibre Channel Adapter -------------------------------------------------------------------------------- Primary Load Driver and Satellite Drivers (non-SUT hardware) Hardware Vendor: HP Model Name: Superdome Processor: Intel Itanium 9000 MHz: 1600 # of CPUs: 16 cores, 8 chips, 2 cores/chip Memory (MB): 130940 L1 Cache: 16KB(I)+16KB(D) L2 Cache: 256KB Other Cache: 12MB (L3 Cache) OS Vendor: HP OS Name: HP-UX 11i v3 Disks: 1x73Gb 15K RPM U320 Network Interface: (3) HP PCI/PCI-X 1000Base-T Dual-port Adapter Other Hardware: null # of Systems: 6 H/W Available: Sep-2006 O/S Available: Feb-2007 Notes / Tuning Information Kernel tunables entries max_async_ports 768 max_thread_proc 8192 maxdsiz 4294963200 maxfiles 32768 maxfiles_lim 32768 maxssiz 12582912 maxtsiz 1073741824 maxuprc 3277 ninode 150000 nkthread 65536 nproc 5000 shmmax 4200000000 shmmni 520 shmseg 512 Network Tuning: ndd -set /dev/tcp tcp_conn_request_max 15000 ndd -set /dev/tcp tcp_smallest_anon_port 1024 ndd -set /dev/tcp tcp_time_wait_interval 2000 ndd -set /dev/tcp tcp_naglim_def 1 -------------------------------------------------------------------------------- Emulator HW (non-SUT hardware) Hardware Vendor: HP Model Name: rx8640 Processor: Intel Itanium 9000 MHz: 1600 # of CPUs: 32 cores, 16 chips, 2 cores/chip Memory (MB): 261882 L1 Cache: 16KB(I)+16KB(D) L2 Cache: 256KB Other Cache: 12MB (L3 Cache) OS Vendor: HP OS Name: HP-UX 11i v2 Disks: 1x73Gb 15K RPM U320 Network Interface: (3) HP PCI/PCI-X 1000Base-T Dual-port Adapter Other Hardware: null # of Systems: 1 H/W Available: Sep-2006 O/S Available: May-2005 Notes / Tuning Information Kernel tunables entries STRMSGSZ 65535 create_fastlinks 1 default_disk_ir 1 fs_async 1 max_async_ports 768 max_thread_proc 125000 maxdsiz 4294963200 maxdsiz_64bit 40000000000 maxfiles 150000 maxfiles_lim 150000 maxssiz 100000000 maxssiz_64bit 1000000000 maxtsiz 1073741824 maxuprc 2040 msgmnb 65536 msgtql 5120 nfile 300000 ninode 150000 nkthread 131072 nproc 5000 npty 200 nstrpty 200 o_sync_is_o_dsync 1 semmni 4096 semmns 8192 semmnu 4092 semume 512 shmmax 15000000000 shmmni 520 shmseg 512 swchunk 22000 tcphashsz 32768 vps_ceiling 64 Network Tuning: ndd -set /dev/tcp tcp_conn_request_max 15000 ndd -set /dev/tcp tcp_smallest_anon_port 1024 ndd -set /dev/tcp tcp_time_wait_interval 2000 ndd -set /dev/tcp tcp_naglim_def 1 -------------------------------------------------------------------------------- DNS Load Balancer Hardware (SUT hardware) (SUT hardware) Hardware Vendor: HP Model Name: rx3600 Processor: Intel Itanium 9000 MHz: 1600 # of CPUs: 4 cores, 2 chips, 2 cores/chip Memory (MB): 32768 L1 Cache: 16KB(I)+16KB(D) L2 Cache: 256KB Other Cache: 9216KB (L3 Cache) OS Vendor: HP OS Name: HP-UX 11i v3 Disks: 1x73Gb 15K RPM U320 Network Interface: (1) HP PCI/PCI-X 1000Base-T Dual-port Adapter Other Hardware: null # of Systems: 1 H/W Available: Sep-2006 O/S Available: Feb-2007 Notes / Tuning Information Kernel tunables entries STRMSGSZ 0 max_async_ports 768 max_thread_proc 125000 maxdsiz 4294963200 maxfiles 150000 maxfiles_lim 150000 maxssiz 12582912 maxtsiz 1073741824 maxuprc 3277 ninode 150000 nkthread 131072 nproc 5000 shmmax 4200000000 shmmni 520 shmseg 512 vps_ceiling 64 -------------------------------------------------------------------------------- BENCHMARK MODIFICATIONS -------------------------------------------------------------------------------- Schema Modifications: Tablespace sizes were increased to support the Injection rate. Scripts to create the DB are included in the FDA. Table and index initrans were modified. The M_INVENTORY, M_WORKORDER, M_PARTS, O_ORDERLINE, S_SUPP_COMPONENT, S_PO, C_CUSTOMERINVENTORY, O_ORDERS tables were horizontally partitioned. Automatic segment space management was used for all tablespaces. System managed undo was used. Table locks were disabled during the run using disable_lock.sql -------------------------------------------------------------------------------- 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 (ms) in orders-toplink-ejb-jar.xml deployment descriptor. -------------------------------------------------------------------------------- Durability Requirement Info: To ensure database durability, RAID 1 (mirroring) was used for the database Redo logs and datafiles. The application server was using mirrored disks to provide durability for server logs and JMS persistence filestore. The RAID controller on the database and application server machines were configured with Write-Back cache policy supported with battery backed up unit on the controller. -------------------------------------------------------------------------------- Storage Requirement Info: An 80 minute run at an injection rate of 5700 increased storage by 13.76GB This extrapolates to 248GB of storage for a 24 hour run. The database is configured with 16TB 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 -------- ------------------------------------------- ---------------- --- HP Integrity BL860c blade server AD323A-006 11 2 x 1.67GHz Itanium 9100 processors HP 4GB (2 x 2GB) PC2-4200 DDR2 SDRAM DIMMs AD344A 66 HP 72GB SAS 15,000rpm disk drive 431935-B21 11 HP QLogic QMH2462 4Gb FC HBA 403619-B21 11 HP C7000 Enclosure AD361B 2 HP 4Gb Fibre Channel Pass-thru Module 403626-B21 4 HP 1Gb Ethernet Pass-Thru Module 406740-B21 4 HP BladeSystem c7000 Active Cool Fan 412140-B21 11 HP BladeSystem c7000 Power Module 413379-B21 11 HP HP-UX FOE BA531AC 44 HP 3 year 24x7 hardware and software support HA110A3 HP HP Superdome Server Solution A5200A 2 HP 32 processor Superdome Enterprise Server A9834A-429 2 HP 200-240VAC 3 phase, 4 wires, 8 gage cord A9834A-006 2 HP Superdome sx2000 Cell Board for Montecito A9837A-0D1 10 HP 1.6 GHz Montecito with 24MB cache A9840A-0D1 40 Itanium dual-core module HP Memory - 16GB high performance DDR2 A9846A-0D1 20 (8x2GB DIMM) HP HP 12 Slot PCI-X Chassis for sx2000 A9836A-0D1 6 HP 4Gb PCI-X DC 64 bit FC HBA A6826A-0D1 8 HP PCI-X 2 port 1000Base-T Gigabit Adptr A7012A-0D1 8 HP HP-UX OE LTU B9429CA-UMG,0D1,AJR 40 HP HP rx2620 1.0G 1.5MB CPU server Solution AB332A 1 Admin Console HP 3 year 24x7 hardware and software support HA110A3 HP HP ProCurve 2848 Switch J4904A 1 HP 3 year 24x7 hardware and software support HA110A3 HP Modular SAN Array 1000 201723-B22 2 HP 72GB 15K U320 Pluggable Hard Drive 286778-B22 28 HP MSA Controller 218231-B22 2 HP MSA 1000 Fibre Channel IO Module 218960-B21 2 HP 256MB Cache Module 254786-B21 2 HP 3 year 24x7 hardware and software support HA110A3 HP EVA810 2C6D Array AG701A 2 HP StorageWorks 4/32 Full SAN Switch AG757A 2 HP CV EVA 8k Series Unlimited Lic T5183A 2 HP M5314C FC Drive Enclosure AD542C 8 HP StorageWorks 146GB 15K FC HDD 364621-B23 224 HP 4GB SW Single Pack SFP Transceiver A7446B 32 HP Storage Works LC/LC 2m Cable 221692-B21 32 HP 24A High Voltage US/JP Modular PDU 252663-D72 4 HP Universal Rack 10642 G2 Shock Rack AF002A 1 HP 10K G2 600W Stabilizer Kit AF062A 1 HP 10642 G2 Sidepanel Kit AF054A 1 HP CV EVA 7.0 Rep Sol Mgr 3.0 Media Kit T3724E 1 HP Stor Essen Std Ed SRM Media Kit T5314AA 1 HP Stor Essen Std Ed SRM LTU T5315AA 1 HP Bus Copy EVA8K Ser 1TB LTU T5341A 1 HP 3y Proactive 24 Service HA111A3 HP HP rx3600 1.6GHz/18MB 4-core AB596A-160 1 HP 8GB memory using 2GB DIMMS AB565A-0D1 4 HP 36GB 10K RPM drives AD140A-0D1 1 HP iether 2 port Gigabit LAN card A7012A-0D1 1 HP 4Gb Dual Port Fibre Channel Adapter AB379A 1 HP HP-UX FOE B9430AC 4 HP 3 year 24x7 hardware and software support HA110A3 Oracle Oracle Database 10g Release 2 Enterprise Edition, 40* Per Processor (v10.2) Oracle Partitioning, Per Processor, Unlimited Users for 3 years 40* Oracle Real Application Cluster, Per Processor, 40* Unlimited Users for 3 years Oracle Oracle Database Server Support Package for 3 years 2 Incident Server Support -(24x7x4) Oracle Oracle Application Server 10g - Java Edition, Per Processor 22* (v10.1) Oracle Oracle Application Server Support Package for 3 years 11 - Incident Server Support -Package - (24x7x4) (* 40 = 0.50 * 80) & (22= 0.50*44). 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 sent to different Appservers using DNS round robin, with a DNS server running on the DNS load balancer node. The driver used the following jndi.properties: java.naming.factory.initial=com.evermind.server.rmi.RMIInitialContextFactory java.naming.provider.url=ormi://main.specj.com:23791/SPECjAppServer java.naming.security.principal=oc4jadmin java.naming.security.credentials=welcome oracle.j2ee.rmi.loadBalance=lookup -------------------------------------------------------------------------------- General Notes -------------------------------------------------------------------------------- The only errors in the driver error logs are the application errors generated by this benchmark. On the database, incremental checkpointing ensured that no buffer will remain dirty (in the cache) for more than the allowed time. Oracle Real Application Clusters (RAC) is an option to Oracle Database 10g Enterprise edition. RAC extends Oracle Database so that you can store, update, and efficiently retrieve data from multiple instances on different servers at the same time. Oracle RAC provides the software that allows the servers to work together in what is called a cluster. The physical structures that make up the database must reside on shared storage that is accessible from all servers that are part of the cluster. Each server in the cluster runs the Oracle RAC software. Single-instance Oracle databases have a one-to-one relationship between datafiles and the instance. Oracle RAC environments, however, have a one-to-many relationship between datafiles and instances. In Oracle RAC environments, multiple cluster database instances form a single database. The instances can be on different servers, referred to as hosts or nodes. Each cluster database instance in an Oracle RAC cluster uses its own memory structures and background processes. Oracle RAC uses Cache Fusion to synchronize the data stored in the buffer cache of each cluster database instance. When a data block located in the buffer cache of one instance is required by another instance, Cache Fusion transfers the data block directly between the instances using the interconnect, enabling the Oracle RAC database to access and modify data as if the data resided in a single buffer cache. Oracle RAC uses Oracle ASM (Automatic Storage Management) to manage storage shared between the RAC instances. The Volume groups / Raw partitions of disks can be presented to ASM for creating Data and log file stores. Oracle Application Server 10g Release 10.1.3.3.2 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. -------------------------------------------------------------------------------- For questions about this result, please contact the submitter: Oracle Corporation For other inquiries, please contact SPEC - Benchmark run on Sun Nov 04 18:59:54 PST 2007 by SPECjAppServer2004 v1.08 - Result submitted on Wed Nov 7 03:33:14 EST 2007 - Report generated by SPECjAppServer2004 Reporter v1.03 Copyright (C) 2004 Standard Performance Evaluation Corporation