Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How long should statspack.snap take to run?

Re: How long should statspack.snap take to run?

From: Jining Han <jining.han_at_gmail.com>
Date: 17 Jul 2006 09:44:05 -0700
Message-ID: <1153154645.685710.316180@35g2000cwc.googlegroups.com>


Don't know if your original question was answered. 15 minutes is definitely very long, and it may have everything to do with disabling the PK key (the same bug has occurred to me).

Creating an index may be a good idea, but I am not sure about gathering stats on the PERFSTAT schema/object(s). STATSPACK seems to have been designed to use RBO.

It got so bad for me one time I deleted the dups from STATS$SQL_SUMMARY and re-enabled the PK. Received on Mon Jul 17 2006 - 11:44:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US