Presumably you've got a dequeue process running, so the queue tables would typically be empty or very close to it ? In such a case, you could set the stats accordingly... hth Connor On Thu, Jan 1, 2009 at 10:14 AM, A Joshi <ajoshi977@xxxxxxxxx> wrote: > Martin/Daniel, > Thanks. The version is 10G. Any suggestion for Queue tables? Thanks -- Connor McDonald =========================== email: connor_mcdonald@xxxxxxxxx web: http://www.oracledba.co.uk "Semper in excremento, sole profundum qui variat"