Oracle-L: Re: trace sequence values

From: Jared Still <jkstill_at_cybcon.com>
Date: Thu, 27 Nov 2003 10:24:28 -0800
Message-ID: <F001.005D8061.20031127102428@fatcity.com>

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: jkstill_at_cybcon.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).

Received on Thu Nov 27 2003 - 12:24:28 CST