Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-16955

performance issue on oracle system

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Won't Fix
    • Affects Version/s: 1.9.2
    • Fix Version/s: None
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Environment:
      oracle 10.2.0.1.0
      Solaris Coolstack
    • Database:
      Oracle
    • Affected Branches:
      MOODLE_19_STABLE

      Description

      we use OCI8 1.2.5 (pecl), because of the curso leak problems in 1.2.4

      BUT we have performance problems, maybe the problem with the cursor leaks again in version 1.2.5.....?!
      suddenly the 4/5 normal sessions (60 users in one minute in moodle) on the database server expand to 700...and we have to start it up again...after half an hour...the webserver processes also rise to this levels...
      when we restart the database, everything wents back to normal...

      is there anything we can do?
      maybe set a timetolive somewhere?
      downgrade to oci8 1.2.3?

        Attachments

          Activity

            People

            Assignee:
            stronk7 Eloy Lafuente (stronk7)
            Reporter:
            protzek D P
            Participants:
            Component watchers:
            Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: