Re: database keeps growing

this is a ugly problem

in our company we have shellscripts which extract the database and does a complete rebuild , so everything is compressed in one extent

you can use the flatfiles for backup in case of diskcrash

but dont delete files or the system wont come up after restart, this seems to be a known bug

for good join you need an extra index on every column

normaly our tables have at least 30 indexes, which must be rebuilded day by day
so we are really busy down here

we have here more than 20 years experience in oracle, so we know our stuff. we are working since oracle 3 in this way and everything is going well

"zulijid_at_hotmail.com" <aersdjes_at_hotmail.com> schrieb im Newsbeitrag 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
>
>
>
>
>
>
Received on Sun May 12 2002 - 10:39:59 CDT