在查看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