与Lock和Latch相关的动态性能视图

Lock:

select * from v$lock;

select * from v$locked_object;

select * from v$lock_type;

 

Latch:

select * from v$latchholder;

select * from v$latch;

select * from v$latch_children;

select * from v$latchname;