RE: Cursor sharing failures
- From: "Anjo Kolk" <anjo@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 29 Mar 2004 15:43:09 +0200
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 <mailto:anjo@xxxxxxxxxxx>
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
Other related posts:
