Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i - defrag SYSTEM tablespace how?
Hi.
It's very nice to advice "change bsq file", but my tech support said that Oracle can not be responsible for my db if ANYTHING happens afterward.
Michael.
In article <mmf54sc7mfgjvllbu1qoliddgt78ik4r0s_at_4ax.com>,
tkyte_at_us.oracle.com wrote:
> A copy of this was sent to "Alex Andr." <deep_at_uqcd.poltava.ua>
> (if that email address didn't require changing)
> On Mon, 29 Nov 1999 17:24:03 +0200, you wrote:
>
> >Hello!
> >I install new Oracle 8i database and import my previous data from
dump.
> >My DB has more user Packages, Procedures and Functions. Throught,
after
> >import I saw that view dba_sources has 60 segments. I enlarge initial
> >segment for tablespace SYSTEM before import but nothing change.
> >What can I do? How import without large fragmentation SYSTEM
tablespace?
> >
>
> don't worry about it. It is *ok* to have extents in system (and in
fact most
> every tablespace). My source$ table has 511 extents -- and it is not
a
> performance issue.
>
> If it really bothers you, edit your sql.bsq file and change the
definition for
> source$. Most all data dictionary objects have initial and next
extents defined
> at the object level and ignore the tablespace settings.
>
> >Thank you very much for answers.
> >Alexander.
>
> --
> See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to
Oracle8i'...
> Current article is "Part I of V, Autonomous Transactions" updated
June 21'st
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle
Corporation
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Nov 29 1999 - 14:19:30 CST