RE: cursor sharing
- From: genegurevich@xxxxxxxxxxxxxxxxxxxxx
- To: "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 19 Jun 2006 17:11:35 -0500
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@xxxxxxxxx
om> To
Sent by: <genegurevich@xxxxxxxxxxxxxxxxxxxxx
oracle-l-bounce@f >, "'oracle-l'"
reelists.org <oracle-l@xxxxxxxxxxxxx>
cc
06/19/2006 04:46 Subject
PM RE: cursor sharing
Please respond to
ramick@xxxxxxxxxx
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@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
