Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: System tablespace 97 % full

Re: System tablespace 97 % full

From: Anthony Hogan <ahogan-nospam-_at_iespana.es>
Date: Tue, 18 Jun 2002 08:29:56 +0000
Message-ID: <3D0EEF84.761F6740@iespana.es> 





Empty it??? The SYSTEM tablespace contains the data dictionary tables
for the entire database. 



Extend the datafile or (preferably) add another.



Anthony Hogan



Jerome B wrote:


> 

> Hi all,

> 

> The SYSTEM tablespace of a 8i DB is full at 97 %

> 

> Could it be the reason why Oracle take up to 99% CPU ? (more disk swapping

> because of less disk space ?)

> 

> How could I empty it ?

> 

> my configuration is Oracle 8.1.7 on Dell P4/W2KPro

Received on Tue Jun 18 2002 - 03:29:56 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US