RE: cursor sharing

From: ramick <ramick_at_dotster.com>
Date: Tue, 20 Jun 2006 09:10:13 -0700
Message-Id: <20060620161033.1B56935E254@turing.freelists.org>

Post 10053 and tkprof traces.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discoverfinancial.com Sent: Tuesday, June 20, 2006 7:28 AM
To: oracle-l
Subject: Re: cursor sharing

I have checked it and yes, the explain plan is the same

thank you

Gene Gurevich
Oracle Engineering
224-405-4079

                                                                           
             "Ghassan Salem"                                               
             <salem.ghassan_at_gm                                             
             ail.com>                                                   To 
                                       genegurevich_at_discoverfinancial.com  
             06/20/2006 03:08                                           cc 
             AM                        oracle-l <oracle-l_at_freelists.org>   
                                                                   Subject 
                                       Re: cursor sharing

Gene,
"The explain plan did not seem to have changed"!!!! please be sure of that, same plan should mean same perf (on the same db, that is).

Post the query and the plans, and we'll see.

rgds

On 6/20/06, genegurevich_at_discoverfinancial.com < genegurevich_at_discoverfinancial.com> wrote: The only change that I have made is the cursor_shareing_exact hint. There
was nothing else done (to my knowledge) The explain plan did not seem to have changed

thank you

  Gene Gurevich
  Oracle Engineering
  224-405-4079

               "ramick"
               < ramick_at_dotster.c
               om>
  To
               Sent by:                  <
  genegurevich_at_discoverfinancial.com
               oracle-l-bounce_at_f         >, "'oracle-l'"
               reelists.org              < oracle-l_at_freelists.org>

06/19/2006 04:46
Subject

               PM                        RE: cursor sharing


               Please respond to
               ramick_at_dotster.co
                       m

Are you 100% sure it's due to cursor_sharing?

Maybe you already checked, but is the execution plan the same?

Is this 9204 on AIX?

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org [mailto:   oracle-l-bounce_at_freelists.org]
  On Behalf Of genegurevich_at_discoverfinancial.com   Sent: Monday, June 19, 2006 2:19 PM
  To: oracle-l
  Subject: cursor sharing

Hi all:

Can someone recommend a good article on the cursor sharing in Oracle 9. I just found a query that runs in 5 seconds with CURSOR_SHARING_EXACT and in more than 1 hour without it (cursor_sharing is set to force on the DB level) I'm trying to find out why it happens.

thank you

Gene Gurevich

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 20 2006 - 11:10:13 CDT