Hunting Deadlocks part 3

Tuesday, February 28th, 2006 by Peter Scott

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 [...]

Hunting deadlocks part 2

Tuesday, February 28th, 2006 by Peter Scott

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 [...]

Hunting deadlocks (part 1)

Tuesday, February 28th, 2006 by Peter Scott

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 [...]

Jonathan Lewis Podcast for DBAZine

Sunday, February 26th, 2006 by Mark Rittman

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 [...]

Data Warehouses: How Does Yours Compare? Here’s how to find out!

Wednesday, February 22nd, 2006 by Mark Rittman

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 [...]

Website Design & Build: tymedia.co.uk