RE: cursor sharing

From: <genegurevich_at_discoverfinancial.com>
Date: Mon, 19 Jun 2006 17:11:35 -0500
Message-ID: <OF4669F46C.F1C03DD0-ON86257192.0079CCF3-86257192.0079D5BA@discoverfinancial.com>

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>            
                                                                        cc 
                                                                           
             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 Received on Mon Jun 19 2006 - 17:11:35 CDT