Re: Cursor sharing failures

From: Arghadeep Chatterjee <dba_at_magma.co.in>
Date: Wed, 31 Mar 2004 11:01:00 +0530
Message-ID: <005d01c416e1$5a8477a0$4a0710ac@lan.magma.co.in>

MessageThanks a mil

Original Message ----- From: Anjo Kolk To: oracle-l_at_freelists.org 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_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 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 Tue Mar 30 2004 - 23:11:11 CST