Re: analyzing the system tablespace?

From: <biprad_at_my-deja.com>
Date: Wed, 13 Sep 2000 00:32:56 GMT
Message-ID: <8pmhvo$u7n$1@nnrp1.deja.com>

It is not recommended to run the ANALYZE command on data dictionary tables...( for tables on system tablespace i think you mean data dictionary tables.. check the Oracle 8i Sql Reference doc. for Analyze command) If you have created your own tables on system tablespace you can analyze that without any problem

In article <8plsl3$3sv$1_at_nnrp1.deja.com>, kal121_at_my-deja.com wrote:
> Does anyone out there analyze the tables in the system tablespace on a
> regular basis? Seems to me if you are using the CBO, you might as well
> analyze everything. And yet, I hold back.
>
> Any thoughts?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 12 2000 - 19:32:56 CDT