RE: Cursor sharing failures

From: Anjo Kolk <anjo_at_oraperf.com>
Date: Mon, 29 Mar 2004 15:43:09 +0200
Message-ID: <029401c41593$c588a8e0$0c00a8c0@videoserver>

This view will well tell why child cursors can't be shared. When I looked some time ago, I noticed that it is probably a bit mask on the reason why a cursor can't be shared. So if you look at the underlying SQL statement (in v$fixed_view_definition) you can tell probably what your flag means.

Anjo.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Arghadeep Chatterjee
Sent: Monday, March 29, 2004 9:24 AM
To: oracle-l_at_freelists.org
Subject: Re: Cursor sharing failures

Hi Anjo,
a little more details plz.
Deep

Original Message ----- From: Anjo Kolk <mailto:anjo_at_oraperf.com> To: oracle-l_at_freelists.org Sent: Sunday, March 28, 2004 7:54 PM Subject: RE: Cursor sharing failures

v$sql_shared_cursors probably.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Arghadeep Chatterjee
Sent: Sunday, March 28, 2004 1:10 PM
To: oracle-l_at_freelists.org
Subject: Cursor sharing failures

Hi all,
I was trying to decipher a trc file generated due to a deadlock scenario on my box .I am faced with lot many
Dumping cursor sharing failures: 4000
though the values differ. I tried searching the meatlink for "cursor sharing failures" and I ended up with this http://metalink.oracle.com/metalink/plsql/ml2_gui.startup I could put the entire post as it will be bounced.I am at loss can you guys give me some pointers links on this. Thanks
Deep

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Mar 29 2004 - 07:41:59 CST