RE: cursor sharing
- From: "ramick" <ramick@xxxxxxxxxxx>
- To: <genegurevich@xxxxxxxxxxxxxxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 19 Jun 2006 14:46:14 -0700
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of genegurevich@xxxxxxxxxxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
