Rittman Mead - Delivered Intelligence

In part two, I mentioned that large files could take tens of seconds to process and the processing of a file is wrapped into a single transaction that either fails or succeeds. I also said this problem seemed to occur with outlets that typically polled larger files. I did not mention though that stock transactions [...]

I never like finding why a deadlock happens, all too often the solution is embedded in the application code where some error in logic has caused multiple sessions to do things in different orders. The text of the error message provided by Oracle implies “heap all blame at the developers’ door, they are the guilty [...]

Occasionally, just occasionally, I am asked to leave my sane, safe data warehouse world (OK, not many DBAs out there would agree with that) and take a look at some other systems. For the past couple of days I have been looking at ‘deadlock’ problems on a legacy application and to suggest solutions that did [...]

I don’t know if anyone else has come across it yet, but Jonathan Lewis has recorded a podcast for DBAZine. It talks about Jonathan’s new book, the type of work he does as a consultant, how he got into the industry and how he got to the position he is now – basically making sure [...]

Keith Laker from the Oracle Business Intelligence product team dropped me a line this evening, to tell me about a survey the Data Warehouse Development team at Oracle are carrying out. It sounds like a useful and interesting survey and I’ll certainly be taking part. Here’s Keith’s message: "At the start of most data warehouse [...]