RAC Load Test Plan - Two Nodes

Owned by devtools@ucdavis.edu
Last updated: Jan 24, 2008 by AnonymousVersion comment

Testing RAC performance under load

  • Assumptions:
    • RAC hosts will be hammer and steele

Test 1 (Results)

  • Purpose: To test basic RAC functionality and establish a baseline for comparision
  • DB Configuration
    • Internal Hosts: Hammer/Steele
    • External Hosts: Hammer/Steele
    • Connect Using: LDAP string (jdbc:oracle:thin:@ldap://oraldap1.ucdavis.edu:389/sakai_rac,cn=OracleContext,dc=ucdavis,dc=edu ldap://oraldap2.ucdavis.edu:389/sakai_rac,cn=OracleContext,dc=ucdavis,dc=edu)
    • Internal: Caje(Prod) Snapshot from 12/18 AM.
    • External: SAK-1202 running on a manually managed tablespace.
    • Special Notes: None
  • Sakai Configuration
    • Tag: sakai_2-4-x-HEAD-prod-008 with distauth.patch applied.
    • Servers: braddock.ucdavis.edu
  • Silk Configuration
    • Project: Smartsite-Test RAC
    • Script: SmartsiteViewing.bdf
    • Test Time: 1 hr 15 mins
    • Max Users: 100
    • Workload: Increasing - Starting at 25 increasing 5 users every 15 seconds.
  • Metrics Watched
    • Load on hammer
    • Load on steele
    • Silk Metrics:
      • Transactions OK
      • Average Page Time
      • Requests Sent (Count)
      • Errors
  • Notes: None

Test 2 (Results)

  • Purpose: To test chatting while running on the RAC
  • DB Configuration
    • Internal Hosts: Hammer/Steele
    • External Hosts: Hammer/Steele
    • Connect Using: LDAP string (jdbc:oracle:thin:@ldap://oraldap1.ucdavis.edu:389/sakai_rac,cn=OracleContext,dc=ucdavis,dc=edu ldap://oraldap2.ucdavis.edu:389/sakai_rac,cn=OracleContext,dc=ucdavis,dc=edu)
    • Internal: Unmodified from Test 1
      • Library cache will not be cleared.
    • External: SAK-1202 running on a manually managed tablespace.
    • Special Notes: Chat will be fully turned on and maximized on this test
  • Sakai Configuration
    • Tag: sakai_2-4-x-HEAD-prod-008 with distauth.patch applied.
    • Servers: braddock.ucdavis.edu
  • Silk Configuration
    • Project: Smartsite-Test RAC
    • Script: SmartsiteChat.bdf
    • Test Time: 1 hr 15 mins
    • Max Users: 100
    • Workload: Increasing - Starting at 25 increasing 5 users every 15 seconds.
  • Metrics Watched
    • Load on hammer
    • Load on steele
    • Silk Metrics:
      • Transactions OK
      • Average Page Time
      • Requests Sent (Count)
      • Errors
  • Notes: After this test is over, the database needs to be cleared.