Re: Cursor sharing failures

  • From: "Arghadeep Chatterjee" <dba@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 31 Mar 2004 11:01:00 +0530

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

Other related posts: