Speeding up the control center manager

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"
("PARENT_AUDIT_OBJECT_ID");

Works for me...

Comments:

Well it doesn't work for me. :( Using Control Center Manager is very frustrating, and Runtime Audit Browser is useless. Does anybody have a solution that works for everyone?

Posted by mate on May 13, 2007 at 09:59 PM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today