Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: maxconcurrency and active sessions

Re: maxconcurrency and active sessions

From: LS Cheng <exriscer_at_gmail.com>
Date: Sat, 20 Jan 2007 09:29:05 +0100
Message-ID: <6e9345580701200029t6635b67dp2e6191d14f1626bd@mail.gmail.com>


Hmm that may makes sense, I will check if there are many autonomous transactions going

Thanks!

--
LSC


On 1/18/07, Yasin Baskan <yasin.baskan_at_yapikredi.com.tr> wrote:

>
> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *LS Cheng
> *Sent:* Thursday, January 18, 2007 4:42 PM
> *To:* mark.powell_at_eds.com
> *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_at_eds.com> 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_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
>
>
>
>
>
>
> 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
>
-- http://www.freelists.org/webpage/oracle-l
Received on Sat Jan 20 2007 - 02:29:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US