Oracle-L: System Wait Event Type

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Tue, 07 May 2002 12:43:36 -0800
Message-ID: <F001.0045A78E.20020507124336@fatcity.com>

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: Mercadante, Thomas F
INET: NDATFM_at_labor.state.ny.us

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 - 15:43:36 CDT