On 12 Jan 2011, at 09:02, Duncan Garland wrote: > Hi T0m, > > Thanks, that's a very detailed email with a lot of ideas. It'll take a while > to go through all of them. > > You mentioned gdb. We've got a crontab which releases the locked process and > one of the first things we did was to make gdb do a dump before killing the > process. However, we haven't been able to interpret the output properly. I've > attached an example below. It appears to be preparing an SQL statement but it > doesn't give us much idea about which one. > > Have you (or anyone else) got any idea what all this means?
I'd have a look for a stuck query by using whatever tools Oracle gives you to summarise all current queries and see if you can identify any hanging queries there. - Mark _______________________________________________ List: Catalyst@lists.scsys.co.uk Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ Dev site: http://dev.catalyst.perl.org/
