一个连接可能产生多个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).
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8109090/viewspace-1033738/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8109090/viewspace-1033738/