V$LATCH

最新推荐文章于 2021-12-14 09:55:03 发布

EVISWANG

最新推荐文章于 2021-12-14 09:55:03 发布

阅读量454

点赞数

分类专栏： v$ package

本文链接：https://blog.csdn.net/EVISWANG/article/details/50379157

版权

v$ package 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

SQL> set linesize 80
SQL> desc v$latch
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 ADDR						    RAW(8)
 LATCH# 					    NUMBER
 LEVEL# 					    NUMBER
 NAME						    VARCHAR2(64)
 HASH						    NUMBER
 GETS						    NUMBER    ---成功的以willing-to-wait获取latch次数
 MISSES 					    NUMBER   ---以willing-to-wait请求latch,等待次数
 SLEEPS 					    NUMBER
 IMMEDIATE_GETS 				    NUMBER
 IMMEDIATE_MISSES				    NUMBER   ---以immediate模式请求latch不成功次数
 WAITERS_WOKEN					    NUMBER
 WAITS_HOLDING_LATCH				    NUMBER
 SPIN_GETS					    NUMBER  ---以willing-to-wait获取latch,自旋的次数
 SLEEP1 					    NUMBER
 SLEEP2 					    NUMBER
 SLEEP3 					    NUMBER
 SLEEP4 					    NUMBER
 SLEEP5 					    NUMBER
 SLEEP6 					    NUMBER
 SLEEP7 					    NUMBER
 SLEEP8 					    NUMBER
 SLEEP9 					    NUMBER
 SLEEP10					    NUMBER
 SLEEP11					    NUMBER
 WAIT_TIME					    NUMBER ----等待一共花费的时间 微妙

SQL>

看下环境的

000000006001EEC8	190 object queue header heap		      132226143       2436
000000006002F268	280 In memory undo latch		      205204679       9761
000000006000D430	 29 enqueue hash chains 		      267514291      12085
0000000060030720	287 corrupted undo seg latch		      285521418      40062
000000006001CD48	175 active checkpoint queue latch	      294168848    2673287
000000006000A358	 14 session idle bit			      344563821       1190
0000000060023FF0	207 redo writing			      344982512    2827682
000000006003C1B0	336 shared pool 			      364387694      66301
000000006001D6C0	178 cache buffer handles		      392251478 	51
000000006001EA98	185 simulator lru latch 		      402277057     359563
000000006002E108	274 undo global data			      532455991    1910195
000000006001B828	172 cache buffers lru chain		      611721976    1241193
000000006000D198	 27 messages				      691980109    7842612
000000006001D768	179 multiblock read objects		      887374532   17421210
0000000060035480	309 row cache objects			     2115025379     768071
000000006001E880	184 cache table scan latch		     3950881130    7694488
000000006001CDE8	176 checkpoint queue latch		     1.0420E+10     442924
000000006001EE20	189 object queue header operation	     2.7537E+10    3646966
000000006001EB38	186 simulator hash latch		     7.4623E+10    1213481
000000006001D618	177 cache buffers chains		     9.1272E+11  144779709

582 rows selected.

SQL> l
  1* select addr,latch#,name,gets,spin_gets from v$latch order by gets
SQL>