Re: virtual circuit status

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Wed, 15 Feb 2006 13:46:41 -0800
Message-ID: <3b0f44a10602151346g6dddd5aar4e105283e2112377@mail.gmail.com>

Steve:

Virtual Circuits are related to MTS/Shared Server and dispatcher acquires couple of virtual circuit related latches and establishes the communication between client process and server process.

You can look at the session_wait to findout why the sessions are waiting. I think p2 of the virtual circuit wait gives the reason code .

Gopal

On 2/15/06, Stephen Andert <andert_at_gmail.com> wrote:
> I am getting reports of a slowness issue, so I ran a STATSPACK report. Ran
> it through ORAPERF 75% of the response time is WAIT. 70% of the WAIT time
> is virtual circuit status. After a quick search, I can't find anything on
> Metalink on what the cause or possible solutions are. Any ideas?
>
> --
> Stephen Andert
> http://spaces.msn.com/members/andert-news
>

--
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 15 2006 - 15:46:41 CST