Oracle-Database

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…’ (#3 – Backup/Restore – Part 1)

Today I got a support message to work on that I believe is of rather broad interest. Therefore, I decided to “forward” it to the SDN so that all community members can benefit from it. Read More » Questions to SAP Support: Is ODBC access to the database a good idea?

When faced with error messages like ORA-1578 Oracle database users just got the task to handle a database block corruption. I’ve already written about this topic before and today I’d like to share some tips and tricks to… Read More » Some hints to make handling of oracle datablock corruptions more efficient

I have written some lines about database corruption and the ways to handle them in the past. The bottom line of everything I wrote (including support notes, SDN blogs, and replies in customer messages) has always been: Read More » Not my fault – whose then?

Primary key constraints in Oracle are enforced by using an index. The index does not need to be a unique index, but it has to be possible for the database to look into it and find out if a given key is already present or… Read More » How to take care of index corruptions in primary key indexes.

When I first got in contact to the possibility to bring back a database to the state it had, when a backup was taken I was not too much impressed. Read More » Point-in-time-recovery considered harmful

More and more customers decide to use MaxDB and with that, the number of customers asking for a comprehensive list of differences or a comparison increases as well. In my mini-series " Mind the gap" I will try to shed… Read More » ‘Mind the gap…’ (#2 – Data storage)

Database performance problems are one of the more complex tasks that brighten the day of a database software supporter. Each and every single day since I’m doing support for Oracle and MaxDB there had been messages, in… Read More » Parameters. parameters, parameters … the mantra of db performance troubleshooting

Recently two customers reported independent from each other that their LMTS/ASSM tablespace shows much “fragmentation”. What they meant was, that the repeatedly got errors like: ORA-1688: unable to extend table… Read More » Fragmentation in Oracle LMTS tablespace!

More and more customers decide to use MaxDB and with that, the number of customers asking for a comprehensive list of differences or a comparison increases as well. In my mini-series " Mind the gap" I will try to shed… Read More » ‘Mind the gap …’