RE: Pinning/keeping plans in shared pool
- From: Boris Dali <boris_dali@xxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>, "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>, rjamya@xxxxxxxxx, tanel.poder.003@xxxxxxx
- Date: Mon, 10 Jul 2006 13:12:35 -0400 (EDT)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts: