SPEC Seal of Reviewal SPECjAppServer®2004 Result
Copyright © 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
Software Products
Oracle Application Server 10g Release 10.1.3.3.2 - Java Edition
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0.08) 32 bit
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0.08) 64 bit
Oracle JDBC Driver 10.2.0.3 (Thin)
Oracle Database 10g Enterprise Edition Release 10.2.0.3 with Oracle Real Application Clusters Option and patch 5500535
Software Configurations
J2EE Application Servers
Emulator SW Config
Database SW Config - RAC Node 1
Database SW Config - RAC Node 2
Driver SW Config Primary and Satellites
Hardware Systems
J2EE AppServer HW (SUT hardware)
Database Server HW (SUT hardware)
Primary Load Driver and Satellite Drivers
Emulator HW
DNS Load Balancer Hardware (SUT hardware)

System Configuration Diagram

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

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 seconds
# of Dealer Agents: 138   Ramp Down Time: 300 seconds
# of Manufacturing Agents: 48   Steady State Time: 3,600 seconds
DB Load Injection Rate: 6,000   Trigger Time: 1,800 seconds

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

Oracle Application Server 10g Release 10.1.3.3.2 - Java Edition
Vendor: Oracle Corporation Availability: Feb-2008
CTS Version: 1.4 Date Passed CTS: Jan-2006
OS Name: HP-UX 11i v3 Sept 2007
EJB Protocol: ORMI

Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0.08) 32 bit
Vendor: HP Availability: 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: May-2007
OS Name: HP-UX 11i v2

Oracle JDBC Driver 10.2.0.3 (Thin)
Vendor: Oracle Corporation Availability: 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: Feb-2007
OS Name: HP-UX 11i v3

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

J2EE AppServer HW (SUT hardware) (SUT hardware)
Hardware Vendor: HP OS Vendor: HP
Model Name: HP BL860c OS Name: HP-UX 11i v3 Sept 2007
Processor: Dual-core Intel Itanium 9100 Filesystem: vxfs
MHz: 1667 Disks: see notes
# of CPUs: 4 cores, 2 chips, 2 cores/chip Network Interface: (2) HP PCI-X 1000Mbps Dual-port Built-in
Memory (MB): 24545 Other Hardware: (1) HP 4Gb Dual Port PCIe Fibre Channel Mezzanine
L1 Cache: 16KB(I)+16KB(D) # of Systems: 11
L2 Cache: 1024KB(I)+256KB(D) H/W Available: Oct-2007
Other Cache: 9216KB (L3 Cache) OS 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 OS Vendor: HP
Model Name: Superdome OS Name: HP-UX 11i v3
Processor: Dual-core Intel Itanium 9000 Filesystem: vxfs
MHz: 1600 Disks: 4x36Gb 15K RPM U320
# of CPUs: 40 cores, 20 chips, 2 cores/chip Network Interface: (4) HP PCI/PCI-X 1000Base-T Dual-port Adapter
Memory (MB): 163512 Other Hardware: See notes
L1 Cache: 16KB(I)+16KB(D) # of Systems: 2
L2 Cache: 1024KB(I)+256KB(D) H/W Available: Sep-2006
Other Cache: 12MB (L3 Cache) OS 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 OS Vendor: HP
Model Name: Superdome OS Name: HP-UX 11i v3
Processor: Intel Itanium 9000 Filesystem: vxfs
MHz: 1600 Disks: 1x73Gb 15K RPM U320
# of CPUs: 16 cores, 8 chips, 2 cores/chip Network Interface: (3) HP PCI/PCI-X 1000Base-T Dual-port Adapter
Memory (MB): 130940 Other Hardware: null
L1 Cache: 16KB(I)+16KB(D) # of Systems: 6
L2 Cache: 256KB H/W Available: Sep-2006
Other Cache: 12MB (L3 Cache) OS 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 OS Vendor: HP
Model Name: rx8640 OS Name: HP-UX 11i v2
Processor: Intel Itanium 9000 Filesystem: vxfs
MHz: 1600 Disks: 1x73Gb 15K RPM U320
# of CPUs: 32 cores, 16 chips, 2 cores/chip Network Interface: (3) HP PCI/PCI-X 1000Base-T Dual-port Adapter
Memory (MB): 261882 Other Hardware: null
L1 Cache: 16KB(I)+16KB(D) # of Systems: 1
L2 Cache: 256KB H/W Available: Sep-2006
Other Cache: 12MB (L3 Cache) OS 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 OS Vendor: HP
Model Name: rx3600 OS Name: HP-UX 11i v3
Processor: Intel Itanium 9000 Filesystem: vxfs
MHz: 1600 Disks: 1x73Gb 15K RPM U320
# of CPUs: 4 cores, 2 chips, 2 cores/chip Network Interface: (1) HP PCI/PCI-X 1000Base-T Dual-port Adapter
Memory (MB): 32768 Other Hardware: null
L1 Cache: 16KB(I)+16KB(D) # of Systems: 1
L2 Cache: 256KB H/W Available: Sep-2006
Other Cache: 9216KB (L3 Cache) OS 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 webmaster@spec.org

Copyright © 2004 Standard Performance Evaluation Corporation

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