From: Jonathan Lewis <>
Date: Fri, 25 Jan 2013 08:03:17 -0000
Message-ID: <2B63C7F3D75744BFAC140135E119F276_at_Primary>

  • Original Message ----- From: "Saibabu Devabhaktuni" <> To: "free" <> Sent: Friday, January 25, 2013 7:38 AM Subject: RE: CURSOR_SHARING survey

| Chris,
| We don't typically set cursor_sharing to force (unless any application
bug related to not using bind variables is introduced) for the following reasons:
| 1) Any literal predicates that we want to be seen by optimizer for better
execution plan also gets converted to system bind variable. Queries that filter by few types of status or flag column can be hard coded as literals.

Just as a side-note - for special cases the /*+ cursor_sharing_exact */ hint may be a good way to work around that problem.


Jonathan Lewis

Author: Oracle Core (Apress 2011)

Received on Fri Jan 25 2013 - 09:03:17 CET

Original text of this message