Re: Sometimes query in waiting status and taking more than 30 mins to execute

From: Mladen Gogala <>
Date: Wed, 13 Nov 2013 15:47:32 +0000 (UTC)
Message-ID: <>

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
Received on Wed Nov 13 2013 - 16:47:32 CET

Original text of this message