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

From: Niall Litchfield <>
Date: Thu, 13 May 2010 15:57:12 +0100
Message-ID: <>

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" <> 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.


-- Received on Thu May 13 2010 - 09:57:12 CDT

Original text of this message