at999
asked on
cancel execution of very slow update query
i am running an update query -query1 from sqlplus command prompt
that query is taking long it s running since 3 hours
so i want to cancel/stop that query and rerun another update query that updates the same column as query1 is updating and which is faster than query1...
so is it ok if i just cancel execution of query1 using Ctrl-C (more than 1 time if required)
and rerun the new query which is faster?
Or
do i have to contact dba to cancel previous transactions or how do i quit running query1
please help thanks a lot
that query is taking long it s running since 3 hours
so i want to cancel/stop that query and rerun another update query that updates the same column as query1 is updating and which is faster than query1...
so is it ok if i just cancel execution of query1 using Ctrl-C (more than 1 time if required)
and rerun the new query which is faster?
Or
do i have to contact dba to cancel previous transactions or how do i quit running query1
please help thanks a lot
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
and other one in sqlplus from command prompt which i am trying to cancel... pl help