RE: maxconcurrency and active sessions

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 18 Jan 2007 09:30:56 -0500
Message-ID: <D1DC33E67722D54A93F05F702C99E2A965ACA6@usahm208.amer.corp.eds.com>

   

>> 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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
	
	 

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 18 2007 - 08:30:56 CST