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