how to find out locked object/rows using TOAD?

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

schwertner

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

i can run the on sql prompt
but i want to do the same thing from toad
without writing the script.

ASKER

i know how to find with script
here i want to know using TOAD?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

schwertner

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

i check the scheme browser.
In schema browser where i can find the locking information.
can i directly kill from toad.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

if i found any records in this browser that means that records is locked.
we can kill the session.is it correct?

ASKER

i mean we can kill that records which are in lock tab, right.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.