People use assumptions to make decisions. They do this all the time and insofar, developers are people as well :-) To be a bit more specific, also database developers make assumptions, One of them is for example that… Read More » MaxDB weekend magic - save 50% total storage space!

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?”

Ok, MaxDB is most often used with a NetWeaver on top of it, so this blog is about a niche topic of a niche product. Wow - that should be enough understatement and un-buzzing for now. Read More » MaxDB Optimizer Statistics handling without NetWeaver

One of the most important analytical tools used to investigate slow running SQL statements is the well-known ST05 - SQL trace. The idea of it is that the ABAP database interface notes down what SQL statement it sends to… Read More » MaxDB ST05-trace fallacy - when sometimes the trace is wrong...

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.

It’s been quite a while since my last blog post and we’ve been pretty busy in the primary support department. A major change for us had been the introduction of “Enterprise Support” (ES) and the offer to customers to not… Read More » How to run a SAP landscape (or so)