Metanil
asked on
Stop the long running Query.
How do we stop running query without using
'alter system kill session...'
Can we achieve this by use of Oralce Job? like killing job without affecting the current session.
Metanil
'alter system kill session...'
Can we achieve this by use of Oralce Job? like killing job without affecting the current session.
Metanil
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes i have heard of OCIBreak but how can we do that in Java.
Any idea?
Metanil
Any idea?
Metanil
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
i heard we can do it using OCI API. For ur convinience, we are using java for executing query.
Metanil