System Configuration Diagram

  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 and M_WORKORDER 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_locks.sh script.

   The load program was not modified.

  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.

  Data and redo logs were written to RAID 1 volume to provide durability.
  The application servers have pair of mirrored disks (using ZFS) to provide
  durability for server logs and JMS persistence filestore.

  A 80 min run at Injection Rate of 1120 increased storage by
  2.8 GB. This extrapolates to 50.4 GB for 24 hours. The system
  is configured with over 820.0 GB of durable storage.

  Oracle Application Server 10g uses pass-by-value as required by the EJB
  specification.

Supplier        Description                                     Product No.             Qty
--------        ----------------------------------------        ------------------      ---
Sun             Sun Fire T2000, 1x1.4 GHz T1,64GB,2x73GB drives T20Z108C-64GA2D         2
Sun             Solaris 10 11/06 Media KIT                      SOLZ9-10FC9A7M          1
Sun             SunSpectrum Upgrade: 3Y GOLD, 24x7              W9D-T2000-8-24-3G       2
Sun             QLogic QLA2342-SUN PCI/PCI-X                    375-3363                1
Sun             17" Entry Color Monitor                         X7147A                  1
Sun             PS/2 Keyboard & Mouse                           320-1261                1
Sun             73-GB 10000 RPM 2.5 inch SAS Disk Drive         XRA-SS2CD-73G10KZ       2
Sun             Sun Fire X4600 M2, 32GB, 8x 2.8Ghz dual-core    
                AMD Opteron, 2x146GB drives                     A67-HPZ8-8H-032LB1      1
Sun             SunSpectrum Upgrade: 3Y GOLD, 24x7              W9G-A67-8-24-3G         1
Sun             Solaris 10 8/07 Media KIT                       SOLZ9-10HC9A7M          1
Sun             Sun StorageTek 3510, 12 x 146GB, 1 RAID         XTA3510R01A1R1752Z      1
Sun             SunSpectum Upgrade: 3Y GOLD, 24x7               W9D-SE3510-24-3G        1
Sun             Sun StorageTek 6140 array, 2 * 1GB-cache memory FC RAID Controller cards,    
                5x 73GB 15Krpm 4Gb FC-AL Drives                 XTB6140R11A2B365Z       1
Sun             SunSpectum Upgrade: 3Y GOLD, 24x7               W9D-ST6140-2-24-3G      1
Oracle          Oracle Database 10g Release 2 Enterprise Edition, Per Processor         8*
                (v10.2)                                                                    
Oracle          Partitioning, Per Processor,  Unlimited users for 3 years               8*        
Oracle          Oracle Database Server Support Package for 3 years                      1
                (Incident Server Support) 24x7x4                                        
Oracle          Oracle Application Server 10g Release 10.1.3.2,                         12**
                Java Edition, Per Processor                                             
                (v10.1)
Oracle          Oracle Application Server Support Package for 3 years                   2       
                (Incident Server Support) 24x7x4 

(* 8 = 0.50 * 16).  Explanation:  For the purposes of counting the number of
processors which require licensing, an AMD multicore chip with "n" cores
shall be determined by multiplying "n" cores by a factor of 0.50).

(** 12 = 0.75 * 16).  Explanation:  For the purposes of counting the number of 
processors which require licensing, a multicore chip with "n" cores shall be 
determined by multiplying "n" cores by a factor of .75).

  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 the Appservers 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://ecapps:23791/SPECjAppServer
  java.naming.security.principal=oc4jadmin
  java.naming.security.credentials=welcome
  oracle.j2ee.rmi.loadBalance=lookup

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 Application Server 10g Release 10.1.3.2 implements Recoverable Last
Resource Commit (RLRC) 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.

In conjunction with the RLRC implementation, the log-file location specified in the
transaction-manager.xml identifies the location where  the participating resource
managers are recorded. The commit record table name associated with an instance is
specified in the commit-record-table-name attribute, in the Connection-Factory
element of data-sources.xml.