Sometimes query in waiting status and taking more than 30 mins to execute
From: oracle_user <oracle.usr_at_gmail.com>
Date: Wed, 13 Nov 2013 05:23:46 -0800 (PST)
Message-ID: <987ec8be-1326-428b-93e6-d67f602199d3_at_googlegroups.com>
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. Received on Wed Nov 13 2013 - 14:23:46 CET
Date: Wed, 13 Nov 2013 05:23:46 -0800 (PST)
Message-ID: <987ec8be-1326-428b-93e6-d67f602199d3_at_googlegroups.com>
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. Received on Wed Nov 13 2013 - 14:23:46 CET