OWB performance tips

While looking at some websites to link for the Blog, I found Donna's performance tips (the site is linked now as well). I thought I directly link to that one, since it really is a good summary of practical tips.

http://donnapkelly.pwp.blueyonder.co.uk/OWBPerformanceTips.htm

I'd also wanted to comment on some other things on her website, since we are working hard to fix some of the issues mentioned on the page. One thing around the performance tips, we are adding explain plan and some other performance features into OWB 10.2.0.3 patch to fix some issues people were running into. Also having the plan information directly in the OWB GUI makes life easier (so we hope).

10.2.0.3 is also going to deliver the fixes to the SCD issues that some of you may have seen (and that Donna points out separately). In fact we are also adding hierarchy versioning directly in the tool. All in all quite exciting stuff! Stay tuned for release news on that patch.

Comments:

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