Trace File cursor waits

I have a logon trigger set up for a user. In examining the trace file, I see the expected logon pl/sql action at the beginning along with the normal NLS parm set ups.
The next action is a select with the usual parse/bind/exec/wait/fetch/wait/stat emissions. After the stat for Cursor #1, there are 264 waits in 132 pairs (1 for each named cursor) of SQL*Net to/from.

The next activity is parsing of cursor #132, with the associated activity (in fact, this cursor is reused quite heavily). Then #127 is parsed and normal activity, then #128, then #17, etc.

I'm not quite certain how to intrepet this sequence of events in the trace file. Any assistance is greatly appreciated.

Daniel Fink

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Fink
  INET: Daniel.Fink_at_Sun.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).



text/x-vcard attachment: Card for Daniel Fink