Re: Multiple extents on SYS tables

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Tue, 19 Oct 1999 13:21:10 -0400
Message-ID: <7uiamu$ntm$1@autumn.news.rcn.net>

There is no potential problem and nothing that needs fixing. Oracle changed the database several years ago and there is no longer any need or desire to have only a small number of extents for a table or index.

hth
jerry gitomer

Derek Runstadler wrote in message
<7ufkar$pka$1_at_nnrp1.deja.com>...
>Please see the following report of multiple extents
>for SYS table, cluster, index.
>We are not currently receiving any errors.
>
>Is there a potential problem?
>If so, how do you recommend fixing the situation?
>
>Thank you, Derek
>********************************************************
>Minimum number of Extents = 2
>Printing a flag where Max_Extents - Extents <= 2
>
> Objects with Multiple Extents Page: 1
>
>Owner Name Type Extents Max
>------------- -------------------- ------ ------ ------
>SYS ACCESS$ Table 9 ######
>SYS ARGUMENT$ Table 4 ######

[snip]

>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Oct 19 1999 - 12:21:10 CDT