Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Extents in SYSTEM tablespace
If you looked at the thrown extents right after a clean install using Oracle's pctincrease settings you'd still see some objects with several thousand extents. You can probably ignore this, or you can edit sql.bsq before you create a database to remove the problems. Starting in 9i Oracle recommends not editing sql.bsq. I've done it in 8 and 8i databases and plan to try it in 9i. It's up to you.
The same objects that started with a lot of thrown extents in 8 and 8i are the ones that show up again in 9i.
Van
"Rick Denoire" <100.17706_at_germanynet.de> wrote in message
news:t2kq0u00j9jg44omnvkcmu8bu8df1avdjf_at_4ax.com...
> Hello!
>
> I took a look at the number of extents in the tablespaces of an Oracle
> DB (8.1.7) and found out that there are several thousand of them.
> Actually, only the TEMP tablespace has more extents.
>
> But this should not be so, since the objects in the SYSTEM tablespace
> are almost never deleted or added. But this is a development DB, so it
> happens that tables are created and deleted quite often. Could this be
> the reason for the high fragmentation in this tablespace?
>
> By the way, which is the best way to get rid of fragmentation?
>
> Thanks
>
> Rick
>
Received on Wed Dec 05 2001 - 16:55:52 CST