MessageThanks a mil ----- Original Message ----- From: Anjo Kolk To: oracle-l@xxxxxxxxxxxxx Sent: Monday, March 29, 2004 7:13 PM Subject: RE: Cursor sharing failures 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Arghadeep Chatterjee Sent: Monday, March 29, 2004 9:24 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Cursor sharing failures Hi Anjo, a little more details plz. Deep ----- Original Message ----- From: Anjo Kolk To: oracle-l@xxxxxxxxxxxxx Sent: Sunday, March 28, 2004 7:54 PM Subject: RE: Cursor sharing failures v$sql_shared_cursors probably. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Arghadeep Chatterjee Sent: Sunday, March 28, 2004 1:10 PM To: oracle-l@xxxxxxxxxxxxx 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