on 04-05-2008 9:16 AM
hi experts,
wt is the user of tcode DB01 and if we find oracle dead locks
wt action has to be taken?
Hi,
DB01: Exclusive Lock waits
The reason you have transaction DB01 is to monitor the database locks which are created when the work process does the actual write/delete on the database. DB01 allows you to see these locks and also allows you to identify deadlocks
Have a look into this link for detailed info about SAP lock and DB Lock.
http://help.sap.com/saphelp_nw04/helpdata/en/f4/71aa036c874c308c1a819f05321137/frameset.htm
Apart from the fact that DB01 shows Exclusive Lock Wait Situations and not locks themselves normally, the main difference between SAP-Locks and DB-Locks is that not every SAP-Lock has exactly one DB-Lock associated with it necessarily. It's similar to differences between SAP- and DB-DataDictionary. They're closely related, but when it comes to the details - worlds apart.
When a lock request comes from a user for a table, first the lock entry is made in SM12. The lock entry is made only when no other lock entries are present for that particular table.
To execute the lock request ( or the lock entry in SM12 ) a corresponding lock object is defined in ABAP dictionary. The lock object is nothing but, it contains the details on which table to be locked.
So when corresponding lock object is created, it has a series of lock modes assigned to them like, Write locks (X), exclusive write locks (E), Shared locks (S). The lock modes are shown SM12.
THis is definite indication that lock objects for defined for lock entries in SM12.
Regards
Aashish Sinha
PS : reward points if helpful
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi phani,
thanks for the answer and please tell me if we find more lockwaits, wt could be reason and how to solve the issue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
transaction DB01 for lockwaits, and you can check locks from st04->Detail analysis menu.
In MsSQL there is Exlusive Lockwaits, Deadlock, Blocking lockstats monitoring possibility.
Regards,
Phani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.