Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How long should statspack.snap take to run?
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