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>
> 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
>
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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