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@(protected)]
On Behalf Of genegurevich@(protected)
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