Posts

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!

After the tremendous (and very unlikely) success of the first MaxDB: Space oddities blog, I immediately decided: this must be the voice of the market asking for more. So here you get it. # While Oracle DBAs are used to… Read More » MaxDB – Space oddities, take II

MaxDB - Space oddities Recently a customer came up with the assumption that there is space somehow missing from the database. Although he deleted a whole lot of data via archiving the data area was still quite filled up.… Read More » MaxDB: Space oddities

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

You may have already wondered about whether a specific index is sensible or if you can save space by dropping it. For this MaxDB provides statistic information in the INDEXES view. The column INDEXUSED provides the… Read More » MaxDB: Some notes on the INDEX_USED statistic

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)

Unlike Oracle, MaxDB does not have a CONTROLFILE to store the location of its files. Instead, all file locations are stored as common parameters. A quick look at the parameters section of the KNLDIAG reveals this: Read More » Questions to SAP Support: “How to move MaxDB volumes?”

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.