/
RAC Load Test Plan - Two Nodes

RAC Load Test Plan - Two Nodes

Jan 24, 2008

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.