Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: cursor 0 in sql_trace and event10046 raw trace files

RE: cursor 0 in sql_trace and event10046 raw trace files

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Thu, 21 Jun 2001 09:44:40 -0700
Message-ID: <F001.00332308.20010621094817@fatcity.com>

What is itrprof?

-----Original Message-----
[mailto:danisment.unal_at_unal-bilisim.com] Sent: Thursday, June 21, 2001 12:07 PM
To: Multiple recipients of list ORACLE-L

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

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

Author: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.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 - 11:44:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US