暂无图片
Oracle AWR中 “Logons” 和 “User logons” 区别
最近更新:2022-07-11 09:25:35

概念描述

在查看AWR时LOGONS每秒实际比listener log中的每秒创建连接高出很多倍,同时AWR中还有另一个指标user logons比较接近,”Logons” 和 “User logons” 是有区别的,用于诊断连接风暴是应该使用users logons.

Load Profile

Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	67.8	0.1	0.00	0.00
DB CPU(s):	40.7	0.1	0.00	0.00
Background CPU(s):	1.4	0.0	0.00	0.00
Redo size (bytes):	1,903,005.2	3,377.1		
Logical read (blocks):	3,280,769.8	5,822.2		
Block changes:	10,279.4	18.2		
Physical read (blocks):	13,819.3	24.5		
Physical write (blocks):	3,589.0	6.4		
Read IO requests:	5,913.0	10.5		
Write IO requests:	301.7	0.5		
......