Home » Developer & Programmer » Forms » Oracle 10g - Need to stop the execution for specific query in running mode (Oracle devsuite 10g)
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. Sad
Previous Topic: When PLLs need to be detached and reattached
Next Topic: how to reduce quantity (merged 2)
Goto Forum:
  


Current Time: Mon Oct 20 22:11:35 CDT 2014

Total time taken to generate the page: 0.10533 seconds