Oracle 10g - Need to stop the execution for specific query in running mode [message #572962] |
Wed, 19 December 2012 01:02 |
ravianugade
Messages: 15 Registered: February 2011 Location: Pune
|
Junior Member |
|
|
Hi Experts,
We are facing a problem on Oracle form 10g.
As current situation, we have one form which contains the database blocks. As per search condition, all the data populated in Database block. User entered the search condition most queries became a little faster.But a some of the query (a quite complex one) became dramaticaly slower - it went from 4 min per execution to rougly 1/2 hours per execution.
To stop that execution forcefully ( not responding), we go to control panel and stop the process. But this should not be good way.
Can we show a simple alert at time of query execution, on back end query is running. If we want to terminate this execution just cancel the execution by the help of that alert.
Help me.
|
|
|