Re: Slow updates for one table with bind variables

From: Dan Blum <>
Date: Mon, 11 Aug 2008 14:52:07 +0000 (UTC)
Message-ID: <g7pjmn$q5q$>

Wolfram Roesler <> wrote:
> Hello,

> I have an application that queries and updates several table in a
> transaction every few seconds. I recently modified the application
> to use bind variables instead of ad-hoc SQL. With that modification,
> updates to one particular table have become slow: They used to be
> in the millisecond range but now sometimes take several seconds
> to complete (most of the time, however, they are as fast as ever).
> During the nightly online backup, sometimes they even take several
> minutes, locking the application during that time.

> Updates to other tables are still as fast as they have ever been.

You should turn tracing on, run updates until some are slow, and then see what the trace shows.

See this Oracle documentation chapter for details:

Dan Blum					
"I wouldn't have believed it myself if I hadn't just made it up."
Received on Mon Aug 11 2008 - 09:52:07 CDT

Original text of this message