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
>
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 18 2007 - 08:42:00 CST
