Re: System table 1.3 GB -- full export only 10 MB - what's wrong?

In article <7c14cv$mi4$1_at_news.eunet.ch>,   "devnull" <devnull_at_open.ch> wrote:
> Dear Readers,
>
> I have a system TS which gets larger and larger, on a small server it has
> reached 1.3 GB within a couple of weeks. (I have also USer, Temporary,
> Tools, Rollback etc as seperate TS's)
>
> There is little user data in the DB, and if I do a full export of the DB, it
> is just around 10MB in size which I find reasonable for the stuff thats in
> there.
> - What is the problem,
> - how can I find out why this happens
> - how can I get rid of this problem
>
> Thanks for your help.
>
> Boris Kraft
> Open Systems AG
>
> Please also reply to kraft at open.ch
>

I think we need a little more information to help, but check the following:

Check sys.dba_users to see if anyone besides sys was assigned this tablespace as their temporary tablespace in error.

Check that your rollback segments, other than the system rollback segment, were not built in the system tablespace.

Do you have auditing set on? Auditing can generate a lot of data and sys.aud$ can grow very large very quick.

What object shows in sys.dba_extents as using all the space?

Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 09 1999 - 07:55:34 CST