Re: sys and system segments have a lot of extents help...

From: <tedchyn_at_yahoo.com>
Date: Sat, 12 Jun 1999 16:31:53 GMT
Message-ID: <7ju21p$csr$1@nnrp1.deja.com>

In article <3761FC73.D83A53C1_at_synergy-infotech.com>, Anurag Minocha <anurag_at_synergy-infotech.com> wrote:
> Hi ,
>
> when i query my dba_segments view for extent information on sys and
> system segments it shows that lot of segments have extents greater
than
> 5 some even extending to 200. I want to know whether this effects the
> system persormance and if yes how do i defragment the sys and system
> segments.
>
> anurag
>
> reply to
> anurag_at_synergy-infotech.com
>
>

anurag: you can not defragment table on system tablespace like you would for other table. you have to recreate your database and import data which require outage and not possible for some production. Performance wise I would not worry too much about extents and you may have problem where your extents may exceed max_extent. From your description, you block size is > 2k and max_extents is depends on block size.
2k is 150+
4k is 256 +
check this number out.

Ted

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jun 12 1999 - 11:31:53 CDT