Oracle-L: RE: System Wait Event Type

From: Diego Cutrone <dcutrone_at_afip.gov.ar>
Date: Tue, 07 May 2002 13:05:17 -0800
Message-ID: <F001.0045A805.20020507130517@fatcity.com>

I think that "virtual circuit status" might be related to MTS . Are you using MTS?

Original Message ----- From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Tuesday, May 07, 2002 2:43 PM Subject: System Wait Event Type

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: Diego Cutrone
INET: dcutrone_at_afip.gov.ar

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). Received on Tue May 07 2002 - 16:05:17 CDT