Re: System Wait Event Type

No,

It relates to MTS. It is the shared server process waiting for work. The event has kind of a double meaning: it could be regarded as an idle event, but also an event for receiving data. Mostly idle though.

Anjo.

"Mercadante, Thomas F" wrote:

> All,I am running a long-running PL/SQL procedure (loading data). The
> procedure is getting all of the data from another database via a db
> link. There is one large driving cursor, with many sub-selects taking
> place to construct the records tobe inserted.I was monitoring the run,
> and noticed from the v$system_event table that the largest wait event
> in "virtual circuit status" followed by "db file sequential
> read"Anybody know what "virtual circuit status" is? My guess is it's
> from the database link. Any help would be appreciated.thanks Tom
> Mercadante
> Oracle Certified Professional
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).