Home » RDBMS Server » Server Administration » Locks on Tables
Locks on Tables [message #370880] Tue, 29 February 2000 04:23 Go to next message
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 Go to previous message
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
Previous Topic: How to check if column has value for LONG datatype?
Next Topic: Dynamically build Columns for a SQL select
Goto Forum:
  


Current Time: Thu Oct 22 04:17:37 CDT 2020