Checkpoint Blockage

Greetings, I am searching for suggestions on the best approach to find the resource(s) that are preventing a checkpoint from completing. Occasionally, our 7.31.FC7 instance will be blocked indefinitely during a checkpoint request. The most recent incident did have a thread /session in a critical section. All attempts to remove the offending session failed. This is primarily an OLTP environment with a little bit of DSS mixed in. The work around we used was to bounce online (which we would prefer not to do). FWIW, the session in a critical section at the time of the problem was attempting to build an index on an unlogged temporary table. __________________________________________________ Do You Yahoo!? Get Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/