Re: SYSTEM Tablespace is FULL

Brian Peasland wrote:

>While I agree with all of the other posts that non-Data Dictionary items
>should not be in SYSTEM, and that if auditing is being done that
>SYS.AUD$ should be moved to a different tablespace, I feel that saying
>that SYSTEM is too large is doing a slight injustice to the OP. We have
>no idea what that database is being used for, what applications are
>running against it, and what objects are stored in the database.
>
>It is highly possible for SYSTEM to be 500MB and for it to be that way
>on purpose. I have two rather large instances (1TB and 5TB) with 40,000+
>objects that each have SYSTEM over 500MB. In those cases, it is a large
>number of triggers and stored procs that is causing SYS.SOURCE$ and
>SYS.IDL_UB1$ and the objects cluster to become very large. I don't have
>non-SYS owned objects in SYSTEM and I don't have SYS.AUD$ in SYSTEM
>either.
>
>Quite simply, we'd need to know more about the OP's database. But I
>think that the other advice is a great place to start.
>
>Cheers,
>Brian
>
>Snid wrote:
>
>
>>If auditing is turned on, then it is possible that your
>>
>>SYS.AUD$
>>
>>table is growing and since this is in the SYSTEM tablespace it could be
>>responsible for it's size.
>>
>>"Hari Om" <hari_om_at_hotmail.com> wrote in message
>>news:d1d5ebe4.0309051405.56aca3e5_at_posting.google.com...
>>| I am using Oracle 9.2.0.1 on IBM AIX 5.1L
>>|
>>| My following Tablespaces are 99% full....is it normal...? do I need to
>>| increase manually or is ti done automatically:
>>| ---------------------------------------------------------
>>| TABLESPACE SIZE USED %USED
>>| ---------------------------------------------------------
>>| SYSTEM 400MB 394MB 98
>>| EXAMPLE 138MB 137MB 99
>>| XDB 38MB 37MB 99
>>| ---------------------------------------------------------
>>|
>>| Do you think increasing the above Tablespace will increase the speed
>>| also?
>>|
>>| Any related informaiton is appreciated.
>>|
>>| (Apologize for my ignorance)
>>| THANKS!
>>
>>

I agree which is why I asked the OP to run a query to identify the largest segments. That should answer the question.

BTW: Can't we stop cross-posting this one? It has nothing to do with c.d.o.misc or tools. Lets kill these other threads.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)