Re: Performance deteriorates on a dynamic db

From: <_at_Eaton.com>
Date: 1997/10/23
Message-ID: <344F4EEA.5AA9_at_Eaton.com>#1/1


Did you setup suitable STORAGE clauses for the tables? In particular, the INITIAL and NEXT clauses. Otherwise, your tables may be scattered in many extents, which will really put a dent in the performance (not to mention that you will eventually run out of extents).

Phil Tsao wrote:
>
> Hi, Oracle Experts,
>
> We have an Oracle 7.3 on NT 4.0. There is one schema we use a few
> stored procs to insert, update, and then delete a lot of data all the
> time
> (10,000 to 40,000 rows on half dozen tables). It seems Oracle gets
> slower and slower each we do another batch of insert.
> Truncate and delete all the tables manually did not help.
> Drop the schema did not help.
> Uninstall and reinstall the Oracle server would regain the better
> performance but it would then deteriorate over the same operation.
>
> Does Oracle have problem with a dynamic database?
> Do I need to recompile all the store procs ?
> Thanks in advance for the help.
> --
> Phil Tsao
> philt_at_technologist.com
Received on Thu Oct 23 1997 - 00:00:00 CEST

Original text of this message