Oracle-Database

Not to long ago I was analyzing a performance issue on a customers system. In the course of this I needed to see some aggregated data, so I opened a transaction where I can put in custom sql and ran it without removing… Read More » A dumb mistake … again and again …

As it seems it has become popular to give his readers a glimpse on the bookshelf like it has been practised by many before me (see here , here or here) I will also reveal what is “behind” me. Literally the books are… Read More » Blogging standard…

For more than ten years now SAP has provided a unified way to administer the Oracle database via the BR*Tools (Backup/Recovery). Wether you like the tools or not (if you read We all hate the BR*TOOLS, don’t we? about it,… Read More » Anybody know OCOPY?

I recently had to handle a case where a big and important system was rendered unusable by database corruptions. Due to some bad luck and faulty procedures, there was no good backup available. Even worse: the corruption… Read More » Verification Speed…

Ok, so your data is gone. You/the report you ran executed a DELETE statement and performed a COMMIT. What to do now? It is the productive system. So there is no place to discuss that it may have been a great idea to test… Read More » Get me my data back! QUICK!

++ 07.03.2011 ++ UPDATE ++ UPDATE ++ UPDATE ++ The mentioned error message had been improved with Oracle 10.2.0.5 (“Things change for the better” or “How I enhanced the Oracle DBMS software”). Thus, the content of this… Read More » Things that happen in support messages that I don’t like… Part II

You won’t believe how often we in support get asked about if SAPDBA is available for use with Oracle 10g. Even more customers tell us, how they dislike the BRTOOLS and want the SAPDBA back. Read More » We all hate the BR*TOOLS, don't we?

In one of my former jobs, I had been in charge of a rather small project tracking tool for the engineering department. As buying equipment and ordering services were two of the duties of these engineers these tasks had… Read More » Suck that data out! Connect from Oracle to MaxDB

Years in database support, endless experience and access to a whole bunch of internal notes and guidelines have enabled me (as well as all DB Supporters in SAP) to repair corrupt databases. This obscure technique is of… Read More » I can repair your corrupt database!

In my last blog entry “Starting off with a classic…” I presented a classic issue that may appear when the database software is upgraded. The problem was that sometimes result sets are delivered to the user in a sorted… Read More » A classic in disguise…