sessions,processes的監控方法

一個連線可能產生多個sessions，一個sessions可能產生多個processes，同樣，一個processes可能對應多個sessions；Oracle的sessions和processes的數量關係大概是：sessions=1.1 * processes + 5

可以用一下sql做監控select * from v$resource_limit；

該檢視的欄位含義如下：

[@more@]

從Oracle的Reference文件裡面摘錄的，基本上就是標識一些系統資源的使用、設定情況的。
current_utilization - Number of (resources, locks, or processes) currently
being used

max_utization - Maximum consumption of the resource since the last
instance start up

initial_allocation - Initial allocation. This will be equal to the value
specified for the resource in the initialization parameter
file (UNLIMITED for infinite allocation)

limit_value - Unlimited for resources and locks. This can be greater
than the initial allocation value (UNLIMITED for infinite
limit).