Event 10217 is listed as used to debug sequence numbers, but setting the event doesn't seem to have much effect on a trace file.
You could try monitoring v$_sequences. Jared On Thu, 2003-11-27 at 03:34, Jeroen van Sluisdam wrote: > Hi, > > I need urgently to trace an app which uses sequences with OCI to determine > what is going wrong. When I use an 10046 event I do not get values of > sequence returned when issueing > sequence.nextval. Any ideas about how to trace this are appreciated. > > Regards, > > Jeroen > > Details: Oracle 9.2..0.4 server on HP-UX 11.11, client Oracle 7.3.4.3 on > HP-UX 10.20 > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
