Oracle-Database

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)

Browsing through closed support messages while looking for a possible approach to a certain Oracle CBO problem I came across a quite problematic issue. Some support colleagues sometimes seem to focus too much on removing… Read More » A fix is not a solution!

In my mini-series " Mind the gap" I will try to shed some light on where the little or big differences between MaxDB and Oracle databases are and what to keep in mind when working with them. Read More » ‘Mind the gap…’ (#4 – reading query execution plans)

The default reaction # When working in support you get to see a lot of bugs, mistakes and errors. That’s of course how things are going and there’s not much to whine about. Read More » Now step back and start thinking!

Let’s face it - the really really bad performance issues are usually not due to some weird database bugs. Instead, a wrong system setup or the bad usage of the database prevents a high performance. Read More » Understanding database performance for developers

Before starting with this blog, I’ve to apologize for being so late with this issue of “Mind the Gap”. Since the last part of this series (‘Mind the gap…’ (#3 - Backup/Restore - Part 1) Read More » ‘Mind the gap…’ (#3 – Backup/Restore – Part 2)

Perhaps some of you know the SAP note #825653 Oracle: Common errors in which Martin Frauendorfer collected many “myths” and all-time misconceptions about Oracle databases. Here’s another one: " For all tables in an… Read More » Oracle – Popular Misconceptions: Tables without Segments

A customer was facing a problem when generating SQL scripts by using SQL. As this is a common habit in the Oracle world he tried to apply it to his MaxDB. Read More » Questions to SAP Support: “How to generate a SQL Script via SQL on MaxDB?”

So after a loooong wait time, it’s finally available to be downloaded by the SAP customers. What a relieve! Over is the time where tens of patches needed to be installed to run the database on a supported patch level and… Read More » Oracle Patchset 10.2.0.4 is released – finally.

With release 11g Oracle made many feature enhancements to the database and some of them are now down-ported into the soon-to-be-released patchset 10.2.0.4. One new feature that I just found by ‘accident’ is the easy… Read More » Oracle Patchset 10.2.0.4 – neat DBMS_STATS enhancement