cursor 0 in sql_trace and event10046 raw trace files

From: Danisment Gazi Unal (Unal Bilisim) <danisment.unal_at_unal-bilisim.com>
Date: Thu, 21 Jun 2001 07:56:45 -0700
Message-ID: <F001.00331FA8.20010621080643@fatcity.com>

Hello list,

some of itrprof users encounter cursor 0. Since there is no parsed SQL statement which has a cursor number 0, itrprof prompts "itp-05 [x] : File corrupted." message.

I examined raw trace files and could not see an SQL statement which has a cursor number 0.

I think this is a bug. because, it's not possible for a kernel call to make a kernal call with non-existing cursor number.

Since tkprof doesn't report this error, Oracle may have not fixed it. have you encountered same problem ?

thanks in advance...

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Danisment Gazi Unal (Unal Bilisim)   INET: danisment.unal_at_unal-bilisim.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). Received on Thu Jun 21 2001 - 09:56:45 CDT