RE: maxconcurrency and active sessions
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 18 Jan 2007 09:30:56 -0500
>> if maxcouncurrency seens in v$undostat is equal to the number of
ACTIVE sessions shown in v$session <<
No. An active session as shown in v$session does not have to be
performing DML but could be busy querying.
There is a difference between the number of concurrent sessions and the
number of concurrent transactions.
-- Mark D Powell --
Phone (313) 592-5148
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of LS Cheng
Sent: Thursday, January 18, 2007 8:14 AM
To: oracle-l
Subject: maxconcurrency and active sessions
Hi
I was wondering if maxcouncurrency seens in v$undostat is equal
to the number of ACTIVE sessions shown in v$session and are NOT
backkground processes?
I am trying to determine a system concurrency, usually I watch
number of active sessions but I am considering using maxconcurrency.
TIA
--
LSC
Other related posts:
