Welcome to the problem As usual understanding, the meaning and the scope of the question is key for the answer to this question, recently filed by a customer. So, what is the customer complaining about? What does he mean… Read More » Question to SAP Support “Why is partition pruning not working in my BW on Oracle?”

Unexpected Behavior # Last week during an Oracle workshop with my primary support colleagues in the GSC Ireland I came across something new (at least to me). This alone is not worthy of writing even a short note, as it… Read More » “Things change for the better” or “How I enhanced the Oracle DBMS software”

Lately, I’ve been confronted with several customer messages concerning problems with Infocube compression, change runs or roll-ups. For some reason, these standard BW actions, that worked the day before, now started to… Read More » BW/DB Support 101 – Get to know your failing SQL statement

For many BW performance relevant DB-features, it’s really all about the details of usage and implementation when it’s about the effect of those features. The following are two examples of rather small things that went… Read More » Small changes with big effects

Ok, once again reproducing a problem takes a lot of (waiting-)time for the query to finish. In the meantime I can also just write a super-short-blog post about a pretty common BW-on-Oracle performance hunch:… Read More » BW on Oracle: a performance hunch I see more and more often…

In the second week working in BW support, I noticed that there was a problem reported by customers again and again. The customers complained about “database statistics update fails in process chains” or “brconnect run… Read More » A first (BW) issue…

As some of you might have noticed, I haven’t been too active in the DB/OS forums lately. This is because I moved on to a new support team and a new subject for me back in September. Yes, I took the giant leap and moved… Read More » New shores in sight…

Today I re-learned a nice option to overcome ORA-60 problems with parallel data loading scenarios. As most of you will know (from reading note “84348 - Oracle-Deadlocks, ORA-00060” or Michael Braunstein’s Blogs Chasing… Read More » Quick help for ORA-60 deadlock in BW systems

Working in support provides the opportunity to witness the behaviour of individuals and organisations in the face of failure. Systems stop working, processes break down, money gets lost. As many companies today have… Read More » Designed to dissappoint

Of course, you look at the other players in your industry, right? You want to know what they are doing and how they do it, right? Maybe you could learn a thing or two as well. Read More » Wait a minute – why don’t we have that?