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

Home -> Community -> Usenet -> c.d.o.misc -> ATTN: T.KYTE: Re: Fragmented System Tablespace

ATTN: T.KYTE: Re: Fragmented System Tablespace

From: <nasof_at_hotmail.com>
Date: Tue, 22 Sep 1998 13:29:29 GMT
Message-ID: <6u88no$lof$1@nnrp1.dejanews.com>


Thomas, Let me get your opinion on this...

Any good DBA worth his salt would dream of creating a database without considering how many rows the tables will consume, where to place indexes, what should be the storage parameters for each and every table....

...yet that is exactly what the SYSTEM tablespace does _not_ do. It uses the default storage (which is less than optimal) and places indexes in the same tablespace.

How do you feel about modifying the sql.bsq script to add storage params for several of the larger tables? Any other approaches you have taken?

-Frank

In article <36080fb3.4147353_at_192.86.155.100>,   tkyte_at_us.oracle.com wrote:
> A copy of this was sent to "Michael Krall" <mike_krall_at_email.msn.com>
> (if that email address didn't require changing)
> On Sun, 20 Sep 1998 03:00:45 -0400, you wrote:
>
> >I have a question about the system tablespace. I have 5 or 6 tables with
> >more then 15 extents. Can I export / import the tables within the system
>
> no. it won't matter anyway -- having 1, 100, 1000 extents does not affect
> performance, especially with indexed reads (it may affect performance of a
full
> scan if your extents are not multiples of your multi block read count).
>
> don't do it.
>
> >tablespace without damaging the instance ? If I can would a new analyze of
> >my production data & indexes be in order ?
> >
>
> no -- even if you could do this, reorging a table in the system tablespace
would
> have no affect on the statistics collected on a table in another tablespace
(or
> even another table in the same tablespace).
>
> >Any help would be greatly appreciated.
> >
> >Thanks
> >Michael Krall
> >Senior Systems Engineer
> >Safety 1st
> >mkrall_at_safety1st.com
> >
>
> Thomas Kyte
> tkyte_at_us.oracle.com
> Oracle Government
> Herndon VA
>
> --
> http://govt.us.oracle.com/ -- downloadable utilities
>
> ----------------------------------------------------------------------------
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
>
> Anti-Anti Spam Msg: if you want an answer emailed to you,
> you have to make it easy to get email to you. Any bounced
> email will be treated the same way i treat SPAM-- I delete it.
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 22 1998 - 08:29:29 CDT

Original text of this message

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