Re: Table performance over time

On 26 Apr 2004 13:03:57 -0700, richard.a.elliott_at_williams.com (Richard Elliott) wrote:

>Watching the performance of several tables decline over time. Is there
>a standard process to perform on tables that have lots of
>updates,inserts and deletes on them ? I know from experiance that an
>export/import will improved performance, but that's not feasible
>except in the case of an emergency restore.
>
>Using the Rule based optimizer, so I don't think analysing the tables
>will make any difference ? (Why I'm using RBO is a whole different
>subject)
>
>Unix Solaris 2.7 (migrating to 2.8 next month)
>Oracle 8.1.6 (migrating to 9I this summer)

The first thing I'd look at would be chained and migrated rows. These will drive the i/o up. As far as I know, the only way to un-chain/un-migrate them is to reorg the table. To prevent (or at least minimize) future problems, take a look at your pct free setting. Received on Tue Apr 27 2004 - 07:49:24 CDT