dbms_stats.gather_database_stats
I can't locate the 8174 docs now that Technet is such a mess, but I recall this package not only analyzes sys/system objects but also collects IO stats. I think it is IO stats collected and not CPU stats. It is one of the other, I'm pretty sure.
Anyway, has anyone played around with gathering database stats in 8174 in order to gather the collected resource stats and then delete stats on the dictionary tables that have been related to bugs and statistics in 8174?
I'm wondering if this might help with accurate costing.
--
- David
> Yep, "bug" is where we're going with it... But we haven't had time yet
> to go into detail.
>
>
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> * Nullius in verba *
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Mon Apr 05 2004 - 13:21:20 CDT
