-
Incident report
-
Resolution: Unsupported version
-
Minor
-
None
-
2.0.9
-
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?