As far as I can remember, system statistics is quite meaningless on 8i and DBMS_STATS is
quite primitive, too. It cannot even run in parallel if you use DBMS_STATS.GATHER_DATABASE_STATS.
You should really look at Metalink note 149560.1, which gives you details about system statistics.
On 03/10/2004 09:52:24 AM, thump604_at_comcast.net wrote:
> Does this discussion in terms of taking system stats only apply to 9i?
> I see that in 8i IO stats are collected and in 9i CPU stats were added.
> All the info I have seen though infers this is new functionality for 9i and does'nt go into any detail on 8i.
> Has anyone had any success with taking system stats in 8i?
>
> Thanks
> --
> - David
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
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 Wed Mar 10 2004 - 09:22:34 CST
