using v$Locked_objects

Ranch Hand

Posts: 199

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Apart from using v$Locked_objects do we have any other table/view etc that can tell us whether a table has locks on it or not.

I am currently using following query

select a.owner, a.object_name, b.locked_mode, b.session_id from dba_objects a, v$locked_object b where a.object_id = b.object_id

Please tell how expensive is it to run above query often.

Kindly help

Pratibha Malhotra

~ Pratibha Malhotra Sun Certified Java Programmer SCEA 1.4 (In Progress) ~~~~~~~~~~~~~~~~~~~~~~~~~~~ "Many of life's failures are people who did not realize how close they were to success when they gave up!!"

Consider Paul's rocket mass heater.