Re: Pinning/keeping plans in shared pool

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Sat, 8 Jul 2006 09:06:17 +0200
Message-ID: <c2213f680607080006m1c068002xee2722e7c276e869@mail.gmail.com>

Here we go again with this mess_stats_job. ;-)

Back to the original topic. I just though that it might be useful to check on DBMS_ADVANCED_REWRITE package and see if you can use it to incorporate certain hints that can make parsing fast.

2006/7/7, Allen, Brandon <Brandon.Allen_at_oneneck.com>:
> It appears that one of the 20+ tables was analyzed last night (by the
> gather_stats_job) and that invalidated the plans. Apparently this is

-- 
Best regards,
Alex Gorbachev

http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jul 08 2006 - 02:06:17 CDT