Bug 535793 (RHQ-2452)
Summary: | SQL Performance investigation | ||
---|---|---|---|
Product: | [Other] RHQ Project | Reporter: | Charles Crouch <ccrouch> |
Component: | No Component | Assignee: | RHQ Project Maintainer <rhq-maint> |
Status: | CLOSED CURRENTRELEASE | QA Contact: | Mike Foley <mfoley> |
Severity: | medium | Docs Contact: | |
Priority: | medium | ||
Version: | 1.2 | CC: | cwelton, dlackey, hbrock, hrupp, jshaughn, mazz |
Target Milestone: | --- | Keywords: | FutureFeature, Task |
Target Release: | --- | ||
Hardware: | All | ||
OS: | All | ||
URL: | http://jira.rhq-project.org/browse/RHQ-2452 | ||
Whiteboard: | |||
Fixed In Version: | Doc Type: | Enhancement | |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2014-05-09 15:59:21 UTC | Type: | --- |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: | |||
Bug Depends On: | |||
Bug Blocks: | 577041, 620933 |
Description
Charles Crouch
2009-10-04 19:06:00 UTC
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-2452 mass move off the qa triage list. These are tasks for dev. Mazz -- what would it take to fix this? Deon -- can/has the workaround been doc'd? I'll check again, but I don't think this has been documented anywhere. I can doc it. I just need some details: 1. When should this be done (i.e., is it a good change for every deployment or only in certain situations?) 2. What's the performance improvement? 3. Is this done at server install or can it be done at any point? 4. What functional areas does this affect? 5. Can this be done using that admin area for uploading sql commands or does this need to be done using Oracle management tools? Heiko has recently done some performance tuning/testing re: DB performance. Since this is a year old, I would suspect the perf tuning he did either already covered this, this was already fixed, or its not a major bottleneck when compared to other parts that he did tune. Perhaps Heiko can provide additional info regarding what he tuned and if these kinds of queries have already been tuned. Oh, if Heiko addressed this already, then I may just add a general "performance was tuned" thing to the release notes. |