Activity Monitor usually tells you what resource it is waiting for. For example another process maybe trying to do massive select or update on the same tables.