See, that's the thing, it doesn't actually detect or do anything about the deadlock, something which I thought Oracle was capable of (maybe it isn't a deadlock? why else would it just "hang" there?)
So the last things in the log are an error saying "Starting Loop" and the database informing me that the cal_club_map_inserts is being run and what the two bind variables are. Then it just stops. No one else can connect to the server until it is restarted.
Thanks.
