Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: analyzing the system tablespace?
My God! If you've created your own tables in the SYSTEM tablespace, you want your head examined! Big problem!!
Depends what tables they are, of course. But honestly: you really should leave the entire SYSTEM tablespace well alone!! (You *knew* that, I'm sure!!!)
Regards
HJR
-- -------------------------------------------------------------------------- Opinions expressed are my own, and not those of Oracle Corporation Oracle DBA Resources: http://www.geocities.com/howardjr2000 -------------------------------------------------------------------------- <biprad_at_my-deja.com> wrote in message news:8pmhvo$u7n$1_at_nnrp1.deja.com...Received on Thu Sep 14 2000 - 06:21:29 CDT
> 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.