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: database keeps growing

Re: database keeps growing

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 14 May 2002 21:22:16 +0100
Message-ID: <3ce2ab20$1_2@mk-nntp-1.news.uk.worldonline.com>


"zulijid_at_hotmail.com" <aersdjes_at_hotmail.com> wrote in message news:abm13f$2im$06$2_at_news.t-online.com...
> hi,
>
> our oracle database is growing and growing, but we update only data
>
> every minute it produces new files,
>
> can we delete some of the oldest files like system.dbf ??
>
> why is this crap so slow , our dba told us it is time for a complete
rebuild
> of the database.
>
> oracle says every month the database must be rebuilded for good
performance
>
> progress was much better than oracle
>

By all means; here's the syntax:

sqlplus /nolog
connect / as sysdba
drop user zulijid cascade;
shutdown abort
!rm /databases/$ORACLE_SID/data/*

That should cure the problem.

HTH, Paul Received on Tue May 14 2002 - 15:22:16 CDT

Original text of this message

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