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… 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… Read More »Point-in-time-recovery considered harmful
A few months ago, I described how to set up and configure the Windows Debugger in order to be able to generate a call stack… Read More »Debugging the MaxDB Kernel – How to get a Call stack the easy way
Doing the same thing over and over again over a long time usually gives the opportunity to recognize some pattern. One pattern I found in… Read More »How to “win” in SAP customer messages
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… 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… 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:… 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… Read More »‘Mind the gap …’
Today I spoke with Jörg Hoffmeister (Product and Development Manager of MaxDB and liveCache). He told me that finally the “MaxDB Internals” Documentation has been released… Read More »MaxDB Internals Documentation available for free!
Ok, today I’ll show you how to install, setup and use the Windows Debugger to get information about hanging MaxDB kernel tasks. The first thing… Read More »Debugging the MaxDB Kernel on Windows – How to get a Call stack from hanging tasks