Slow queries using IT Services with oracle database.

XMLWordPrintable

    • Type: Incident report
    • Resolution: Unsupported version
    • Priority: Minor
    • None
    • Affects Version/s: 2.0.9
    • Component/s: Frontend (F), Server (S)
    • Environment:
      2x Intel(R) Xeon(R) CPU E7540 @ 2.00GHz
      4GB RAM
      VMWare machine
      OCI8 Version => 2.0.6
      Red Hat Enterprise Linux Server release 6.4 (Santiago)

      Oracle Database 10g Enterprise Edition Release 10.2.0.4.0

      Our scenario involves 171 boolean triggers, who are configured as a IT Service, when we display the tab:

      Monitoring -->IT Services, (srv_status.php) (last 365 days selected)

      It creates a query who takes aprox 80seconds.

      SELECT * FROM service_alarms sa WHERE sa.serviceid BETWEEN '2145' AND '2423' AND (sa.clock BETWEEN '1358252351' AND '1389788351') ORDER BY sa.clock,sa.servicealarmid

      oci8.default_prefetch is set to 100000.

      Using a mysql backend (same hardware scenario) takes aprox 20 seconds.

      It's seems a problem between oci8 and oracle10g

      Are you aware of this?
      Are we missing something?

            Assignee:
            Unassigned
            Reporter:
            Fernando Collado Permuy
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: