Do Oracle DBs deteriorate over time??

From: Tim Auckland <auckland_at_probita.com>
Date: 1997/03/03
Message-ID: <mortE6HB6r.Hu8@netcom.com>#1/1

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:

tables and indexes may expand and occupy multiple extents
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