This SQL will say who’s blocking who.
If you are looking for a deadlock, then obviously, you’ll need to find wher a is blocking b and another row where b is blocking a.
select s1.username || ‘@’ || s1.machine
|| ‘ (SID=’ || s1.sid || ‘) is blocking ‘
||s2.username||’@'||s2.machine||’ (SID=’||s2.sid||’)’ AS blocking_status
from v$lock l1, v$session s1, v$lock l2, […]

Posted in Oracle No Comments »

No, not Michael Flatley, the Ferry that was pushed aground at Cleveleys (just above Blackpool). There are more photos which I took with my SLR to come, but here is a quick snap from my Nokia 6300 mobile.

I’ve zoomed, moved, blurred etc to get it to be suitable as my mobile wallpaper. If you steal […]

Posted in Photography No Comments »

As this year is the 50th anniversary of the Munich Air Disaster, United sponsors AIG came up with an idea to emblazen the front of Old Trafford with the last United line up when they faced Red Star Belgrade.
The statue of Sir Matt Busby stands proudly in the middle and the Calypso on the right. […]

Posted in Football, Photography No Comments »

Beetham Tower taken by Doris on her mobile phone. On the phone, it actually makes this look like it’s a drawing. A good picture, but don’t tell her that!

Posted in Photography No Comments »