Re: virtual circuit status
- From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
- To: andert@xxxxxxxxx
- Date: Wed, 15 Feb 2006 13:46:41 -0800
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@xxxxxxxxx> 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/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
