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