v$session vs v$resource_limit
- From: Patty Vonick <patty.vonick@xxxxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 3 Feb 2012 14:28:57 -0700
Hi All -
We have been collecting session counts from v$session - and then compared max
session counts from v$session for each snapshot... and found that it differs
from the sessions count in v$resource_limit.
Can anyone explain this?
Thanks for your help.
SYS@PROD1 AS SYSDBA> select count(*) from v$session;
COUNT(*)
----------
242
SYS@PROD1 AS SYSDBA> select * from v$resource_limit;
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL
LIMIT_VALU
------------------------------ ------------------- --------------- ----------
----------
processes 256 330 512
512
sessions 283 395 800
800
enqueue_locks 505 822 9616
9616
enqueue_resources 312 2240 4040
UNLIMITED
ges_procs 0 0 0
0
ges_ress 0 0 0
UNLIMITED
ges_locks 0 0 0
UNLIMITED
ges_cache_ress 0 0 0
UNLIMITED
ges_reg_msgs 0 0 0
UNLIMITED
ges_big_msgs 0 0 0
UNLIMITED
ges_rsv_msgs 0 0 0
0
gcs_resources 0 0 0
0
gcs_shadows 0 0 0
0
dml_locks 1 1 3520
UNLIMITED
temporary_table_locks 0 32 UNLIMITED
UNLIMITED
transactions 3 3 880
UNLIMITED
branches 0 6 880
UNLIMITED
cmtcallbk 1 18 880
UNLIMITED
max_rollback_segments 60 60 880
65535
sort_segment_locks 2 47 UNLIMITED
UNLIMITED
k2q_locks 0 0 1600
UNLIMITED
max_shared_servers 0 0 UNLIMITED
UNLIMITED
parallel_max_servers 106 110 36
3600
23 rows selected.
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- Re: v$session vs v$resource_limit
- From: coskan gundogar
- Re: v$session vs v$resource_limit
Other related posts:
- » v$session vs v$resource_limit - Patty Vonick
- » Re: v$session vs v$resource_limit - coskan gundogar