Re: Do Oracle DBs deteriorate over time??

I guess the 3rd paragraph of my original post asked too broad a question -- I had intended to ask specifically about deterioration which might cause an Oracle database to be taken down at (say) 3 or 6-monthly intervals for a lenghtly re-structure or re-build.

Thanks for the replies so far (mostly through direct e-mail) -- the number of people willing to assist perfect strangers through this forum always amazes me.

Thanks again,

Tim.

auckland_at_probita.com (Tim Auckland) wrote:

>We are setting up a new production database using Oracle 7.3 on Unix,
>and I am trying to find out whether any regular re-structures, index
>re-builds, overflow removal, de-fragmentataion, etc. is recommended
>after a period of operation.
 

>So far, I am aware of two problems in this area:
 

>1) tables and indexes may expand and occupy multiple extents
>2) rows may become chained if records are expanded after initial
>creation
 

>Are there any other efficiency aspects of Oracle 7.3 databases which a
>prudent DBA would monitor, and, if a problem does occur, what steps
>can be taken to remove it?
 

>Any help would be greatly appreciated.
 

>Thanks in advance.
 

>Tim Auckland.
Received on Mon Mar 03 1997 - 00:00:00 CST