tablespace management

From: rupinder braich <rupinder99_at_hotmail.com>
Date: Sun, 8 Aug 2004 14:04:51 -0400
Message-ID: <iTtRc.470$7S3.170392@wagner.videotron.net>

Hello

I have been using Oracle 8i with tablespace having autoextend set to ON and currently the tablespace is used 97% (checked through DBA studio). I want to know when Oracle will autoextend the tablespace. The database is responding very slowly and could it be one of the reason that tablespace is low?

I also want to know when the oracle is going to extend the size of the tablespace(is it when it reaches 100% full) or should it be little bit earlier? I have also checked the disk space and there is sufficient disk space available to extend the tablespace.

Thanking you in advance.

Rupinder Received on Sun Aug 08 2004 - 13:04:51 CDT