Re: Oracle slows down, why?

On Tue, 2 Apr 2002, tbourget_at_racltd.com wrote:
> Hello,
> Program A is an updating program. The company I
> work for is in insurance and we use an old dBase
> system to keep track of customer information. The
> system is called FAST if you're curious. I've
> created a table space in the Oracle database that
> duplicates FAST's table structure. Every 12 hours
> the tables in the duplicate table space are truncated
> and then updated with FAST's current information.
>
> Program B is an accounting program. It creates a
> very complex report by querying large amounts of data
> from the Oracle database and then manipulates that
> information. This program is strictly read-only.
>
> Now here's the problem: If program B is ran after a
> fresh boot the full process may take 4 or 5 seconds.
> But if program A is ran first and then program B is
> ran, the process will now take about 1 minute.
>
> Why does program A slow-down the SQL queries
> that program B executes?

Could this be caused by delayed block cleanout?

What happens if you run program B a second time? Does the time go back down?

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.