Re: Sometimes query in waiting status and taking more than 30 mins to execute
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 13 Nov 2013 15:47:32 +0000 (UTC)
Message-ID: <pan.2013.11.13.15.47.32_at_gmail.com>
Date: Wed, 13 Nov 2013 15:47:32 +0000 (UTC)
Message-ID: <pan.2013.11.13.15.47.32_at_gmail.com>
On Wed, 13 Nov 2013 05:23:46 -0800, oracle_user wrote:
> I hava a query. Most of the times it executes very fast 15 -20 seconds
> but at times it takes more than 30 mins to execute.In V$session it shows
> in 'WAITING' status and event is 'db file sequential read' or 'direct
> path read'. Wait class is 'User I/O'. Plz suggest why does this happens
> and how to improve this.
Reduce the waiting time.
-- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.comReceived on Wed Nov 13 2013 - 16:47:32 CET