Re: Cusor sharing = Forced being ignored?
From: Yong Huang <yong321_at_yahoo.com>
Date: Sat, 27 Aug 2011 13:43:04 -0700 (PDT)
Message-ID: <1314477784.77303.YahooMailClassic_at_web80605.mail.mud.yahoo.com>
Cursor_sharing = force or similar has no effect inside PL/SQL. That's a known "issue". See Literal SQL is not shared in PL/SQL block with cursor_sharing set to Force or Similar (Doc ID 285447.1) "Not sharing the statements in a pl/sql block is a design decision and is not a bug."
Date: Sat, 27 Aug 2011 13:43:04 -0700 (PDT)
Message-ID: <1314477784.77303.YahooMailClassic_at_web80605.mail.mud.yahoo.com>
Cursor_sharing = force or similar has no effect inside PL/SQL. That's a known "issue". See Literal SQL is not shared in PL/SQL block with cursor_sharing set to Force or Similar (Doc ID 285447.1) "Not sharing the statements in a pl/sql block is a design decision and is not a bug."
Having cursor_sharing set to force or similar inside PL/SQL actually may do harm. See for examples bugs 12642557, 5073929.
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Aug 27 2011 - 15:43:04 CDT