Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: INVALID SYSTEM OBJECTS

Re: INVALID SYSTEM OBJECTS

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 16 Apr 2004 08:17:33 +1000
Message-ID: <407f0a02$0$20085$afc38c87@news.optusnet.com.au>


P. Smith wrote:

> I was moving tables and rebuilding indexes to try to reduce my number of
> extents and try to improve performances.

Sigh.

So you believed a c omplete load of nonsense about the number of extents causing performance problems, and get yourself into deep water as a result.

An excellent demonstration of why propagating myths and hokum about Oracle is not just silly or inconvenient, but downright dangerous at times. And why I tend to get a little stern with those authors that do it, mentioning no names just this once.

The number of extents for an object is largely irrelevant, especially if you're using 8i and using Locally Managed Tablespace. You don't say what version you're running, which is always worth doing when you post here. But it is likely you have corrupted bits of your data dictionary for absolutely no good reason.

Well, I see others have mentioned re-running catalog.sql and catproc.sql   so that will fix that problem up, hopefully.

But in future, try and find out what things *reallly* affect performance before you start waltzing around trying to "improve" things.

Regards
HJR Received on Thu Apr 15 2004 - 17:17:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US