Re: Is it true that view_recompile_jan2008cpu.sql can be run only once during a database's lifetime
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: jkstill@xxxxxxxxx, jack@xxxxxxxxxxxx
- Date: Tue, 18 May 2010 09:06:50 -0700 (PDT)
Further modification... Of course I'd add error checking here too ... ;)
Guess I could put this all in a while (patch_not_applied == TRUE) while loop
too....
if [ doubt == TRUE ]
then
go read the documentation.
else
still read the documentation.
fi
while [ still_not_clear == TRUE ]
loop
call support
if [ think_i_know_what_im_doing == TRUE ]
then
break
fi
end loop
if [ you_think_your_clear_now == TRUE ]
then
try_it(environment=>DEVELOPMENT)
fi
if [ it_went_well_in_dev == TRUE ]
then
backup(environment=>PROD)
do_or_do_not_there_is_no_try(environment=>PROD);
validate(environment=>PROD)
fi
Robert G. Freeman
Master Principal Consultant, Oracle Corporation
Oracle ACE
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Blog: http://robertgfreeman.blogspot.com
________________________________
From: Jared Still <jkstill@xxxxxxxxx>
To: jack@xxxxxxxxxxxx
Cc: "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
Sent: Tue, May 18, 2010 9:47:48 AM
Subject: Re: Is it true that view_recompile_jan2008cpu.sql can be run only
once during a database's lifetime
On Mon, May 17, 2010 at 7:33 PM, Jack van Zanen <jack@xxxxxxxxxxxx> wrote:
>
>
>
>When in doubt:
>It is better to run a very quick select aginst the registry$history table
>(select statement is in the patch install guide so you can just cut and paste
>it)
I would modify this a bit: When in doubt, go read the documentation.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
Other related posts:
