cursor sharing

  • From: genegurevich@xxxxxxxxxxxxxxxxxxxxx
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 19 Jun 2006 16:19:20 -0500

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
  • References:

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2006