Re: Need DBA's help

While it's a little too late in this case, here's something for next time. When Oracle creates a database for you it sets the pctincrease in the System tablespace to 50%. That means that most SYS objects aren't going to throw a lot of extents. However, many people creating their own databases set the pctincrease for their tablespaces to 0% or 1%. If you do that for the System tablespace as well as your others, it won't be unusual to see SYS objects with hundreds or even thousands of extents.

Van

"Yong Huang" <yhuang_at_indigopool.com> wrote in message news:8qgdas$gu$1_at_news.sinet.slb.com...
> As another poster says, don't mess with anything in the SYS schema except
> under the instruction of Oracle support. The only thing Oracle authorizes
 a
> user to touch in SYS is the audit$ table.
>
> According to Jonathan Lewis, sort key too long is caused by "the sum of
 the
> maximum sizes of the columns in the indexes is greater than approx 1/3 of
> the Oracle block size". But since this is in SYS, don't do anything unless
> you just want to learn Oracle internals on a test instance.
>
> Yong Huang
> yhuang_at_indigopool.com
>
> Violin <violin.hsiao_at_mail.pouchen.com.tw> wrote in message
> news:39cad895.3810048_at_172.16.7.5...
> > I try to issue ALTER INDEX xxx REBUILD command for each index.
> > After rebuilded successfully,I select dba_extents again and each index
> > is less than 20 extents.
> > Almost every index rebuilds successfully except for SYS.I_SOURCE1
> > when i tried to :
> > ALTER INDEX SYS.I_SOURCE1 REBUILD
> >
> > An error happens :
> >
> > ORA-01467 : sort key too long
>
>
>
Received on Fri Sep 22 2000 - 17:46:04 CDT