SPECjAppServer2002 Result

Oracle Application Server 10g Standard Edition v9.0.4.0.1 Pre-Release on HP
ProLiant ML370G3
  Metric: 431.26 TOPS@DualNode
          160.62 US$/TOPS@DualNode

Submitter: Oracle Corporation, SPEC license # 73, Test date: Aug-2003
EJB Container Avail: Nov-2003, EJB Container JVM Avail: Jul-2003

--------------------------------------------------------------------------------

                               Benchmark Settings                               
--------------------------------------------------------------------------------
Orders Injection Rate:                       250
# of Order Agents:                             2
# of Manufacturing Agents:                     1
DB Load Injection Rate:                      250
Ramp Up Time:                                600   seconds
Ramp Down Time:                              300   seconds
Steady State Time:                          1800   seconds
Trigger Time:                                100   seconds
Total System Cost:                     US$69,267
--------------------------------------------------------------------------------

                                Detailed Results                                
--------------------------------------------------------------------------------
Order Transaction Mix                      Count   Tx. Mix
  New Order                              225,045    50.05%
  Change Order                            89,847    19.98%
  Order Status                            89,633    19.93%
  Customer Status                         45,150    10.04%
Total # Order Transactions               449,675

Total # Manufacturing Transactions       326,592

Response Times                           Average   Maximum     90th%      Reqd
  New Order                                 0.41      4.07      0.90      2.00
  Change Order                              0.22      2.57      0.50      2.00
  Order Status                              0.12      1.69      0.30      2.00
  Customer Status                           0.12      1.77      0.30      2.00
  Manufacturing                             2.35      7.24      4.00      5.00

Reproducibility Run (TOPS)                432.05
--------------------------------------------------------------------------------

                             Software Descriptions                              
--------------------------------------------------------------------------------
EJB Container
  Name:              Oracle Application Server 10g Standard Edition v9.0.4.0.1 Pre-release
  Vendor:            Oracle Corporation
  Available:         Nov-2003
  Instances:         1
  Passed CTS:        Nov-2003
  Protocol:          ORMI
  JVM Name:          BEA WebLogic JRockit 8.1 SP1 SDK
  JVM Vendor:        BEA Systems, Inc.
  JVM Available:     Jul-2003

Tuning Information
  server.xml global-thread-pool min="21" max="21" queue="100
  keepAlive="-1" debug="false
  server.xml taskmanager-granularity="9000000
  transaction-config timeout="500000
  data-sources.xml stmt-cache-size="100" inactivity-timeout="90000
  System properties:
  -DassociateUsingThirdTable=false -Doracle.dms.sensors=none
  -Doracle.ias.cache=0 -DdefaultBatchSize=15

JVM Tuning Information
  -jrockit -Xms1600M -Xmx1600M
  -Xgc:parallel -Xgcreport -Xgcpause
--------------------------------------------------------------------------------
Supplier Domain Container
  Name:              Oracle Application Server 10g Standard v9.0.4.0.1 Pre-release
  Vendor:            Oracle Corporation
  Available:         Nov-2003
  JVM Name:          BEA WebLogic JRockit 8.1 SP1 SDK
  JVM Vendor:        BEA Systems, Inc.
  JVM Available:     Jul-2003

Tuning Information
  server.xml global-thread-pool min="21" max="21" queue="100
  keepAlive="-1" debug="false
  server.xml taskmanager-granularity="9000000
  transaction-config timeout="500000
  data-sources.xml stmt-cache-size="100" inactivity-timeout="90000
  System properties:
  -DassociateUsingThirdTable=false -Doracle.dms.sensors=none
  -Doracle.ias.cache=0 -DdefaultBatchSize=15

JVM Tuning Information
  -jrockit -Xms135M -Xmx135M
  -Xgc:parallel
--------------------------------------------------------------------------------
Emulator Container
  Name:              Oracle9i Application Server Standard Edition v9.0.2.1
  Vendor:            Oracle Corporation.
  Available:         Nov-2003
  JVM Name:          Java (TM) 2 Runtime Environment, Standard Edition Version 1.4.1_03
  JVM Vendor:        Sun Microsystems, Inc.
  JVM Available:     Jul-2003

Tuning Information
  server.xml global-thread-pool min="20" max="20" queue="50
  keepAlive="-1" debug="false
  data-sources.xml stmt-cache-size="100" inactivity-timeout="90000
  

JVM Tuning Information
  -Xms256m -Xmx256m
--------------------------------------------------------------------------------
Database
  Name:              Oracle9i Database Release 2 Standard Edition v9.2.0.3
  Vendor:            Oracle Corporation
  Available:         Jul-2003

Tuning Information
  init.ora parameters for Oracle:
  compatible=9.0.0.0.0
  cursor_space_for_time = TRUE
  db_cache_size = 900M
  db_file_multiblock_read_count = 128
  db_files = 256
  dml_locks = 600
  enqueue_resources = 2000
  log_buffer = 4194304
  log_checkpoint_interval = 2147483647
  processes = 1000
  open_cursors = 2000
  max_rollback_segments = 1000
  shared_pool_size = 200M
  sessions = 800
  transactions = 800
  transactions_per_rollback_segment = 1
  parallel_max_servers = 100
  undo_management               = AUTO
  undo_retention                = 5
  undo_suppress_errors          = TRUE
  undo_tablespace               = roll_space
  statistics_level = BASIC
  trace_enabled = FALSE
--------------------------------------------------------------------------------
JDBC
  Name:              Oracle JDBC Driver 10.1.0.1.1 (Thin)
  Vendor:            Oracle Corporation
  Available:         Nov-2003

Tuning Information
  stmt-cache-size="100
--------------------------------------------------------------------------------
Other Software
  Name:              
  Vendor:            
  Available:         

Tuning Information
  
--------------------------------------------------------------------------------

                             Hardware Descriptions                              
--------------------------------------------------------------------------------
J2EE Application Server (1 system)
  Hardware Vendor:   Hewlett-Packard
  Model Name:        ProLiant ML370G3
  Processor:         Intel Xeon
  MHz:               3060
  # of CPUs:         2 cores, 2 chips, 1 core/chip
  Memory (MB):       2048
  L1 Cache:          12Kuops(I)+8KB(D)
  L2 Cache:          512KB
  Other Cache:       
  OS Vendor:         Red Hat, Inc.
  OS Name:           Red Hat Enterprise Linux AS 2.1
  Disks:             1x18Gb 15K RPM Ultra-3
  Network Interface: (2) 100BaseT Ethernet
  Other Hardware:    
  # of Systems:      1
  H/W Available:     Aug-2003
  O/S Available:     Aug-2003

Notes / Tuning Information
  
--------------------------------------------------------------------------------
Database Server (1 system)
  Hardware Vendor:   Hewlett-Packard
  Model Name:        HP ProLiant ML370G3
  Processor:         Intel Xeon
  MHz:               3060
  # of CPUs:         2 cores, 2 chips, 1 core/chip
  Memory (MB):       2048
  L1 Cache:          12Kuops(I)+8KB(D)
  L2 Cache:          512K
  Other Cache:       1MB L3
  OS Vendor:         Red Hat, Inc.
  OS Name:           Red Hat Enterprise Linux AS 2.1
  Disks:             5x18Gb 15K RPM Ultra-3
  Network Interface: 100BaseT Ethernet
  Other Hardware:    
  # of Systems:      1
  H/W Available:     Aug-2003
  O/S Available:     Aug-2003

Notes / Tuning Information
  Parameters added to /etc/sysctl.conf
  kernel.sysrq = 0
  kernel.shmmax = 2147483648
  kernel.shmmin = 1
  kernel.shmmni = 100
  kernel.shm-use-bigpages = 1
  In grub.conf: bigpages = 1300M was specified.
  2 X 18GB 15k RPM Ultra 3 RAID 1 for logs
  2 X 18GB 15k RPM Ultra 3 for data
  Both data and log files were on raw partitions.
--------------------------------------------------------------------------------
Load Driver (1 system)
  Hardware Vendor:   Hewlett-Packard
  Model Name:        HP ProLiant ML530G2
  Processor:         Intel Xeon
  MHz:               2800
  # of CPUs:         2 cores, 2 chips, 1 core/chip
  Memory (MB):       8192
  L1 Cache:          12Kuops(I)+8KB(D)
  L2 Cache:          512K
  Other Cache:       
  OS Vendor:         Red Hat Inc.
  OS Name:           Red Hat Enterprise Linux AS 2.1
  Disks:             1x36GB 10k Ultra-3
  Network Interface: 100BaseT Ethernet
  Other Hardware:    
  # of Systems:      1
  H/W Available:     Aug-2003
  O/S Available:     Aug-2003

Notes / Tuning Information
  JVM Version used:
  Java (TM) 2 Runtime Environment, Standard Edition Version 1.4.1_03
  JVM arguments used:
  -Xms400m -Xmx400m -Dsun.net.inetaddr.ttl=0
  -XX:+UseSpinning -XX:PreBlockSpin=100
  -Dnetworkaddress.cache.ttl=0
  Max threads limit was increased to 8K from 1K
  by rebuilding libpthreads.so. The stack size was reduced to
  256K. The following was added to /etc/sysctl.conf
  net.ipv.tcp_max_syn_backlog = 8192
  kernel.sem = 1000 32000 32 512
  fs.file-max = 65535
  kernel.shmmax = 2147483648
  The following was added to /etc/security/limits.conf
  soft nofile 8192
  hard nofile 8192
  Added in /etc/pam.d/login
  session required /lib/security/pam_limits.so
--------------------------------------------------------------------------------

                            Benchmark Modifications                             
--------------------------------------------------------------------------------
Schema Modifications:
  Tablespace sizes were increased to support the Injection rate
  Scripts to create the DB are included in the FDA
  Two indexes were created on the M_largeorder table:
  CREATE UNIQUE INDEX M_lo_idx ON M_largeorder (lo_id)
  CREATE UNIQUE INDEX M_OL_O_idx ON M_largeorder (lo_o_id, lo_ol_id)
  Table and index parameters initrans were modified.
--------------------------------------------------------------------------------
Load Program Modifications:
  The load program was not modified
--------------------------------------------------------------------------------
Reference Bean Modifications:
  No changes were made to the reference beans
--------------------------------------------------------------------------------
                      Benchmark Configuration Information                       
--------------------------------------------------------------------------------
Persistence Mode Used:
  CMP mode was used for all beans
--------------------------------------------------------------------------------
Isolation Requirement Info:
  Beans with a READ_COMMITTED requirement
  were deployed using locking-mode="optimistic" in their deployment descriptors
  All other beans were deployed using locking-mode="pessimistic
--------------------------------------------------------------------------------
Durability Requirement Info:
  Disk mirroring was used to ensure durability for DB logs
--------------------------------------------------------------------------------
Storage Requirement Info:
  A 45 minute run at an injection rate of 250 increased storage by 6GB.
  Extrapolating for an 8 Hr run would require 64GB.
  The system is configured with 90GB which is sufficient for 8Hr run.
--------------------------------------------------------------------------------
Argument Passing Semantics:
  Oracle Application Server 10g uses pass-by-value
  as required by the EJB specification
  
--------------------------------------------------------------------------------

                          Other Benchmark Information                           
--------------------------------------------------------------------------------
  This submission used the xerces.jar from the SPECjAppServer2002 Kit.
  No hardware or software was used to alter basic network routing.
  The driver used the following jndi.properties
  java.naming.factory.initial=com.evermind.server.rmi.RMIInitialContextFactory
  java.naming.provider.url=ormi://172.25.11.20:23777/SPECjAppServer
  java.naming.security.principal=admin
  java.naming.security.credentials=welcome
  dedicated.rmicontext=true
--------------------------------------------------------------------------------

                                 General Notes                                  
--------------------------------------------------------------------------------
 No errors were reported during the final or reproducability run
--------------------------------------------------------------------------------

For questions about this result, please contact the submitter: Oracle
Corporation
For other inquiries, please contact SPEC

Benchmark run on Tue Aug 19 14:08:40 CDT 2003 by SPECjAppServer2002 v1.14
Result submitted on Wed Aug 20 03:03:02 EDT 2003
Report generated by SPECjAppServer2002 Reporter v1.01

Copyright (C) 2002 Standard Performance Evaluation Corporation