Re: Large System Tablespace ???

From: Adrian J. Shepherd <theshepherds_at_hotmail.com>
Date: 2000/05/24
Message-ID: <VlWW4.1253$%5.66818@wards>#1/1

The size of the SYSTEM tablespace has grown over the years with a default dictionary. It is not uncommon for an 8i database to have a SYSTEM tablespace size of at least 300MB...

"ashwini" <ashwini123_at_my-deja.com> wrote in message news:8gh7jc$o2r$1_at_nnrp1.deja.com...
> I'm a new DBA. I just took over a new database and notice it has a very
> large system tablespace although most objects belong to a single schema.
> Auditing is not turned on, there is little fragmentation, the objects
> seem properly sized and no objects other than the data dictionary are in
> the SYSTEM tablespace. I Realizie this indicates high usage of
> something, Do I need to check a particular related init.ora parameter?
> Which one and why?
>
> Thanks
> Ashwani
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed May 24 2000 - 00:00:00 CDT