| Locks on Tables [message #370880] |
Tue, 29 February 2000 04:23  |
Grayson Govender
Messages: 2
Registered: February 2000
|
Junior Member |
|
|
We are experiencing a problem, where whenever a user is doing a validation and commits on a field, then the system is slowed down, all users hang and tables locks. We are using Forms 3.0
Could someone please tell me, how to locate which table is locking?
We are using SQLDBA, but the monitor lock screen, doesn't identify which table specifically is locking.The version of Oracle is 7.2
Also can someone please tell me how to use SQLDBA to locate the specific table which is locking?
Many Thanks
Grayson Govender
|
|
|
|
| Re: Locks on Tables [message #370887 is a reply to message #370880] |
Tue, 29 February 2000 12:52  |
Naveen Kumar V
Messages: 16
Registered: February 2000
|
Junior Member |
|
|
This may help you
select object_name,locked_mode,oracle_username,TERMINAL from all_objects ao,v_$locked_object vl
where ao.object_id = vlo.object_id
and vs.sid = vlo.session_id
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
