Re: Is it true that view_recompile_jan2008cpu.sql can be run only once during a database's lifetime

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 13 May 2010 15:57:12 +0100
Message-ID: <AANLkTil9mx5LaKp2sa_BGZPASk52xuB8_SER5bV_Zipq_at_mail.gmail.com>

There is a readme with each CPU that contains the view application instructions and does indeed tell you that you don't need to reapply the fix to databases that have already been fixed. I definitely recommend reviewing the CPU readme each quarter to ensure that all of the post patch actions are correctly followed.

Niall Litchfield

On May 13, 2010 3:44 PM, "Mahadevan, Sundar" <Sundar.Mahadevan_at_bmo.com> wrote:

 Hi All,

One of my colleagues said that view_recompile_jan2008cpu.sql should be run only once during a database�s lifetime. I tried to search online to find out if this was true but no luck. May be I cannot get the right key words. My understanding to view_recompile_jan2008cpu.sql is that it is like utlrp.sql to recompile all internal views. Please clarify. Thanks in advance.

--Sundar

--

http://www.freelists.org/webpage/oracle-l Received on Thu May 13 2010 - 09:57:12 CDT