Oracle-Database

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

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?

Last week I edited note 23345 and after some additional administrative tasks, it had been released yesterday with version 61. Why do I tell you this and why do I write a blog about this? Read More » Note 23345 revised – so what?

Hi folks! Sorry for missing out the last days. The training had been tough, going out afterwards even tougher ;-) and as soon as the training was over, real-life support work set in again. Therefore all I can provide… Read More » Oracle 11g training, Day #3 and #4 -FLASHBACK!

Ok, second day Oracle 11g training - what have we done today? Basically, two topics were addressed: SECUREFILES and TABLE COMPRESSION SECUREFILES # Securefiles is (no not the new black) but the new LOB implementation for… Read More » Oracle 11g training, Day #2 – Savepoint!

Ok, management wisely decided to afford the Oracle 11g training for me and my primary support colleagues (thanks, thanks, thanks!), so this week we find ourselves sitting in a meeting room with Juergen Kirschner (yes,… Read More » Oracle 11g training, Day #1 – Savepoint!

Sometimes support messages have to go a rather long way to finally get a solution. The following problem came up in a support message recently and since neither the analysis steps nor the solution were obvious, I decided… Read More » SAP Support Case “Why is Oracle writing out so many archivelogs in my BI recently?”

Recently a colleague asked me about how to analyze the following short dump: Database error text........: "ORA-01007: variable not in select list" Database error code........: 1007 Triggering SQL statement...: "FETCH… Read More » ORA-01007 in ABAP stack and what to do about it.