Re: cursor sharing

From: <genegurevich_at_discoverfinancial.com>
Date: Tue, 20 Jun 2006 09:25:31 -0500
Message-ID: <OFDEAFD833.5E99DBE8-ON86257193.004F2BC2-86257193.004F2A4E@discoverfinancial.com>

No. I am using the following to get the explain plan:

select plan_table_output from
table(dbms_xplan.display('PLAN_TABLE',null,'ALL')) (found it on metalink)

thank you

Gene Gurevich
Oracle Engineering
224-405-4079

                                                                           
             "goran                                                        
             bogdanovic"                                                   
             <goran00_at_gmail.co                                          To 
             m>                        genegurevich_at_discoverfinancial.com  
                                                                        cc 
             06/20/2006 04:20          oracle-l <oracle-l_at_freelists.org>   
             AM                                                    Subject 
                                       Re: cursor sharing

Did you checked in v$sql_plan the real execution plan with CURSOR_SHARING_EXACT ? genegurevich_at_discoverfinancial.com wrote:

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 Tue Jun 20 2006 - 09:25:31 CDT