Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> cursor sharing

cursor sharing

From: <genegurevich_at_discoverfinancial.com>
Date: Mon, 19 Jun 2006 16:19:20 -0500
Message-ID: <OFC1D39FC5.C04095E4-ON86257192.0074EB4F-86257192.00750D63@discoverfinancial.com> 





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


Received on Mon Jun 19 2006 - 16:19:20 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US