RE: maxconcurrency and active sessions
- From: "Yasin Baskan" <yasin.baskan@xxxxxxxxxxxxxxxx>
- To: <exriscer@xxxxxxxxx>, <mark.powell@xxxxxxx>
- Date: Thu, 18 Jan 2007 17:00:22 +0200
I did not test this but this may be related to autonomous transactions
if you use them. If your session has an active transaction and you start
an autonomous transaction, you have 2 concurrent transactions from the
same session.
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of LS Cheng
Sent: Thursday, January 18, 2007 4:42 PM
To: mark.powell@xxxxxxx
Cc: oracle-l
Subject: Re: maxconcurrency and active sessions
That makes things even worse, from v$undostat it constantly shows
maxconcurrency over 50 however v$session never shows more than 35
concurrent active sessions. shouldnt the opposite be expected?
On 1/18/07, Powell, Mark D <mark.powell@xxxxxxx> wrote:
>> 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
Bu mesaj ve onunla iletilen tum ekler gonderildigi kisi ya da kuruma ozel ve
Bankalar Kanunu geregince, gizlilik yukumlulugu tasiyor olabilir. Bu mesaj,
hicbir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve para
karsiligi satilamaz; mesajin yetkili alicisi veya alicisina iletmekten sorumlu
kisi degilseniz, mesaj icerigini ya da eklerini kopyalamayiniz, yayinlamayiniz,
baska kisilere yonlendirmeyiniz ve mesaji gonderen kisiyi derhal uyararak bu
mesaji siliniz. Bu mesajin iceriginde ya da eklerinde yer alan bilgilerin
dogrulugu, butunlugu ve guncelligi Bankamiz tarafindan garanti edilmemektedir
ve bilinen viruslere karsi kontrolleri yapilmis olarak yollanan mesajin
sisteminizde yaratabilecegi zararlardan Bankamiz sorumlu tutulamaz.
This message and the files attached to it are under the privacy liability in
accordance with the Banking Law and confidential to the use of the individual
or entity to whom they are addressed. This message cannot be copied, disclosed
or sold monetary consideration for any purpose. If you are not the intended
recipient of this message, you should not copy, distribute, disclose or forward
the information that exists in the content and in the attachments of this
message; please notify the sender immediately and delete all copies of this
message. Our Bank does not warrant the accuracy, integrity and currency of the
information transmitted with this message. This message has been detected for
all known computer viruses thence our Bank is not liable for the occurrence of
any system corruption caused by this message
Other related posts:
