Re: ** temporary,queue table statistics

  • From: "Connor McDonald" <mcdonald.connor@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 6 Jan 2009 22:08:28 +0900

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"

Other related posts: