RE: Is it true that view_recompile_jan2008cpu.sql can be run only once during a database's lifetime
- From: "Pankaj Jain" <pjain@xxxxxxxxxx>
- To: <niall.litchfield@xxxxxxxxx>, <Sundar.Mahadevan@xxxxxxx>
- Date: Thu, 13 May 2010 11:24:30 -0400
We got two answers from Oracle one from the RAC expert and another from
the stand alone database expert.
first one is in favor to bypass recompile, and second one was strongly
in favor of going through this step.
I will forward details from our tar to oracle shortly.
regards
-Pankaj
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Niall Litchfield
Sent: Thursday, May 13, 2010 10:57 AM
To: Sundar.Mahadevan@xxxxxxx
Cc: Oracle-L@xxxxxxxxxxxxx
Subject: Re: Is it true that view_recompile_jan2008cpu.sql can be run
only once during a database's lifetime
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@xxxxxxx> 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
Other related posts:
