SPECjAppServer2001 Result Oracle9iAS Release 2 on HP rp8400 Cluster Metric: 2,529.10 BOPS@MultipleNode 1,342.74 US$/BOPS@MultipleNode Submitter: Oracle Corporation, SPEC license # 73, Test date: Apr-2003 EJB Container Avail: Jul-2003, EJB Container JVM Avail: Jan-2003 -------------------------------------------------------------------------------- Benchmark Settings -------------------------------------------------------------------------------- Orders Injection Rate: 1475 # of Order Agents: 8 # of Manufacturing Agents: 8 DB Load Injection Rate: 1475 Ramp Up Time: 600 seconds Ramp Down Time: 300 seconds Steady State Time: 1800 seconds Trigger Time: 900 seconds Total System Cost: US$3,395,920 -------------------------------------------------------------------------------- Detailed Results -------------------------------------------------------------------------------- Order Transaction Mix Count Tx. Mix New Order 1,312,964 49.98% Change Order 526,267 20.03% Order Status 525,451 20.00% Customer Status 262,514 9.99% Total # Order Transactions 2,627,196 Total # Manufacturing Transactions 1,925,189 Response Times Average Maximum 90th% Reqd New Order 0.62 14.30 2.00 2.00 Change Order 0.37 7.94 1.10 2.00 Order Status 0.21 6.42 0.60 2.00 Customer Status 0.25 6.42 0.70 2.00 Manufacturing 1.99 23.62 3.75 5.00 Reproducibility Run (BOPS) 2,533.88 -------------------------------------------------------------------------------- Software Descriptions -------------------------------------------------------------------------------- EJB Container Name: Oracle9iAS Release 2, Standard Edition v9.0.2.3 Vendor: Oracle Corporation Available: Jul-2003 Instances: 12 Passed CTS: May-2001 Protocol: ORMI JVM Name: Java (tm) 2 Runtime Environment, Standard Edition, version 1.4.1.01 JVM Vendor: HP JVM Available: Jan-2003 Tuning Information server.xml global-thread-pool min="40" max="40" queue="300" keepAlive="-1" debug="false server.xml taskmanager-granularity="6000000" transaction-config timeout="500000 data-sources.xml stmt-cache-size="100" inactivity-timeout="9000" min-connections="40" max-connections="500 JVM Tuning Information System properties: -Doracle.dms.gate=false JVM command line: -server -Xms3000m -Xmx3000m -Xmn768m -Xoptgc -XX:PermSize=32m -XX:SurvivorRatio=12 -XX:-UseHighResolutionTimer -XX:PrefetchCopyIntervalInBytes=320 -XX:-StackTraceInThrowable -XX:+ForceMmapReserved -XX:SchedulerPriorityRange=SCHED_RTPRIO JVM virtual memory page size set to 64MB using the HP-UX chatr command -------------------------------------------------------------------------------- Supplier Domain Container Name: Oracle9iAS Release 2, Standard Edition v9.0.2.3 Vendor: Oracle Corporation Available: Jun-2003 JVM Name: Java (tm) 2 Runtime Environment, Standard Edition, version 1.4.1.01 JVM Vendor: HP JVM Available: Jan-2003 Tuning Information server.xml global-thread-pool min="50" max="50" queue="200" keepAlive="-1" debug="false server.xml taskmanager-granularity="3000000" transaction-config timeout="500000 data-sources.xml stmt-cache-size="100" inactivity-timeout="9000" min-connections="40" max-connections="500 JVM Tuning Information System properties: -Doracle.dms.gate=false JVM command line: -server -Xms1024m -Xmx1024m -Xmn512m -Xoptgc -XX:PermSize=32m -XX:SurvivorRatio=12 -XX:-UseHighResolutionTimer -XX:PrefetchCopyIntervalInBytes=320 -XX:+ForceMmapReserved -XX:-StackTraceInThrowable -XX:SchedulerPriorityRange=SCHED_RTPRIO JVM virtual memory page size set to 64MB using the HP-UX chatr command -------------------------------------------------------------------------------- Emulator Container Name: Oracle9iAS Release 2, Standard Edition v9.0.2.3 Vendor: Oracle Corporation Available: Jul-2003 JVM Name: Java (tm) 2 Runtime Environment, Standard Edition, version 1.4.1.01 JVM Vendor: HP JVM Available: Jan-2003 Tuning Information server.xml taskmanager-granularity="3000000" transaction-config timeout="500000 JVM Tuning Information System Properties: -Doracle.dms.gate=false JVM command line: -Xoptgc -XX:+ForceMmapReserved -Xms512m -Xmx512m JVM virtual memory page size set to 64MB using the HP-UX chatr command -------------------------------------------------------------------------------- Database Name: Oracle9i Database Release 2, Enterprise Edition v9.2.0.1.0 Vendor: Oracle Corporation Available: May-2002 Tuning Information init.ora parameters for Oracle: compatible=9.0.0.0.0 cursor_space_for_time = TRUE db_cache_size = 2147483648 db_file_multiblock_read_count = 256 db_files = 256 dml_locks = 2000 enqueue_resources = 2000 log_buffer = 33554432 log_checkpoint_interval = 999999999 processes = 2000 open_cursors = 2000 max_rollback_segments = 1000 shared_pool_size = 536870912 transactions = 2000 transactions_per_rollback_segment = 1 parallel_max_servers = 100 undo_management = AUTO undo_retention = 10 undo_suppress_errors = TRUE undo_tablespace = roll_space statistics_level = BASIC trace_enabled = FALSE -------------------------------------------------------------------------------- JDBC Name: Oracle JDBC Driver v9.0.2.1.0 (Type 2) Vendor: Oracle Corporation Available: Sep-2002 Tuning Information stmt-cache-size="100 -------------------------------------------------------------------------------- Other Software Name: Vendor: Available: Tuning Information -------------------------------------------------------------------------------- Hardware Descriptions -------------------------------------------------------------------------------- J2EE Application Server (3 systems) Hardware Vendor: HP Model Name: rp8400 Processor: PA-8700 MHz: 875 # of CPUs: 16 cores, 16 chips, 1 core/chip Memory (MB): 65536 L1 Cache: 750KB(I)+1.5MB(D) L2 Cache: Other Cache: OS Vendor: HP OS Name: HP-UX 11i Disks: 4x73Gb 15K RPM Ultra SCSI Network Interface: 4x1000BaseT Ethernet Other Hardware: # of Systems: 3 H/W Available: Sep-2001 O/S Available: Dec-2000 Notes / Tuning Information Parameters added to /stand/system STRMSGSZ 65535 dbc_max_pct 10 dnlc_hash_locks 512 max_async_ports 1024 max_thread_proc 8192 maxdsiz 0X40000000 maxdsiz_64bit 0X40000000 maxfiles 8192 maxfiles_lim 8192 maxssiz 0X800000 maxssiz_64bit 0X800000 maxswapchunks 4096 maxtsiz 0X4000000 maxtsiz_64bit 0X40000000 maxuprc 8180 maxusers 4096 nkthread 8192 nproc 8192 nstrpty 60 semmni 2048 semmns 2048 semmnu 1024 shmmax 0X10000000 Parameters changed in /etc/rc.config.d/nddconf TRANSPORT_NAME[0]=tcp NDD_NAME[0]=tcp_conn_request_max NDD_VALUE[0]=32768 -------------------------------------------------------------------------------- Database Server (1 system) Hardware Vendor: HP Model Name: Superdome Processor: PA-8700 MHz: 875 # of CPUs: 24 cores, 24 chips, 1 core/chip Memory (MB): 49152 L1 Cache: 750KB(I)+1.5MB(D) L2 Cache: Other Cache: OS Vendor: HP OS Name: HP-UX 11i Disks: 3 VA7410 Disk Arrays (15*36GB drives) Network Interface: 6 1000Base-T Ethernet LANs Other Hardware: (3) V7410 Disk Arrays 15x36Gb hard disk drivers each # of Systems: 1 H/W Available: Sep-2000 O/S Available: Dec-2000 Notes / Tuning Information =Parameters added to /stand/system STRMSGSZ 65535 dbc_max_pct 5 dnlc_hash_locks 512 eqmemsize 128 max_async_ports 1024 max_thread_proc 3000 maxdsiz 2063835136 maxdsiz_64bit 0X40000000 maxfiles 2048 maxfiles_lim 2048 maxssiz 0X800000 maxssiz_64bit 0X800000 maxswapchunks 8192 maxtsiz 0X4000000 maxtsiz_64bit 0X40000000 maxuprc 2048 maxusers 512 msgmnb 65535 msgmni 4096 msgseg 32767 msgssz 128 msgtql 4096 ncallout 16384 ncsize 40000 nfile 20480 nkthread 16384 nproc (4096*4) nstrpty 60 semmni 8192 semmns 8192 semmnu 4096 shmmax 0XEE6B2800 shmmni 1024 swchunk 4096 Parameters changed in /etc/rc.config.d/nddconf TRANSPORT_NAME[0]=tcp NDD_NAME[0]=tcp_conn_request_max NDD_VALUE[0]=32768 -------------------------------------------------------------------------------- Load Driver (1 system) Hardware Vendor: HP Model Name: rp8400 Processor: PA-8700 MHz: 875 # of CPUs: 16 cores, 16 chips, 1 core/chip Memory (MB): 65536 L1 Cache: 750KB(I)+1.5MB(D) L2 Cache: Other Cache: OS Vendor: HP OS Name: HP-UX 11i Disks: 4*73GB Ultra SCSI Network Interface: (1) 1000Base-T Ethernet LAN Other Hardware: # of Systems: 1 H/W Available: Sep-2001 O/S Available: Dec-2000 Notes / Tuning Information JVM Version used: =Java (tm) 2 Runtime Environment, Standard Edition, version 1.4.1.01 JVM arguments used: -Xmx1792m -Xms1792m -Xmn896m -XX:PermSize=64m -XX:PrefetchCopyIntervalInBytes=320 -XX:+ForceMmapReserved -XX:+DisableExplicitGC -XX:-UseHighResolutionTimer -XX:SchedulerPriorityRange=SCHED_RTPRIO -XX:-StackTraceInThrowable Parameters added to /opt/java1.4/jre/lib/security/java.security networkaddress.cache.ttl = 0 JVM virtual memory page size set to 64MB using the HP-UX chatr command -------------------------------------------------------------------------------- Load Driver Master (1 system) Hardware Vendor: HP Model Name: rx5670 Processor: Intel Itanium 2 MHz: 1024 # of CPUs: 4 cores, 4 chips, 1 core/chip Memory (MB): 16384 L1 Cache: 16KB(I)+16KB(D) L2 Cache: 256KB Other Cache: 3MB L3 OS Vendor: HP OS Name: HP-UX 11i Disks: 3*36GB 15K RPM Ultra 60 Network Interface: 1 1000Base-T Ethernet LAN Other Hardware: # of Systems: 1 H/W Available: Jul-2002 O/S Available: Jul-2002 Notes / Tuning Information JVM Version used: =Java (tm) 2 Runtime Environment, Standard Edition, version 1.4.1.01 JVM arguments used: -d64 -Xmx3000m -Xms3000m -Xmn400m -XX:PermSize=32m -XX:PrefetchCopyIntervalInBytes=320 -XX:+ForceMmapReserved -XX:+DisableExplicitGC -XX:-UseHighResolutionTimer -XX:SchedulerPriorityRange=SCHED_RTPRIO -XX:-StackTraceInThrowable -XX:-NoHandoff -XX:-UseBoundThreads Parameters added to /opt/java1.4/jre/lib/security/java.security networkaddress.cache.ttl = 2 JVM virtual memory page size set to 64MB using the HP-UX chatr command -------------------------------------------------------------------------------- Benchmark Modifications -------------------------------------------------------------------------------- Schema Modifications: Scripts to create the DB are included in the FDA Tablespace sizes were increased to support the Injection rate The log sizes were increased to 48000M. The M_Workorder table and its index were partitioned to 53 partitions by hash. Some TABLESPACE sizes were modified for required Injection rate. Table parameters initrans were modified. System managed tablespaces with local extent management were used. Two indexes were created in 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) -------------------------------------------------------------------------------- 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 descriptor All other beans were deployed using locking-mode="pessimistic" in their deployment descriptor A pessimistic locking mode means that all selects (including during finders) are issued with a FOR UPDATE clause -------------------------------------------------------------------------------- Durability Requirement Info: RAID1 disk mirroring was used to ensure durability for the database logs -------------------------------------------------------------------------------- Storage Requirement Info: A 45 minute run at an injection rate of 1475 increased storage by 38.33GB Given a linear scaling extrapolating for an 8-Hour run we get 408.77GB The system is configured with 1620GB which is sufficient for an 8Hr run -------------------------------------------------------------------------------- Argument Passing Semantics: Oracle 9iAS application server uses pass-by-value as required by the EJB specification -------------------------------------------------------------------------------- Other Benchmark Information -------------------------------------------------------------------------------- This submission used the xerces.jar from the SPECjAppServer2001 Kit. The xerces.jar file was copied to the lib directory of the appserver No hardware or software was used to alter basic network routing. Requests were sent to different appservers utilizing DNS round-robin with one of the mid-tier nodes acting as the DNS server DNS round-robin was implemented by using the HP-UX supplied BIND domain-name server The driver used the following jndi.properties java.naming.factory.initial=com.evermind.server.rmi.RMIInitialContextFactory java.naming.provider.url=ormi://main.sjas.perf:24000/SPECjAppServer java.naming.security.principal=admin java.naming.security.credentials=welcome dedicated.rmicontext=true -------------------------------------------------------------------------------- General Notes -------------------------------------------------------------------------------- No errors were reported during the final or reproducibility run -------------------------------------------------------------------------------- For questions about this result, please contact the submitter: Oracle Corporation For other inquiries, please contact SPEC Benchmark run on Mon Apr 21 09:26:10 PDT 2003 by SPECjAppServer2001 v1.12 Result submitted on Wed Apr 30 03:03:01 EDT 2003 Report generated by SPECjAppServer2001 Reporter v1.09 Copyright (C) 2002 Standard Performance Evaluation Corporation