Has anyone experienced an issue whereby upon opening the incident management
console it results in a timeout? I've isolated the query via SQL logs. It
occurs currently when a person belongs to many support groups. The issue
appears to be at a database level (application is running fine).
Any suggestions on Oracle tuning (we've followed BMCs recommendations for
Oracle 11g) I can pass on to our DBAs?
Seems when a person belongs to more than 5 support groups (so the query when
opening support console w/the default of All My Groups results in 10 OR clauses
(checking for Incident owner and Incident Assignee groups) ) the query takes
between 80 and 140 seconds and also causes a full table scan. All fields in
where and order are indexed. We are only dealing with ~ 1 million rows now (we
do archive daily, but need to keep this much data due to business reasons)
We have bandaids around this (use selected groups as default), but this is not
an acceptable long term solution.
Any advice/suggestions for database tuning would be appreciated.
John McEsx
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
