Re: System Wait Event Type

I was just looking at various wait events today...

it has to do with mts and shared servers.. so in a sense yes, it has to do with the database link.

|--------+------------------------>


|        |                        |

|        |                        |

|        |          NDATFM_at_labor.s|

|        |          tate.ny.us    |

|        |                        |

|        |          05/07/2002    |

|        |          04:43 PM      |

|        |          Please respond|

|        |          to ORACLE-L   |

|        |                        |

|--------+------------------------>
  >----------------------------------------------------|
  |                                                    |
  |       To:     ORACLE-L_at_fatcity.com                 |
  |       cc:     (bcc: Rachel Carmichael)             |
  |       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: 
  INET: Rachel_Carmichael_at_Sonymusic.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).