Page Comparison

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.