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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Pinning/keeping plans in shared pool

RE: Pinning/keeping plans in shared pool

From: Boris Dali <boris_dali_at_yahoo.ca>
Date: Mon, 10 Jul 2006 13:12:35 -0400 (EDT)
Message-ID: <20060710171235.3016.qmail@web32807.mail.mud.yahoo.com>


Brandon,

Does your 20-way join come from a stored code or is it a straight SQL?

> So if this white paper is correct, then
> cursor_space_for_time=true won't
> help in my case because the cursor is closed after
> execution

I might be mistaken, but I think it applies to the "closed, but cached" statetments as well, which is the case for any stored code (unless
_close_cached_open_cursors is set to true)

Thanks,
Boris Dali.



Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 10 2006 - 12:12:35 CDT

Original text of this message

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