Re: analyzing the system tablespace?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 13 Sep 2000 08:27:47 +0200
Message-ID: <968826357.1045.2.pluto.d4ee154e@news.demon.nl>

But then of course, you should *never ever* create your own tables in the system tablespace, as that tablespace will become badly fragmented, and there will be competing for resources. So please don't post such a recommendation.

Regards,

Sybrand Bakker, Oracle DBA

<biprad_at_my-deja.com> wrote in message news:8pmhvo$u7n$1_at_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 Wed Sep 13 2000 - 01:27:47 CDT