Re: Reorganize System Tablespace

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<konpnuchc076lkevpdjvkrrcnngeu5kprd_at_4ax.com>...
> On 9 Sep 2002 02:08:21 -0700, ashok_jayaraman_at_yahoo.com (Jayaraman
> Ashok) wrote:
>
> >Hi
> >The database is running on Oracle 8.1.6.3.0 on AIX 4.3.3. Whe i query
> >on any dba* views it takes more than 30 minutes or so to get the
> >result and sometimes it just hangs. Oracle says it is due to smon
> >hanging from time to time and suggested using oradebug utility to dump
> >the
> >process(i think it spawns a new smon automatically and kills the hung
> >process). After this all my queries on dba* views are
> >better. I have just taken over this database which runs 11i and the
> >pctincrease for system tablespace is 100 and the size
> >of it is around 4.3 GB. I was horrified and i thought the first job
> >for me will be to reorganize this. KIndly give your inputs. Some
> >tablespaces are dictionary managed but most are LMTs.Will the
> >following have performance impact? In case i have to rebuild these
> >objects which is the best method?
> >
> >SUBSTR(SEGMENT_NAME,1,20) EXTENTS
> >---------------------------------------- ----------
> >SOURCE$ 4572
> >IDL_UB1$ 5179
> >IDL_UB2$ 3370
> >I_SOURCE1 2166
> >
> >
> >Cheers,
> >Ashok
>
>
> There is only one way to reorganize the system tablespace
> 1 full database export
> 2 recreate the database
> 3 full database import
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Ashok, did support ask you to check to see if the base tables had been analyzed? If not then you may want to check to make sure no one did this; if you find statistics on the base tables then remove them and see if things improve.

If support has identifed a known bug that you did not post then what did they say about upgrading?

HTH -- Mark D Powell -- Received on Mon Sep 09 2002 - 20:43:40 CDT