List:General Discussion« Previous MessageNext Message »
From:Denis Jedig Date:May 9 2013 10:39pm
Subject:Re: Slow Response -- What Does This Sound Like to You?
View as plain text  

Am 09.05.2013 22:58, schrieb Robinson, Eric:

> Q: What conditions could cause single query to lock up a database for a while for all
> users

 From 
<http://docs.oracle.com/cd/E17952_01/refman-5.5-en/table-locking.html> 
:

A SELECT statement that takes a long time to run prevents other 
sessions from updating the table in the meantime, making the 
other sessions appear slow or unresponsive. While a session is 
waiting to get exclusive access to the table for updates, other 
sessions that issue SELECT statements will queue up behind it, 
reducing concurrency even for read-only sessions.

You might try using low_priority_updates to mitigate this.

Regards,
-- 
Denis Jedig
syneticon networks gmbh
Thread
Slow Response -- What Does This Sound Like to You?Eric Robinson9 May
  • RE: Slow Response -- What Does This Sound Like to You?Rick James9 May
    • RE: Slow Response -- What Does This Sound Like to You?Eric Robinson9 May
      • RE: Slow Response -- What Does This Sound Like to You?Wm Mussatto9 May
        • RE: Slow Response -- What Does This Sound Like to You?Eric Robinson9 May
          • Re: Slow Response -- What Does This Sound Like to You?shawn green9 May
      • Re: Slow Response -- What Does This Sound Like to You?Bruce Ferrell10 May
        • RE: Slow Response -- What Does This Sound Like to You?Rick James10 May
          • RE: [>Suspected Spam<][Characteristics] RE: Slow Response -- What Does This Sound Like to You?Eric Robinson10 May
            • RE: Slow Response -- What Does This Sound Like to You?Rick James10 May
  • Re: Slow Response -- What Does This Sound Like to You?Johnny Withers9 May
  • Re: Slow Response -- What Does This Sound Like to You?Denis Jedig9 May
RE: Slow Response -- What Does This Sound Like to You?Vikas Shukla10 May