Speeding up the control center manager
By Jean-Pierre Dijcks on May 09, 2007
Always good to speed up things in a product. I just applied a few indexes on my repository and it really seems faster in retrieving the details of my jobs. The issue is officially fixed in the 10.2.0.2 patch, but I figured I try this on my own 10.2.0.1 repository and it seems to nicely work...
First of all, make sure you use the Tools --> optimize Repository to refresh statistics (and do this once in a while!).
Now apply the following indexes in the repository:
CREATE INDEX "WC_RT_IDX_AO_OU" ON "WB_RT_AUDIT_OBJECTS" ("OBJECT_UOID");
CREATE INDEX "WC_RT_IDX_AO_PA" ON "WB_RT_AUDIT_OBJECTS"
Works for me...