Re: Slow updates for one table with bind variables

Wolfram Roesler <wr_at_spam.la> 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:

http://download.oracle.com/docs/cd/B10501_01/server.920/a96533/sqltrace.htm#PFGRF010

-- 
_______________________________________________________________________
Dan Blum					         tool_at_panix.com	
"I wouldn't have believed it myself if I hadn't just made it up."