Lock, lock

Lock, lock

1. view the current Lock Object
Select a. owner,
A. object_name,
B. xidusn,
B. xidslot,
B. xidsqn,
B. session_id,
B. oracle_username,
B. OS _user_name,
B. process,
B. locked_mode,
C. machine,
C. status,
C. server,
C. sid,
C. serial #,
C. program
From all_objects,
V $ locked_object B,
V $ session c
Where (a. object_id = B. object_id)
And (B. process = c. process)
Order by 1, 2;

Query the session details based on the queried session_sid:

Select saddr, sid, serial #, paddr, username, status from v $ session where sid = '20140901 ';

If the lock is invalid, kill the session.

Alter system kill session 'sid, serial #';

[Note] the preceding two steps can be performed on the Oracle console.
If a question error occurs, you can
Select. spid, B. sid, B. serial #, B. username from v $ process a, v $ session B where. addr = B. paddr and B. status = 'killed ';

3. if the process state is set to "killed" after a process is killed by using the preceding command, but the locked resources are not released for a long time, then, the corresponding process (thread) can be killed at the OS level. First, execute the following statement to obtain the process (thread) Number:
Select spid, osuser, s. program from v $ session s, v $ process p where
S. paddr = p. addr and s. sid = 785 (33 is the sid above)

4. Killing the process (thread) on the OS ):
1) run the command as root on unix:
# Kill-9 12345 (that is, the spid obtained in step 1)

What are the types of locks?

Lock types:
1. locks: they are divided into copper locks, iron locks, and password locks. Their main specifications include 15, 20, 25, 30, 40, 50, 60, and 75mm.
2. Doudou lock: it is divided into full copper Doudou lock, set copper Doudou lock, aluminum core Doudou lock and left and right locking. Its main specifications include 5mm and 16mm.
3. Bullet lock: it can be divided into single-insurance locks, double-insurance locks, three-insurance locks, and multiple-insurance locks.
4. pin locks: Also known as anti-theft locks, which are divided into steel door locks and wooden door locks.
5. Spherical locks: copper spherical locks, three-tube spherical locks, and room locks.
6. Color lock: divided into glass locks, plug-in locks, snap-on locks, electrical box switch locks, chain locks, and tongue locks.
7. Electronic Control lock: Fingerprint Lock, magnetic card lock, IC Card lock, and password lock.
8. Stick lock.
9. Aircraft locks, train locks, car locks, and boat locks ,.
10. Prison locks and other special locks.

What are the types of locks?

Lock types:
1. locks: they are divided into copper locks, iron locks, and password locks. Their main specifications include 15, 20, 25, 30, 40, 50, 60, and 75mm.
2. Doudou lock: it is divided into full copper Doudou lock, set copper Doudou lock, aluminum core Doudou lock and left and right locking. Its main specifications include 5mm and 16mm.
3. Bullet lock: it can be divided into single-insurance locks, double-insurance locks, three-insurance locks, and multiple-insurance locks.
4. pin locks: Also known as anti-theft locks, which are divided into steel door locks and wooden door locks.
5. Spherical locks: copper spherical locks, three-tube spherical locks, and room locks.
6. Color lock: divided into glass locks, plug-in locks, snap-on locks, electrical box switch locks, chain locks, and tongue locks.
7. Electronic Control lock: Fingerprint Lock, magnetic card lock, IC Card lock, and password lock.
8. Stick lock.
9. Aircraft locks, train locks, car locks, and boat locks ,.
10. Prison locks and other special locks.