if you're on 10gr2, there is no need for statspack, use awr instead.
rgds
Guys,
I have been researching this. I upgraded and after the upgrade some of the IXORA views (i.e. X$..) showed up as invalid. I found a note and other documentation from Dennis Williams and others that states you should drop the views - except - the X_$KSQST view used by statspack. Can I just drop that view and does it get recreated when I recreate statspack?
Thanks, Paula
------------------------------ All-new Yahoo! Mail <http://us.rd.yahoo.com/evt=43256/*http://advision.webevents.yahoo.com/mailbeta>- Fire up a more powerful email and get things done faster.