Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Performance deteriorates on a dynamic db

Re: Performance deteriorates on a dynamic db

From: <_at_Eaton.com>
Date: 1997/10/23
Message-ID: <344F4EEA.5AA9@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 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US