Extents in SYSTEM tablespace 
Author Message
 Extents in SYSTEM tablespace

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



Sun, 23 May 2004 06:45:14 GMT
 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


Quote:
> 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



Mon, 24 May 2004 06:55:52 GMT
 Extents in SYSTEM tablespace

Quote:

>    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.

why?  do you notice any increased performance or benefits?

Quote:
>    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



>> 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

--

Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp


Mon, 24 May 2004 19:54:44 GMT
 Extents in SYSTEM tablespace

There is the ol' Steve Adams argument about cluster chaining, but I've never
done any benchmarking - one would imagine (given a dictionary cache) that
its at the esoteric end of the performance spectrum.

Cheers
Connor


Quote:

> >    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.

> why?  do you notice any increased performance or benefits?

> >    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



> >> 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

> --

> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp



Tue, 25 May 2004 07:01:46 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Unable to create Extents in Tablespace system

2. system tablespace extent sizes

3. system tablespace extents question

4. moving tables from the system tablespace to a new tablespace

5. locally managed tablespace / number of extents

6. ORA-01658: unable to create INITIAL extent for segment in tablespace

7. Very URGENT! Tablespace Extent Problem w/ Import

8. Unable to create INITIAL extent for segment in tablespace

9. local extent tablespace

10. A tablespace with 400,000 free extents

11. ORA-01658: unable to create INITIAL extent for segment in tablespace

12. Temp tablespace Initial extent question


 
Powered by phpBB® Forum Software