Re: tablespace

From: Martin Hepworth <maxsec_at_totalise.co.uk>
Date: Thu, 16 Sep 1999 11:55:40 +0100
Message-ID: <37E0CCAC.20EB1826@totalise.co.uk>

Ingvild Tvedte wrote:
>
> My head isn't with me today... The SYSTEM tablespace contains 400 MB and
> the disk-space is set to 2 G...
>
> Alex Hudghton wrote:
>
> > Ingvild Tvedte <ingvild_at_razorfish.no> wrote in message
> > news:37E0BA34.FDF79D92_at_razorfish.no...
> > > Why is there a red line indicating that my SYSTEM tablespace is full
> > > when the disk-space is set to 2 G and the tablespace only contains
> > > 400000 MB?
> >
> > 400,000 MB is 400GB ??
> >
> > Alex

Ingvild

yes.....put unless you specified 'autogrow' on the system tablespace (bad idea) when you created it won;t use any unised disk space.

A couple of pointers
1) its a bad idea from a performance pointer of view to use 'system' for storing your application data.
2) red-lines in EM are not a good pointer to resource usage - have a look at the numbers instead.

Martin Received on Thu Sep 16 1999 - 05:55:40 CDT