kpipeg wrote:
> Hi folks,
>
> Before start, I am a Unix admin but one month ago Iīve received an
> open runing production Oracle DB - 9.2 to take care off ;-)
>
> Well, Iīve seen that the SYSTEM tablespace is at 98%.
> It is configured AUTOEXTEND and the AUD$ table is empty (although
> allocated in SYSTEM). There arenīt any objects apart of those
> generated by installation.
> The current tablespace syze is 310MB
>
> Is it better to add a file or just leave it as it is?
> Would this produce poor db performance?
> Is there any avrge size for the System tablespace? Our db is not so
> big +- 100GB
>
> BTW - We have a rollback segment in the system tablespace but we are
> using the UNDOTB - and in my understanding shouldnīt affect.
>
> Thanks in advance,
>
> K PIPE G
Is the SYSTEM tbs _actually_ filling up, or has it been sized to allow
only a bit of extra room? If the latter, then I'd not worry about it. If
the former, look around to see what is being created there that probably
shouldn't be.
Received on Mon Jul 05 2004 - 13:38:11 CDT
