v$session vs v$resource_limit
From: Patty Vonick <patty.vonick_at_returnpath.net>
Date: Fri, 3 Feb 2012 14:28:57 -0700
Message-ID: <B80E3C80BB6402419CAD9190E3BB749C01524EFFF1_at_rpcoex01.rpcorp.local>
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.
Date: Fri, 3 Feb 2012 14:28:57 -0700
Message-ID: <B80E3C80BB6402419CAD9190E3BB749C01524EFFF1_at_rpcoex01.rpcorp.local>
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_at_PROD1 AS SYSDBA> select count(*) from v$session;
COUNT(*)
242
SYS_at_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
Received on Fri Feb 03 2012 - 15:28:57 CST